My Oracle Support Banner

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:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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