Importing Purchase Orders Using PDOI Errors With "Enter value for 12:EXEC FND_CONC_STAT.COLLECT" "ORA-06510 : PL/SQL: unhandled user-defined exception" (Doc ID 735909.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Purchasing - Version: 12.0.4 and later   [Release: 12 and later ]
Information in this document applies to any platform.
ConcurrentProgram:POXPOPDOI - Import Standard Purchase Orders

Symptoms

When attempting to import Purchase Orders using the open interface, the import program errors out with the following error :

Error of standard interface program
Enter value for 12: EXEC FND_CONC_STAT.COLLECT;
Enter value for 14:
DECLARE
*
ERROR at line 1:
ORA-06510 : PL/SQL: unhandled user-defined exception
ORA-06512 : at line 133

 

Steps to Reproduce :

1 - Populate interface tables with PO data.

2 - Run Import Standard Purchase Orders 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