My Oracle Support Banner

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:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Catalog Shopping

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

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

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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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