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 laterInformation 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 |