Period opening in
oracle apps R12
Financial period/purchasing periods are controlled at
operating unit level however Inventory period is controlled at inventory
organization level.
Open Financial GL/AP Periods
1. GL Period
First open accounting period in GL
Switch to GL Responsibility
N> General Ledger-->Setup-->Open/Close
once open period in GL, all subsequent requests should be completed
N> General Ledger-->Setup-->Open/Close
once open period in GL, all subsequent requests should be completed
2. AP Period
Switch to Payables responsibility
N> Payables-->Accounting-->Control Payables Periods
Open the same period
N> Payables-->Accounting-->Control Payables Periods
Open the same period
3. PO period
Open Purchasing period
Switch to purchasing super user responsibility
N>Setup
-> Financials-> Accounting- > Control
Purchasing Periods
4. Inventory organization period
Open Inventory Organization period
Switch to purchasing super user responsibility
N>Inventory ->Accounting Close Cycle ->
Inventory Accounting Periods
Concurrent
program:-
Open period control request is used to open inventory
periods for one or multiple inventory organizations. By passing inventory
organization as parameter you can open an inventory period for all inventory
organizations
Switch to Inventory Super User
N> Reports -> Transactions -> Select Name of the
report ‘Open Period Control’ -> Enter parameters -> Click OK -> Click
Submit
Closing Inventory
Period
Oracle Inventory uses accounting periods to group
material transactions and work in process transactions for accounting purposes.
So normally these deatils are grouped for a month and the transaction details
are posted to GL.
An automatic general ledger transfer is processed when you close an accounting period.
An automatic general ledger transfer is processed when you close an accounting period.
A.
Pending
transactions
Before closing the inventory
transactions make sure all pending transactions are resolved.
Resolution
Required On the pending transactions window it shows number of
transactions with resolution required
It displays the number of
unprocessed material transactions, uncosted material transactions, and pending
WIP costing transactions existing in this period. These must be resolved before
the period is closed.
Resolution
Recommended Displays the number of pending receiving
transactions,
pending material transactions, and pending shop floor move transactions existing in this period. You can close the accounting period; however, after it is closed these transactions cannot be processed.
pending material transactions, and pending shop floor move transactions existing in this period. You can close the accounting period; however, after it is closed these transactions cannot be processed.
B.
Close a open/error status period
You can close the accounting
period for a month with the status of Open or Error.
Pending transactions in detail
1. Pending receiving transactions
Unprocessed receiving
transactions with table RCV_TRANSACTIONS_ INTERFACE
These transactions include
purchase order receipts internal order receipts and returns for inventory
If you close the period,
these transactions cannot be processed because they have a transaction date for
a closed period
2. Unprocessed material transactions
Unprocessed material transactions with the table MTL_MATERIAL_TRANSACTIONS_TEMP If you have unprocessed inventory transactions you will not able to close the period and is so because it has a transaction date for a closed period.You can look in details by inventory super user N> Transactions ->Pending transactions
3. Pending transactions
Unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table
If you close the period, these transactions cannot be processed because they have a transaction date for a closed period
4. Uncosted material transactions
Material transactions in the MTL_MATERIAL_TRANSACTIONS table with no accounting entries (Standard Costing) and no accounting entries and no costs (Average Costing). You are unable to close the period with this condition.
5. Pending move transactions
Unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table.
You are unable to close the period with this condition.
6. Pending WIP costing transactions
Unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table. You are unable to close the period with this condition.
Once you are sure that you are ready to close the inventory period you can come back to the main inventory accounting periods form and click change status button in and select Close and be sure that INVENTORY PERIOD CLOSED CANNOT BE REOPENED (This is a irreversible process).
2. Unprocessed material transactions
Unprocessed material transactions with the table MTL_MATERIAL_TRANSACTIONS_TEMP If you have unprocessed inventory transactions you will not able to close the period and is so because it has a transaction date for a closed period.You can look in details by inventory super user N> Transactions ->Pending transactions
3. Pending transactions
Unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table
If you close the period, these transactions cannot be processed because they have a transaction date for a closed period
4. Uncosted material transactions
Material transactions in the MTL_MATERIAL_TRANSACTIONS table with no accounting entries (Standard Costing) and no accounting entries and no costs (Average Costing). You are unable to close the period with this condition.
5. Pending move transactions
Unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table.
You are unable to close the period with this condition.
6. Pending WIP costing transactions
Unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table. You are unable to close the period with this condition.
Once you are sure that you are ready to close the inventory period you can come back to the main inventory accounting periods form and click change status button in and select Close and be sure that INVENTORY PERIOD CLOSED CANNOT BE REOPENED (This is a irreversible process).
5 comments:
Hi Ajay,
Thanks a lot for the info.
Just wanted to know how to Automate the Inventory Periods to open and close for all sites once purchasing period has been closed.
sites with pending transactions will not be closed and an email will be sent as an alert.
Any info on this is a welcome.My email id is dllcharan@gmail.com.
Cheers
You can create concurrent program using API in which you can achieve the requirement.
Morris Tutoring Services was started in 2010 to help people throughout the world learn and refresh their understanding of basic accounting and bookkeeping at no cost. This free website contains explanations of major topics, Q&A, quizzes, and much more. Our 1,553 glowing testimonials indicate that our materials are more clear than textbooks costing hundreds of dollars.
Thanks for the given information you are providing content very usefull to users.
Learn Register the Report from Back End in Oracle Apps R12 Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.
Hurry-Up Enroll Now and get Free Access to the Entire Course
Thanks for the given information you are providing content very usefull to users.
Learn Complete GL Interface Program in Oracle Apps R12 Actual cost of this course is 3,200/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.
Hurry-Up Enroll Now and get Free Access to the Entire Course
Post a Comment