11i: R12: AP: Error in Payables Open Interface Import Program "APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: NULL index table key value occurred in AP_CHARGE_ALLOCATIONS_PKG.insert_allocations<-prorate_dists<-Create_lines<-Import_invoices"
(Doc ID 2980085.1)
Last updated on OCTOBER 12, 2023
Applies to:
Oracle Payables - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
The Payables Open Interface Import program used to import invoices ends in error. Below error message is noted in the log file:
ERROR
-----------------------
ORA-20001: APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: NULL index table key value occurred in
AP_CHARGE_ALLOCATIONS_PKG.insert_allocations<-prorate_dists<-Create_lines<-Import_invoices
-----------------------
ORA-20001: APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: NULL index table key value occurred in
AP_CHARGE_ALLOCATIONS_PKG.insert_allocations<-prorate_dists<-Create_lines<-Import_invoices
The issue can be reproduced at will with the following steps:
1. Insert invoices into ap_invoices_interface and ap_invoice_lines_interface using SQL Loader.
2. Login to Oracle Applications and go to Payables responsibility.
3. Navigate to View > Requests > Submit a New Request.
4. Submit Payables Open Interface Import program.
5. It ends in error with above message in the log file.
Changes
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 |
Changes |
Cause |
Solution |