Load DW Fails Invalid Identifier - Reserved word
Article ID: 107525
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS - Application
Clarity PPM On Premise
Load DWH job failing with error:
Invalid Identifier at:
ALTER TABLE DWH_LKP_INDEX ADD INDEX VARCHAR2(255)
Note the lookup ID is INDEX.
The lookup was using the reserved word INDEX.
Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
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.
for a complete list of Oracle Reserved Words