Concurrent Program POCIRM Returned Error ( POCIRM-001: ORA-01403: No Data Found) (Doc ID 2139305.1)

Last updated on JUNE 02, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Purchasing Processes

Concurrent program POCIRM returned error ( POCIRM-001: ORA-01403: no data found)

The Requisition Import Program is failing, while we are submitting from back end - but it has failed from concurrent request submission as well.

The following steps have been done before the REQIMPORT program
1. fnd_global.apps_initialize(user_id => FND_GLOBAL.USER_ID, resp_id => FND_GLOBAL.RESP_ID, resp_appl_id => FND_GLOBAL.RESP_APPL_ID)
2. mo_global.init('PO')
3. mo_global.set_policy_context('S', p_org_id)
4. fnd_request.set_org_id(p_org_id)


Error:
POCIRM-001: ORA-01403: no data found

Replication Steps:
The issue can be reproduced at will with the following steps:
1. View Requests - submit request  - single request
2. Query back the Requisition Import
3. Run: Requisition Import Program


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