My Oracle Support Banner

CTO: Requisition Creation Failing For Sales Order Lines With Operating Unit Different From Operating Unit For Shipping Warehouse (Doc ID 3027242.1)

Last updated on JUNE 08, 2024

Applies to:

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


 In the "Configure To Order" flow,
While autocreating requisitions via the concurrent program - "CTOACREQ: AutoCreate Purchase Requisitions",
the program completes with the below error:

GET_DELIVER_TO_LOCATION_ID_ER:: Other::70::ORA-01403: no data found

Steps to Replicate

  1. Login to Order Management Responsibility
  2. Create a Sale order for an ATO item in OU1. SO line operating unit will be OU1, whereas the shipping warehouse operating unit will be OU2
  3. Book the Sale order
  4. Run AutoCreate Purchase Requisitions program for this Sale Order
  5. Find that the program ends in error.


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.