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 AUGUST 21, 2024

Applies to:

Symptoms

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_accounting_batch_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.

Changes

Cause

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