OBIA 12c: 'ORA-00904: "POS"."ATTRIBUTE1": invalid identifier' While Running SDE_ORAR122_ADAPTOR_SDE_ORA_HRPOSITIONDIMENSION
(Doc ID 2813902.1)
Last updated on OCTOBER 12, 2021
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.3 and later
Information in this document applies to any platform.
OBIA 18.104.22.168.3 (12c) with PB1 "OBIA BUNDLE PATCH 22.214.171.124.200808"
BIACM metadata was imported from OBIA 126.96.36.199.2 export.
After having implemented OBIA 188.8.131.52.3 (OBIA 12c), executed the domain load, performed the functional configurations and mappings and running the first full load.
While running the first full load, session SDE_ORAR122_ADAPTOR_SDE_ORA_HRPOSITIONDIMENSION failed at step "120 - Load data - LKM BIAPPS SQL to Oracle (Extensible)" on the source with the following error:
The executed source code, shows that for the flexfield-related columns it is using "POS" as the table alias whereas for the rest of the columns from the same subquery, the alias name is "POS_SQ_POSITIONS" hence the failure.
Another noticed is with the previous step ("110 - Create work object - LKM BIAPPS SQL to Oracle (Extensible)") which although it is not ending in error, it is not adding the flexfield-related columns which should be inserted via the following substitution: (<$=selectFlexColList$>).
Seems like the LKM is using the contents of W_FLEX_COLUMN_G.COLUMN_CONTEXT_CASE to add for each DFF/attribute column to the source SQL to extract from EBS.
The values of W_FLEX_COLUMN_G FOR FLEXFIELD_TYPE= 'DESCRIPTIVE' and FLEXFIELD_CODE= 'PER_POSITIONS'.
New OBIA 12c installation/configuration.
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