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.
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:
D G.EVENT_CLASS_CODE = :B1 AND G.EXTRACT_OBJECT_NAME IS NULL
REF_OBJ_NAME FROM XLA_EVT_CLASS_SOURCES_GT G
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
YPE_CODE ) AND G.APPLICATION_ID = :B3 AND G.ENTITY_CODE = :B2 AN
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!