Load DW Fails Invalid Identifier - Reserved word

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

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