Unable To Migrate An Purchase Order With A Line Where Ordered Quantity = Cancelled Quantity
(Doc ID 2949744.1)
Last updated on MAY 18, 2023
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.
Unable to migrate a Purchase Order (PO) with a Line where Ordered Quantity = Cancelled Quantity
Need to migrate a PO where Order Quantity = 0 and Qty_Cancelled > 0. It is believed the way to migrate the same is to put Ordered Quantity = Cancelled Quantity.
But this gives an error.
Error ORA-01400: cannot insert NULL into ("RMS01"."ORDLOC"."UNIT_RETAIL") returned by program unit ORDER_SETUP_SQL.ADD_ITEM_TO_PO.
The issue can be reproduced at will with the following steps:
1. Load the attached CREATE_PURCHASE_ORDERS.zip in DC Tool
2. Observe Error in Business Validation
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