My Oracle Support Banner

R12: AP/XLA: The Concurrent Program Update Subledger Accounting Balances (Short Name XLABAPUB) Ends With "ORA-22165: given index [50001] must be in the range of" (Doc ID 3013333.1)

Last updated on MARCH 29, 2024

Applies to:

Oracle Payables - Version 12.1.1 and later
Oracle Subledger Accounting - Version 12.1.1 and later
Information in this document applies to any platform.


Incorrect balances shown on Third Party Balances Report.

When attempting to run concurrent program Update Subledger Accounting Balances (short name XLABAPUB) the following error occurs in the log:


[DD-MON-YYYY HH:MM:SS]: **Starts**
[DD-MON-YYYY HH:MM:SS]: **SQL error and free**
[DD-MON-YYYY HH:MM:SS]: An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_balances_calc_pkg.lock_bal_concurrency_control.  ORA-22165: given index [50001] must be in the range of
Start of log messages from FND_FILE
p_application_id: &application_id
p_ledger_id: &ledger_id
p_request_id: &request_id
End of log messages from FND_FILE

The issue can be reproduced at will with the following steps:

  1. Go to Payables Manager responsibility
  2. Navigation: Menu > View > Requests > Submit a New Request
  3. Select from List of Values > Update Subledger Accounting Balances
  4. Parameters:
    >Ledger: select the ledger name from the List of Values
    >Accounting Batch ID: <leave blank>
  5. OK
  6. Submit
  7. The requests finishes with error status
  8. Review the log.




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.