OBIA 11g: HCM Staging Table EDSBI_DW.W_HR_ASG_CNTRCT_ADDL_DS Is Empty, Causing Data Load To Fail
(Doc ID 2393613.1)
Last updated on FEBRUARY 23, 2021
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
On : 18.104.22.168.2 version, DataWarehouse
HCM staging table <OBIA DW SCHEMA>.W_HR_ASG_CNTRCT_ADDL_DS is empty, causing data load to fail.
User encountered an error in HCM data load related to loading the SIL_HRASSIGNMENTCONTRACTS_FLEX_DIMENSION table.
User also noticed that the staging table <OBIA DW SCHEMA>.W_HR_ASG_CNTRCT_ADDL_DS is empty, which causes the insert statement for SIL_HRASSIGNMENTCONTRACTS_FLEX_DIMENSION to fail because it has nothing to evaluate.
The step that creates W_HR_ASG_CNTRCT_ADDL_DS shows as successful, but there is no data.
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