Validate Application Accounting Definitions Has Performance Issues with Select on XLA_EVT_CLASS_SOURCES_GT table (Doc ID 1500485.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Cost Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Performance

The concurrent request  'Validate Application Accounting Definitions' has performance issues

The performance is related to a select statement on global temp table XLA_EVT_CLASS_SOURCES_GT:

SQL_TEXT
SELECT G.SOURCE_APPLICATION_ID
D G.EVENT_CLASS_CODE = :B1 AND G.EXTRACT_OBJECT_NAME IS NULL
PE
TATYPE_CODE COLUMN_DATATYPE_CODE
REF_OBJ_NAME FROM XLA_EVT_CLASS_SOURCES_GT G
CTS R
G.APPLICATION_ID = R.APPLICATION_ID AND G.ENTITY_CODE = R.ENTITY
_CODE AND G.EVENT_CLASS_CODE = R.EVENT_CLASS_CODE AND G.SOURCE_A
PPLICATION_ID = R.REFERENCE_OBJECT_APPL_ID AND G.SOURCE_LEVEL_CO
DE = O.OBJECT_TYPE_CODE AND R.APPLICATION_ID = O.APPLICATION_ID
AND R.ENTITY_CODE = O.ENTITY_CODE AND R.EVENT_CLASS_CODE = O.EVE
NT_CLASS_CODE AND R.OBJECT_NAME = O.OBJECT_NAME AND OG.REFERENCE
_OBJECT_NAME = R.REFERENCE_OBJECT_NAME AND EXISTS ( SELECT 1 FRO
M DBA_TAB_COLUMNS T WHERE OG.OWNER = T.OWNER AND R.REFERENCE_OBJ
ECT_NAME = T.TABLE_NAME AND T.COLUMN_NAME = G.SOURCE_CODE AND DE
CODE(T.DATA_TYPE
YPE_CODE ) AND G.APPLICATION_ID = :B3 AND G.ENTITY_CODE = :B2 AN
T_NAME EXTRACT_OBJECT_NAME

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