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

Last updated on APRIL 04, 2025

Applies to:

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

Cause

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