SQL Query to Check the sequence of Lot Cost Transactions and batches that cross period
(Doc ID 1466945.1)
Last updated on AUGUST 07, 2024
Applies to:
Oracle Process Manufacturing Financials - Version 12.1.1 and laterInformation in this document applies to any platform.
Symptoms
Lot Costs
ACTUAL BEHAVIOR
---------------
Needs a SQL Query to identify the out of Synch WIP Completion, WIP Issue and return transactions for the lot cost process.
Legacy system creates these transactions and has wrong transaction dates.
EXPECTED BEHAVIOR
-----------------------
Lot cost process should cost correctly
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. OPM Financials Responsibility
2 Navigate to the Lot Cost -> Lot Cost process screen
3 Submit the request
Changes
Allow negative inventory consumption: ( Navigation> Inventory> Setup> Organization> Parameters >See if the "Allow Negative Balance" box is checked.)
Since organization allows negative inventory, consumptions prior to yields can be done (in fact this is issue's most common scenario). This sequence causes problems to lot costing.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |