XLABABUP Subledger Accounting Balances Update Program Performance Issue (Doc ID 1595203.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
XLABABUP Subledger Accounting Balances Update Program

Symptoms

Program:  XLABABUP - Subledger Accounting Balances Update program has performance issue,

Note this is spawned from run of Create Accounting - Assets.


Review of the TKPROF eplain plan shows

1.  It is stuck on this query for 24 hours+

 


2.  The above query shows a full table scan on XLA_AE_LINES


Changes

 RDBMS <Patch 14013094> was applied.

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