Import Standard Purchase Orders Failed With Error Message : ORA-06512: At "APPS.PO_PDOI_GRP", Line 398 (Doc ID 2083346.1)

Last updated on MARCH 13, 2017

Applies to:

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

Symptoms

 Import Standard Purchase Orders program log file shows error

POXPOPDOI: Import Standard Purchase Orders
+---------------------------------------------------------------------------+
Current system time is 24-NOV-2015 14:06:59
+---------------------------------------------------------------------------+
**Starts**24-NOV-2015 14:06:59 **SQL error and free**24-NOV-2015 14:07:01 ORACLE error 6510 in FDPSTP
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 398 ORA-06512: at line 1 .
The SQL statement being executed at the time of the error was: SELECT R.Conc_Lo

24-NOV-2015 14:07:01

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE

 

FND LOG shows

ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure setup_line_locs_intf.60;SQLERRM =
ORA-01427: single-row subquery returns more than one row
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_line_locations.7;
SQLERRM = ORA-01427: single-row subquery returns more than one row
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.50;
SQLERRM = ORA-01427: single-row subquery returns more than one row

 

Changes

 

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