E1: 43: P4312 Purchase Order Receipts Direct Ship Dual UOM Conversion Manually Input Secondary Quantity Reverts to Item UOM Conversion (Doc ID 2963052.1)

Last updated on AUGUST 14, 2023

Applies to:

Symptoms

The customer buys large rolls of raw paper via direct ship orders which are never the same square meters per roll due to the manufacturing process. These rolls are then made into corrugated cardboard boxes. The customer typically receives up to 26 rolls at a time and each roll has an assigned lot number for quality control. So for example the item UOM conversion will 1 roll (RL) = 177 square meters (SM) but when the rolls are received you may have 1 RL = 175 SM, 1 RL = 170 SM, etc. Primary UOM is SM since it is the smallest UOM. Dual UOM setup is used to accommodate the varying square footage of each roll. According to E1: 43: Enhancement to Allow Manual Entry or Change of Secondary Quantity SQOR in P4310 For Dual UOM Items (Doc ID 2366383.1) and E1: 42: Unable to Retain Override Secondary Quantity for Dual Unit of Measure (UOM) Item in Sales Order Entry (P4210/P42101) (Doc ID 2376851.1) only Shipment Confirmation (P4205) and PO Receipts (P4312) allow users to override the secondary quantity, for example when goods are leaving or arriving at a warehouse. However when receiving multiple rolls at a time into multiple location/lots the overridden secondary quantity is converted back to the item UOM conversion for all lines after the first line and if the total quantity is greater than that on the original order quantity error "Direct Ship Over Receipt Not Allowed" is set.

Replication Steps:

1) P4101/P41026. Setup a dual UOM item as follows.

Primary UOM = Square Meters (SM) (smallest UOM)
Secondary UOM = Roll (RL)
Uom conversion 1 RL = 171 SM.

2) P4210. Enter a direst ship order for 5 rolls (RL).

3) P4312. Receive the 5 rolls by either entering 4 as an option or take the multiple location exit and enter the following for each roll.

Quantity = 170 SM, Secondary Quantity = 1, Lot/Serial = X1, X2, X3, X4, X5. Select the lines and notice in the P4312 detail grid only the fist line retained the secondary quantity as input. All other lines used the UOM conversion of 1 RL = 171 SM. This is incorrect. Click OK to receive the order.

4) P4210. Inquire on the order and notice the first line retained the correct secondary quantity of 1 roll and all other lines show a fraction of a roll.

5) R42565. Run invoice print and note the incorrect secondary UOM are printed. This is a customer facing PDF.

6) Repeat steps 1 to 3 but this time enter quantities that are greater than that on the original order quantity.

Quantity = 172 SM, Secondary Quantity = 1, Lot/Serial = X1, X2, X3, X4, X5. Select the lines and notice in the P4312 detail grid only the fist line retained the secondary quantity as input. Click OK and error "Direct Ship Over Receipt Not Allowed" is set and you cannot proceed. Since this is a dual UOM item one should be allowed to over receive the direct ship order.

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.