My Oracle Support Banner

Autocreate Purchase Requisition Unable to Derive the DELIVER_TO_LOCATION_ID (Doc ID 2419156.1)

Last updated on APRIL 27, 2019

Applies to:

Oracle Configure to Order - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Purchasing Processes

When attempting to Auto Create purchase Requisition program it is failing with error stating that no location defined for the shipping organization,
the following error occurs.

In the Logs:
GET_DELIVER_TO_LOCATION_ID_ER: No Location is defined for the shipping organization.
GET_DELIVER_TO_LOCATION_ID_ER: Please define a location for the shipping organization in Org status.

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Create the Sales Order - save and book. 
2. Progress the order.
3. Run the Autocreate Purchase Requisition process.
4. Find it is not able to insert the requisition data.


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.