My Oracle Support Banner

DCA - PO ORDLOC_EXP Error - "Order/item/location does not exist" (Doc ID 2860191.1)

Last updated on APRIL 07, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 to 19.2 [Release 19.2]
Information in this document applies to any platform.


During the load of POs, some of the POs were changing their status into Worksheet. This is happening due to the following error - "Order/item/location does not exist"


When ordering a pack item, the Pack is in the ORDLOC.ITEM but ORDLOC_EXP.ITEM will be for the components and the ordered item will be in the PACK_ITEM field. It seems that DCA is always validating the order/item/location from ORDLOC_EXP table against ORDLOC table, not taking into consideration if the orderable item is a pack or not. When both the pack and their components are there in ORDLOC, the issue doesn't happen, but if only packs are ordered, the issue happens.


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.