E1: 42: Sales Order Revision (P4210) Recalculates Secondary UoM After an Order Line for Dual UoM Item Has Been Pack Confirmed With Shipment Confirmation (P4205) Application (Doc ID 2831922.1)

Last updated on FEBRUARY 17, 2022

Applies to:

Symptoms

Currently, Sales Order Revision (P4210) application recalculates secondary quantity on dual UoM item when user inquire to lookup or adjust price for a sales order after it has been Pack Confirmed. Using Ship Confirmation (P4205) application with processing options #4 (Relieve On Hand Inventory) set to value "1" to not relieve inventory; user at the moment of Pack Confirmation, using the Select Multiple Location screen selects lot in the inventory like 2179 Lb = 110 PCs.  Customer is a Company in food sector (i.e. cheese) where a pallet can be sold and the primary unit of measure be 2196 Lb while the number of pieces in the pallet is 110.00 for a UoM Conversion of 1 Pallet = 110.00 Pieces which gives also 1 PC = 20Lb. The given reason is that, while producing the unit (piece) it can wait more or less, not something that can be controlled to make it match the standard UoM conversion.  

By the current design of the system, doing pack confirm populates field Committed (Alias: COMM) to value "H" (Hard Committed) however, it does not populate field On Hand Updated in F4211 (Alias: SO02) and so, the system do not take the order as hard committed. Even though Committed field is set to "H" if SO02 field is not populated, system recalculates the secondary UoM any time F4211EditLine business function is invoked via P4210 application. This is a problem for customer who have already selected, hard commit the lot to that specific line.

Steps:

1. P4101 – Item Setup - Make sure to item setup with Dual UoM
2. P41202 – Item Availability - Available lots where UoM conversion to primary UoM does not follow standard UoM conversion
3. P4210 – Using a version set to not check availability (Commit TAB) Option #1 = blank, enter a sales order for item with Dual UoM –300 Pieces / 6000Lb
4. P4915 – Approve Shipment
5. R42520 – Pack Confirm the order which will hard commit from different lot/location. See that, order committed to multiple locations
6. P4205 – Pack Confirmation, partially. Select lots with availability.
7. Click green check mark to save it.
8. P4210 – Inquire the order and see that, line 1.000 still shows Sec. Qty = 110.00 PC /  2196 Lb as when it was pack confirmed
9. P4210 – It happens that sometimes, a price adjust needs to be manually corrected, user just access the line to double check. Select the line and take Row exit to Price History.
10. P4074 – Lookup and close it, no changes  
11. P4210 – Back in sales order screen, still no changes and move cursor to next line and see, secondary UoM is recalculated based in UoM conversion.
12. P41202 – See the availability screens for the lots pack confirmed, showing discrepancies between primary and secondary UoM

Cause

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