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

Applies to:

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

Symptoms

On : 11.1.1.10.2 version, DataWarehouse

ACTUAL BEHAVIOR
---------------
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. 

 

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!


In this Document
Symptoms
Changes
Cause
Solution


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