Subledger Account Issue: Subledger Accounting Balances Update (XLABABUP) Has Performance Issue (Doc ID 1577808.1)

Last updated on JUNE 20, 2016

Applies to:

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

Symptoms

Attempting to run the Subledger Accounting Balances Update and find it is taking a long time to complete.  This issue is inconsistent.

Below sql causing the issue.

Total elapsed time = 50,203,995

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