Import Orders Stuck at Wait Status (Doc ID 2163687.1)

Last updated on FEBRUARY 21, 2017

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Purchasing - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Process ID 43543 is stuck at Wait Status.

Log file contains :

oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20001: po.db.plsql.PO_PDOI_PVT..start_process.80
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_PVT", line 348
ORA-20001: po.db.plsql.PO_PDOI_PREPROC_PVT..process.40
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_PREPROC_PVT", line 197
ORA-20001: po.db.plsql.PO_PDOI_PREPROC_PVT..derive_vendor_id.10
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_PREPROC_PVT", line 1753
ORA-20001: po.db.plsql.PO_PDOI_UTL..generate_ordered_num_list.0
ORA-06512: at "FUSION.PO_MESSAGE_S", line 376
ORA-06512: at "FUSION.PO_PDOI_UTL", line 977
ORA-20101: The size exceeded the maximum value 10000
ORA-06512: at line 1

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