My Oracle Support Banner

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 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

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