R12 Analyzing Temporary XLA Table Receive Error - Valid Table but No Indexes Found ORA-20222 (Doc ID 2735896.1)

Last updated on DECEMBER 22, 2020

Applies to:

Symptoms

Perform Quick Analyze on XLA temporary Tables shows Error.

Below tables do not have any seeded index in system and give the following error:

XLA_AADS_GT -- VALID TABLE BUT NO INDEXES FOUND
XLA_AAD_SOURCES -- VALID TABLE BUT NO INDEXES FOUND
XLA_ACCT_PROG_DOCS_GT -- VALID TABLE BUT NO INDEXES FOUND
XLA_ACCT_PROG_EVENTS_GT --VALID TABLE BUT NO INDEXES FOUND
XLA_BAL_CONCURRENCY_CONTROL -- VALID TABLE BUT NO INDEXES FOUND
XLA_CONDITIONS_T -- VALID TABLE BUT NO INDEXES FOUND
XLA_FSAH_CCID_RANGES -- VALID TABLE BUT NO INDEXES FOUND
XLA_GL_TRANSFER_PROGRAMS -- VALID TABLE BUT NO INDEXES FOUND
XLA_GL_TRANSFER_PROGRAM_LINES -- VALID TABLE BUT NO INDEXES FOUND
XLA_HISTORIC_CONTROL -- VALID TABLE BUT NO INDEXES FOUND
XLA_HISTORIC_MAPPING_GT -- VALID TABLE BUT NO INDEXES FOUND
XLA_LINE_ASSGNS_T -- VALID TABLE BUT NO INDEXES FOUND
XLA_MERGE_SEG_MAPS -- VALID TABLE BUT NO INDEXES FOUND
XLA_PARTIAL_MERGE_TXNS -- VALID TABLE BUT NO INDEXES FOUND
XLA_REPORT_BALANCES_GT -- VALID TABLE BUT NO INDEXES FOUND
XLA_RULES_T -- VALID TABLE BUT NO INDEXES FOUND
XLA_RULE_DETAILS_T -- VALID TABLE BUT NO INDEXES FOUND
XLA_TPM_WORKING_HDRS_T -- VALID TABLE BUT NO INDEXES FOUND

ERROR at line 1:
ORA-20222: Check was not executed. No INDEXES with index_type=NORMAL found for
table XLA_ACCT_PROG_DOCS_GT or table does not exist
ORA-06512: at "SYS.ANALYZE_QUICK", line 44
ORA-06512: at line 1 :

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.