POCISO ORA-01403 Create Internal Order Program Is Failing With Unhandled Exception

(Doc ID 2330944.1)

Last updated on NOVEMBER 22, 2017

Applies to:

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

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

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