In the beginning of every month whenever we try to perform any oracle transactions like RTP, MTL transactions etc. the program goes into error due to Closed Periods. For performing these transactions successfully we mainly require following periods to be open on our instances:
- Purchasing Period
- Payables Period
- General Ledger Period
- Inventory Periods
It's quite easy to open or close these periods in R12. You can follow the steps below to open or close these periods in Oracle Apps R12.
How to Open Purchasing Period In Oracle Apps R12
1. Navigate to the following path:
Purchasing SuperUser->Setup->Financials->Accounting->Control Purchasing Periods
and enter the Fiscal year and click "Go" button as shown in the following screenshot:
Note: If it prompts for selecting Operating Unit, select it and click Go button.
2. Now open the periods by changing the "Period Status" and click on "Save" button.
How To Open Payables Period In Oracle Apps R12
1. Navigate to the following path:
Payables Super User ->Accounting->Control Payables Periods
Or
Payable Manager->Accounting->Control Payables Periods
And open the periods by changing the "Period Status" to "Open" and click on Save button as shown in the following screenshot:
How To Open General Ledger(GL) Period In Oracle Apps R12
1. Navigate to the following path:
General Ledger Super User->Setup->Open/Close
when the form open select the desired Ledger from the LOV and click on "Find" button.
After clicking on Find button following form will open. Now open the required periods by clicking on “Open Period” button, select the required period as "Target Period" and click Open button.
Ensure to Save the transactions.
How To Open Inventory Period In Oracle Apps R12
1. Navigate to followin gpath:
Inventory SuperUser->Accounting Close Cycle->Inventory Accounting Periods
and select the Inventory Org from LOV.
2. Select the period to be opened and click on "Change Status" button as shown in the following screenshot:
It was very useful for me. Keep sharing such ideas in the future as well. This was actually what I was looking for, and I am glad to came here! Thanks for sharing the such information with us.
ReplyDeleteHi Niteesh,
ReplyDeleteSeems like I won the lottery here…. This is a treasure box of blogs and your folks are like leprechauns! Phenomenal read on How to Open Or Close Different Periods In Oracle R12!!
I'd like to be able to log all constraint errors when users are running an application having Oracle as the back-end. That means inserting a record into an Errors Log table in Oracle.
Is that even possible? In an exception clause, I could do that; however, when a constraint fails, I don't know where I'd be able to run such code to do the insert.
Is this even possible?
Thanks for any help you can give.
Wayne
Appreciate your effort for making such useful blogs and helping the community.
Merci,
Lee