Catalog Bulk Load - Items Upload Errors SQLERRM = ORA-22160: Element at Index [1] Does Not Exist (Doc ID 2734067.1)

Last updated on MARCH 15, 2022

Applies to:

Symptoms

On : 12.1.3 version, Catalog Shopping

When attempting to run Catalog Bulkload,
the following error occurs.

ERROR
-----------------------
The loader has encountered an unexpected Purchasing Document Open Interface error. Please run the concurrent program, "Purge Purchasing Open Interface Processed Data" to see the detailed errors.

po.plsql.PO_VAL_SHIPMENTS2.SHIP_TO_ORGANIZATION_ID.0.EXCEPTION ;SQLERRM = ORA-22160: element at index [1] does not exist
po.plsql.PO_VALIDATIONS.VALIDATE_SET.110.EXCEPTION Validation subroutine C_SHIP_TO_ORGANIZATION_ID threw exception;SQLERRM = ORA-22160: element at index [1] does not exist
po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT..validate_line_locs.20.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_LINE_LOC_PROCESS_PVT. Procedure validate_line_locs.20;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_MAINPROC_PVT..process_create_line_locs.10.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_create_line_locs.10;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_MAINPROC_PVT..process_line_locations.90.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_line_locations.90;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_MAINPROC_PVT..process.50.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.50;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_PVT..start_process.110.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = User-Defined Exception
icx.icatalog.loader.CatalogDataTXTUploader LoaderException is oracle.apps.icx.icatalog.loader.LoaderException
icx.icatalog.loader.CatalogLoaderJob failJob.begin
icx.icatalog.loader.CatalogLoaderJob failure message is ICX_CAT_UNKNOWN_PDOI_ERR

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing responsibility > Buyer Workcenter > Agreements
2. Open the BPA > Lines
3. Select "Via Upload" and Go

Changes

Cause

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