Load DW Fails Invalid Identifier - Reserved word

Article Id: 107525
Status: Published
Updated On: 20-07-2018 13:20
Products:
CLARITY PPM FOR ITG CA Project & Portfolio Management CLARITY PPM FEDERAL CA Project & Portfolio Management SAAS STARTER PACK-CLARITY PPM
Issue/Introduction:

Load DWH job failing with error:

Invalid Identifier at:

ALTER TABLE DWH_LKP_INDEX ADD INDEX VARCHAR2(255)


Note the lookup ID is INDEX.  

Cause:

The lookup was using the reserved word INDEX.
 

Environment:

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

Create a calculated attribute as a string to pull in the existing data from the original attribute and use that attribute in the data warehouse.

Additional Information:

Please reference https://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm

for a complete list of Oracle Reserved Words