OBIA 11g: HCM Staging Table EDSBI_DW.W_HR_ASG_CNTRCT_ADDL_DS Is Empty, Causing Data Load To Fail
Last updated on MAY 04, 2018
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.2 and later
Information in this document applies to any platform.
On : 126.96.36.199.2 version, DataWarehouse
HCM staging table EDSBI_DW.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 EDSBI_DW.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.
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 hundreds of Community platforms