E1: 41: Item Ledger (P4111) Shows Primary UoM Quantity From Lot Master Instead of Showing From Item Ledger Transaction When It Was Received (Doc ID 2989533.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Symptoms

Cardex (P4111) program is incorrectly showing receipts (OV Doc type) records primary quantity UoM after the item potency is changed via Lot master (P4108), which happens due to tests to determine the real item potency after purchase order receipt. After Potency changes in P4108, the Primary UoM quantity displays as 10 KA instead of 9.5 KA, which was the quantity received at receipt time.

The issue can be duplicated with following steps:

Setup:

1. P4101 – Create item master for item # FGPOT (FG POTENCY ITEM) - Additional System Info – Grade and Potency TAB – 95%.
2. P41026 – Create a new Item Branch (30) for Item # FGPOT (FG POTENCY Item) - Additional System Info – Grade and Potency TAB – 95%.
3. Item unit Of Measure (UoM) Conversion:
   From UoM = Quantity To UoM    
   1 DR         =  40.000000 KG
   1 KA         =   1.000000 KG
   1 UN        =  40.000000 KG
4. UDC 00/UM - Make sure the KA UoM has Special Handling Code set to value "VP" and KG UoM has Special Handling code set to W:
   Codes  -  Description 01      -  Special Handling
   KA        -  Kilograms Active   -  VP
   KG        -  Kilograms             -  W   

Steps:

1. P4310 – Create a new purchase order for item FGPOT, Qty = 10 KG Transaction UoM.
2. P4312 – Receive the item lot with Potency 95%, Lot # 20231122004, transaction UoM Qty 10 KG. Click Ok to confirm.
3. P4111 – OV Transaction created in the Cardex shows:
   Doc #   Doc      Qty    Trans    Qty     Primary  
               Type              UoM                UoM
   -------------------------------------------------------
   564826  OV     10     KG          9.5     KA  
4. P41202 – Item availability.
5. P4108 - Lot potency is changed to 100% in lot master after retesting the lot. Save it.
6. Back to item ledger inquiry P4111 – It shows additional record for the potency change, Doc Type CP however, the OV transaction is update with 10.00 KA for Qty Primary UoM instead keep it at 9.5 KA:
   Doc #   Doc      Qty    Trans    Qty     Primary  
               Type              UoM                UoM
   -------------------------------------------------------
   564826  OV     10     KG          10     KA
7. P41202 – Item availability also changed to 9.5.
   
   

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.