Requisition Import Errors With - SECONDARY_UNIT_OF_MEASURE "This Item Is Defined To Be Tracked In Its Primary Unit Of Measure Only. A Secondary Unit Of Measure Is NOT Required"
(Doc ID 3036977.1)
Last updated on SEPTEMBER 17, 2024
Applies to:
Oracle Order Management - Version 11.5.10.2 and laterOracle Purchasing - Version 11.5.10.2 and later
Information in this document applies to any platform.
Symptoms
Trying to implement Drop Ship Sales Orders but having an issue with Requisition Import. Requisition Import fails in po_requisition_interface_all table. The po_requisitions_interface_all.secondary_uom_code is populated with "SQF" and it should be null. The Item has a Primary UOM = "Pallet" and no secondary uom. When the order gets created, the oe_order_lines_all.ordered_quantity_uom2 is somehow getting populated with "SQF"
ORDERED_QUANTITY_UOM2 is causing a problem in Requisition Import. Need to selectively leave the ordered_quantity_uom2 blank for specific Drop Ship Items.
ERROR (Reported in the Requestion Import request log)
SECONDARY_UNIT_OF_MEASURE - This item is defined to be tracked in its primary unit of measure only. A secondary unit of measure is NOT required.
The issue can be reproduced at will with the following steps:
1. Create a drop ship order
2. Progress the order
3. Run Requisition Import - Fails due to secondary_uom_code
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 |
Cause |
Solution |
References |