My Oracle Support Banner

R12 PAAPIMP PRC: Interface Supplier Cost Process Is Fails with ORA-22160: element at index [nn] does not exist (Doc ID 1447560.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Project Costing - Version 12.1.1 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.
ConcurrentProgram:PAAPIMP_SI - PRC: Interface Supplier Costs


Symptoms

The PAAPIMP PRC:  Interface Supplier Cost process errors with the following in the log file:

Request log displays:

05:42:12: Error Code is -22160
05:42:12: ORA-22160: element at index [31] does not exist
05:42:12:
05:42:12: Error occured in stage: calling bulk_update_trx_intf within transfer_inv_to_pa, PAAPIMP aborted!
05:42:12: ORA-22160: element at index [31] does not exist

However, if PA: Debug Mode profile is set to Yes, the request log file may display:

10:26:11: Failed during bulk insert for invoice processing
10:26:11: Error Code is 100
10:26:11: ORA-01403: no data found
10:26:11:
10:26:11: Error occured in stage: calling bulk_insert_trx_intf within transfer_inv_to_pa, PAAPIMP aborted!
10:26:11: ORA-01403: no data found

 

 

Internal testing proved the issue occurs when the process adjustments procedure is called.  Hence the below mentioned test cases were tested.
  1. Cancel an AP Invoice with tax code
  2. Cancel an AP Invoice with SAT tax code
  3. Cancel Funds check passed AP Invoice with SAT tax code

Cause

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
Symptoms
Cause
Solution
References


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