My Oracle Support Banner

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 later
Information 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


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