Requisition Import errors with POCIRM-137: ORA-01427: single-row subquery returns more than one row

(Doc ID 1673087.1)

Last updated on JUNE 01, 2016

Applies to:

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

Symptoms

When attempting to run Requisition Import, the following error occurs.

ERROR
-----------------------
Cause: POCIRM encountered an internal error. Parameters: REQIMPORT,DAVIDM,,ALL,,N,Y,

Action: Note both this error number and the actions you are trying to perform. Contact your sys
POCIRM-137: ORA-01427: single-row subquery returns more than one row
  

Cause: A SQL error has occurred in POCIRM. The SQL error is &LSQL_ERR.

Action: Take note of both this error number and the actions you were
Cannot read value for profile option REQIMP_AUTORELEASE in routine &ROUTINE.


Issue occurs only for specific set of Data and not for all. Same requisition can be created with success using the form.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From External source to populate the interface table
2. Run Requisition Import process
3. Error occurs



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