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 MAY 04, 2018

Applies to:

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


On : 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