Create Internal Order Request Ends With Error Unhandled Exception : ORA-01403: No Data Found

(Doc ID 416060.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Purchasing - Version: 11.5.10.2 and later   [Release: 11.5 and later ]
Information in this document applies to any platform.
Create Internal Orders,POCISO

Symptoms

Running Create Internal Orders program (POCISO), the program fails and the log file shows :

Inserting Header : 1991467
Getting the customer id
Getting the customer id: 2733
Top of Fetch Loop
Top of Fetch Loop
.
.
Top of Fetch Loop
Top of Fetch Loop
Unhandled Exception : ORA-01403: no data found


Requisition with header_id 1991467 has lines that do not have distributions. The cause of this is unknown.

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