My Oracle Support Banner

Create Internal Order Program Is Failing With Error 'Unhandled Exception : ORA-01403: no data found' (Doc ID 3007571.1)

Last updated on FEBRUARY 29, 2024

Applies to:

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

Symptoms

On : 12.2 version, Purchasing Processes

Create Internal Order Program Is Failing With Error 'Unhandled Exception : ORA-01403: no data found'


The issue can be reproduced at will with the following steps:

1. Navigation - Purchasing Responsibility --> View --> Requests
2. Submit a New Request --> Submit  'Create Internal Orders'
3. Observe program completed with error.


Error Observed in the log file:

Begin create internal sales order
Updating Req Headers
xx Reqs selected for processing
-----
Top of Fetch Loop
-----
Source Operating Unit: xx
Selecting Currency Code
Currency Code : xx
Selecting Order Type
Order Type ID:xx
Selecting Price List from Order Type
-----
Header not Inserted : xxxxxx
Unhandled Exception : ORA-01403: no data found

 

Changes

 

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
Changes
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.