Import Price Catalogs Fails With Error ORA-06531: Reference To Uninitialized Procedure default_locs_for_blanket.10

(Doc ID 1345973.1)

Last updated on NOVEMBER 01, 2016

Applies to:

Oracle Purchasing - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Executable:POXPDOI - Import Price Catalogs


Symptoms

  Executing Import Price Catalogs - errors are encountered and the import is not successful.

Error:
Review of the concurrent request log reveals the following errors:

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
To get the log messages for PDOI, please use the following id to query against FND_LOG_MESSAGES table:
AUDSID = 11719159
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure default_locs_for_blanket.10
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure default_line_locs.20
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure derive_default_loc_attrs.10
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure create_items.10
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_create_lines_in_group.40
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_sync.80
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.30
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10
ORA-06531: Reference to uninitialized collection in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110
User-Defined Exception in Package po.plsql.PO_PDOI_Concurrent. Procedure POXPDOI.30

Replication Steps:

1. Login to the E-Business Suite and choose the Purchasing Module.
  - Data is loaded and ready for import
2. Navigate - Reports/Run
3. Select request -  Import Price Catalogs - enter parameters
4. Review the concurrent request log - and notice that it has failed

Changes

Upgrading from 12.0 to 12.1.3.

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