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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.