POCISO ORA-01403 Create Internal Order Program Is Failing With Unhandled Exception (Doc ID 2330944.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Symptoms

On : 12.1.3 version, Reports - PO and RCV

Create internal order program is failing with unhandled exception (POCISO)

After applying RPC 5 patches and now this program is failing with Unhandled Exception : ORA-01403: no data found



POCISO: Create Internal Orders
+---------------------------------------------------------------------------+

Current system time is 21-SEP-2017 16:21:35

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Begin create internal sales order
Updating Req Headers
180 Reqs selected for processing

Header not Inserted : ******
Unhandled Exception : ORA-01403: no data found
+---------------------------------------------------------------------------+


ERROR
-----------------------
Unhandled Exception : ORA-01403: no data found




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Purchasing
2. Run Request
3. Select
POCISO: Create Internal Orders

Cause

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