My Oracle Support Banner

Create Internal Order Request Ends With Error Unhandled Exception : ORA-01403: No Data Found (Doc ID 416060.1)

Last updated on MARCH 02, 2023

Applies to:

Oracle Purchasing - Version 11.5.10.2 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

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.