Showing posts with label OM. Show all posts
Showing posts with label OM. Show all posts

VIEWING PENDING TRANSACTIONS (Resolving Period Close Pending Transaction R12 or Inventory Closing Steps in Oracle Apps R12 )



VIEWING PENDING TRANSACTIONS


You can view the number of pending transactions by navigating to the Inventory Accounting Periods form.


Navigate > Cost > Accounting Close Cycle > Inventory Accounting Periods






The Resolution Required displays the number of Unprocessed material, Uncosted material/WSM, Pending WIP Costing, Pending WSM interface and Pending LCM Interface transactions existing in this period. 



The Resolution Recommended zone displays the number of Pending Receiving, Pending Material and Pending Shop Floor Move transactions existing in this period. However, once the accounting period is closed, unresolved transactions in this zone cannot be processed because they have a transaction date for a closed period.



Resolution Required Transactions:


"Uncosted Material/WSM" indicates there are transactions in the MTL_MATERIAL_TRANSACTIONS table with unprocessed accounting entries. 

"Pending WIP Costing" transactions indicate there are unprocessed resource and overhead accounting transactions in the WIP_COST_TXN_INTERFACE table.
"Pending WSM interface" indicate there are pending transactions in the WSM_SPLIT_MERGE_TXN_INTERFACE table. 

"Pending LCM Interface" indicated there are pending transactions in the CST_LC_ADJ_INTERFACE table.

Resolution Recommended Transactions:

"Pending Receiving" transactions indicate there are unprocessed purchasing transactions in the RCV_TRANSACTIONS_INTERFACE table. These transactions include purchase order receipts and returns for inventory. These transactions are not included in your receiving value if they are not resolved prior to closing the period. 

"Pending Material" transactions indicate there are unprocessed material transactions in the MTL_TRANSACTIONS_INTERFACE table. 

"Pending Shop Floor Move" transactions indicate there are unprocessed shop floor move transactions in the WIP_MOVE_TXN_INTERFACE table.

Unprocessed Shipping Transactions:


The Unprocessed Shipping Transactions zone displays the number of Pending Transactions existing in this period. Transactions appearing in this zone must be resolved before the period can be closed, depending if the Resolution 'Required' or 'Recommended' is checked. 

"Unprocessed Material" indicate there are unprocessed material transactions in the MTL_MATERIAL_TRANSACTIONS_TEMP table .

"Pending Transactions" in the Unprocessed Shipping Transactions zone indicate there are transactions in the WSH_DELIVERY_DETAILS table in a status of shipped.


For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide

Ref -: Oracle Doc (Doc ID 1069492.1)


How can Create Document Sequence in r12 for Order Management Transaction Type like "Mixed"

Document Sequence

Go to 

Order management Responsibility < Orders, Returns < Sales Order 





Make a sales Order for Check the Sales Order Number for Mixedtransaction type.










Now Sales Order Number Series are 1000. And we want to start sales order number with 1.




Now Go to

Setup < Documents < Define

Define sequence with the name “Doc_Seq_Mixed” And create a sequence with initial value ‘1’.

Note -: You can manage it accordingly and if you want to make it manual then select TYPE Manual.














Now Save it.




Go to

Setup < Documents < Assign







Select Categories Mixedfor Transaction Type “MIXED”.







Select Ledger name “Vision Operation (USA)”.







Now Go to Assignment tab .







Assigned Define sequence “Doc_Seq_Mixed”.








Note -: If there are any existing Sequence for the particular time period then firstly fill end date for that sequence.

Now Again Create the Sales Order and check the Series number for transaction type “MIXED”.














Thus we can change the sequence number for any transaction type in order management and another application also.

Now enjoy your Successful development.


For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide

Error: This action cannot be performed on all selected records.

Error: This action cannot be performed on all selected records.
 

You have not been assigned role to do shipping activity.

For “Grants and Role” Go to: Setup --> Grants and Role Definitions --> check Grants & Define Roles form.


Follow given steps.


1) Go to  OM Super user responsibility and Go to Setup --> Shipping --> Grants and Role Definitions --> Define Roles


2) Go to Super user responsibility and Go to Setup --> Shipping --> Grants and Role Definitions --> Grants

And Save it.

3) Now try to ship confirm and ship confirm option will be enabled for this User.

Now Error  "Error: This action cannot be performed on all selected records." will not come.

For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide