Oracle Inventory Period Closure - Inventory Accounting period

 

 

 Inventory Periods:

 
Accounting Close Cycle > Inventory Accounting Periods

 

Inventory period closure we have 3 main tabs where we should have to maintain records as Null

 

Resolution Required:    

 

Here we have to provide solution for closure the inventory periods. If any data exist in these fields. Inventory will not allow for closing the periods.

 

• Unprocessed material

There are transactions on Unprocessed material transactions that can be stored in MTL_MATERIAL_TRANSACTIONS_TEMP table

View Transactions->Pending transactions

• Uncosted material/WSM

There are transactions in the MTL_MATERIAL_TRANSACTIONS table with unprocessed accounting entries

Check Cost managers are running properly and also validate the cost flag for processed transactions.

MTL_MATERIAL_ TRANSACTIONS where the costed_flag = ‘N’ or ‘E’ (N-NO E-ERROR)

to see those information in front end use the navigation
 View Transactions> Material Transactions

• Pending WIP Costing

Transactions that are unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table

• Pending WSM interface

There are pending transactions in the WSM_SPLIT_MERGE_TXN_INTERFACE table. 

• Pending LCM Interface transactions 

There are pending transactions in the CST_LC_ADJ_INTERFACE table. 

 

Unprocessed Shipping Transactions:

Here we have to provide solution for closure the inventory periods. If any data exist in these fields. Inventory will not allow for closing the periods.

 

If delivery does not get interfaced and struck in “shipped” there we could see the data in unprocessed shipping transactions

 
OM module > Shipping > Transactions

table name:
WSH_DELIVERY_ DETAILS
Shipping or OM> Interface > Run > Trip Stop SRS to run the Trip Stop interface

Resolution Recommended:

Here, if we have any records exist system still allow for closure the period for the month. Whatever the data exist and we are closing inventory periods, those transaction would be carryforward to next month.

• Pending Receiving:

PO Receipt Transactions that are error out.
Receiving transactions are always using interface table. Sometimes random transaction will be error out some unexplained reasons.

table name:
RCV_TRANSACTIONS_ INTERFACE
table used to populated external receiving transactions

We could see data in “Transaction Status Summary” form.

• Pending Material:

If transaction data gets errored or pending it will get struck in transaction Open interface. There might be the cases of negative transactions and Wip issues, ship confirmation issues.

table name: 
MTL_TRANSACTIONS_INTERFACE

To see that information in front end use the navigation
Transactions> Transaction Open Interface

 

• Pending Shop Floor Move:

If any data get struck in pending move transactions, then it will have record exist in here, it will have WIP completion related issues.

 

VENKATESH MITTIKAYALA