The BI Triggers inserted FACT change record before Dimension in CI_CHG_LOG table
(Doc ID 1548319.1)
Last updated on SEPTEMBER 29, 2022
Applies to:
Oracle Utilities Business Intelligence - Version 2.4.0.0.0 and laterOracle Utilities Customer Care and Billing - Version 2.2.0.0.0 to 2.4.0.0.0 [Release 2.2 to 2.4]
Information in this document applies to any platform.
Goal
When loading fact extract into BI, the Oracle Warehouse Builder (OWB) mappings are trying to find Dimension key where UPDATE_DTTM (on fact record) is between eff_start_dttm and eff_end_dttm in dimension table. There is possibility of generating FACT change record first in CI_CHG_LOG table then Dimension change with 1 or 2 seconds log time.
In this case fact extract load is error out by saying dimension key is not found because it is considering time stamp while looking for dimension key.
Fix changed the BI Triggers using the FOLLOWS keyword to have the database order the firing of the triggers correctly when they are for the same table.
Solution
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
| Goal |
| Solution |
| References |