My Oracle Support Banner

OBIA 11G: SILOS_SIL_HRPERSONLEGISLATION_FLEX_DIMENSION Failing With ORA-00904: "S"."PERLEG_ATTR3_CHAR": invalid identifier (Doc ID 2349655.1)

Last updated on MARCH 27, 2018

Applies to:

Business Intelligence Applications Observer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

BI Apps version/Patches: 11.1.1.10.2
BI Apps modules: HR Analytics
Source System/version: Oracle Fusion 11 HCM

The job- SILOS_SIL_HRPERSONLEGISLATION_FLEX_DIMENSION is failing with below error.


The column PERLEG_ATTR3_CHAR is present both in source and target table. Also for this column the mapping is also present in ODI interface. Still this error is coming up. Full Load worked, not the Incremental.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.