E1: 31A: In P48270 "One View Work Order Cost Analysis Inquiry" Calculated Column "P/L Primary Transaction Quantity" Displays Incorrect Quantity With Partial Issue When Parts List UOM And Primary UOM Are The Same (Doc ID 2975084.1)

Last updated on DECEMBER 27, 2023

Applies to:

Symptoms

The calculated quantity column "P/L Primary Transaction Quantity" in P48270 displays incorrectly when the Parts List UOM and Primary UOM are the Same. For a partial issue, the "P/L Transaction Qty" in the P/L UOM should not Equal the "P/L Order Quantity" when both are in the same UOM. When the P/L UOM is not equal to the Primary UOM the Quantities are correct.


The Transaction Qty for a Partial Issue for both the Transaction UOM and the Primary UOM should always be for the Partail Qty when both are in the same UOM.

The issue can be reproduced at will with the following steps:
1. Create a Component item with a UOM Conversion to Primary (ex. 1 Bundle = 14 EA)
2. Create a WO with the Parts List in EA Primary UOM)
3. Create a WO with the Parts List in the non-Primary UOM
4. Perform a Partial Issue on both WOs (note the problem is not noticeable on a full issue).
5. Review the WOs in P48270 and confirm that P/L Transaction Qty in Transaction UOM vs. P/L Transaction Qty in Primary UOM is incorrect when the transaction was done in Primary UOM. It is showing the Order Qty as the Transaction Qty.

Changes

Cause

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