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.

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

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
References


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