ALERT:
Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Load DW Fails Invalid Identifier - Reserved word
book
Article ID: 107525
calendar_today
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Show More
Show Less
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
Feedback
thumb_up
Yes
thumb_down
No