My Oracle Support Banner

OBIA 11.1.1.10.1 SDE_ORA_TimecardProcessedTimeFact_HXT mapping is populating NULL for ENTRY_INTEGRATION_ID column (Doc ID 2629853.1)

Last updated on MARCH 25, 2020

Applies to:

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

Symptoms

On : 11.1.1.10.1 version, DataWarehouse

SDE_ORA_TimecardProcessedTimeFact_HXT mapping is populating NULL value for ENTRY_INTEGRATION_ID column.  The OTL processed fact is not populating the right values in the fact table. When we validate the Effective Date, the effective date has always shows 01-JAN-3714, because of that the values are duplicating in the report.

We did some more research and found that the History records step is not updating the values in the fact table. The column ENTRY_INTEGRATION_ID is not mapped in the SDE mapping hence the update is failing.

 

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
Cause
Solution
References


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