Problems In B1_RESET_ENTITY Scenario: The Error Table is not Purged for Custom Fact

(Doc ID 2266163.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.1 and later
Information in this document applies to any platform.

Goal

On : 2.6.0.0.1 version, Customer Analytics

Steps to Reproduce

1)Created a custom fact CM_F_xxx

2)Ensured that data is loaded and job passed for all the slices

3)Done reset entity for the fact.

4)A record has been updated(natural key) in Dimension to introduce -99 values in fact during next load and also to populate the associated Err table.

5)Fact job is enabled. Data has been loaded to fact for all the slices with some -99 key values. Err table has been populated.

6)Reset entity is performed for the fact.

7)The Error table is not purged


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms