XLABAOPE Open Period Balances Is Running Long Time to Complete
(Doc ID 2874151.1)
Last updated on MARCH 07, 2023
Applies to:Oracle General Ledger - Version 12.1 and later
Information in this document applies to any platform.
On : 12.1.3 version, Setup forms and programs
XLABAOPE: Open Period Balances is taking long time 826 minutes to complete.
XLABAOPE: Open Period Balances should take less time to complete.
The issue can be reproduced at will with the following steps:
1. Login to General Ledger Responsibility
3. Open the period.
4. XLABAOPE: Open Period Balance runs for more than 826 minutes.
The Maintain Balances is set to 'Always' in the Subledger setup as below:
Login to Subledger Responsibility
Setups: Subledger Accounting Setup: Accounting Methods Builder: Journal Entry
Setups: Supporting References
The Maintain Balances checkbox indicates whether user want to maintain balances for this Supporting Reference or not.
• NEVER—if you do not want to track balances
• BASED ON ACCOUNT—to maintain balances for this Supporting Reference
• ALWAYS—indicates that the balances will be carried forward to the next year.
If they have it in ALWAYS, this will accumulate the volume of data in xla_ac_balances.
If they have it in ALWAYS, this will accumulate the volume of data in xla_ac_balances. If this is the case, suggest using one of the other two setups if it is suitable for their requirements. Also suggest having the fewest open periods. Since a large number of open periods increases the volume of data in this table.
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