CTOACREQ module: AutoCreate Purchase Requisitions failing with ORA-01403 (Doc ID 1948962.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.5.10.2 version, Transaction Fulfillment

When attempting to run "CTOACREQ module: AutoCreate Purchase Requisitions" concurrent program the following error occurs.

ERROR
-----------------------
NO HOLDS FOUND FOR ATO LINE ID: 13439605
EXITING OE_HOLDS_PUB.CHECK_HOLDS_ATO
CHECK_HOLDS: CHECKING FOR CONFIG VALIDATION HOLD
IN OE_HOLDS_PUB.CHECK_HOLDS_SMC
NO HOLDS FOUND FOR TOP MODEL LINE ID:
EXITING OE_HOLDS_PUB.CHECK_HOLDS_SMC
EXITING OE_HOLDS_PUB.CHECK_HOLDS
auto_create_pur_req_cr: Success in Check Hold S
Post Processing Lead time: 0
auto_create_pur_req_cr: AUTO_CREATE_PUR_REQ_CR::exp error::39::ORA-01403: no data found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log Into Order management Responsibility
2. Navigate to Requests, Reports> Run request
3. launch ' AutoCreate Purchase Requisitions'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms