My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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

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