SQL Query to Check the sequence of Lot Cost Transactions and batches that cross period

(Doc ID 1466945.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


On : 12.1.2 version, Lot Costs

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.

Lot cost process should cost correctly

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


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. 


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms