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.

Symptoms


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

ERROR
-----------------------
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

Cause

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