R12 AP: Error Raised When Try To Delete AP Invoice With More Than 1000 Invoice Distribution Lines

(Doc ID 2034946.1)

Last updated on AUGUST 13, 2015

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.3 [Release 12.0 to 12.2]
Information in this document applies to any platform.


When attempting to deleting invoice having more than 1000 distributions the following error occurs:

app-sqlap-1000 ora-22165 given index [1001] must be in the range of [1] to [1000] in ap_ai_handler_pkg.delete_row<-ap_invoices_pkg.delete_row delete from child entity - ap_invoice_distributions


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