Error when running Enable Dimensions to update new geographies in Territory Proposal (Doc ID 2117768.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 to 11.12.1.0.0 [Release 1.0]
Oracle Fusion Sales - Version 11.1.10.0.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

After changing geographies (zones), to update the changes the job "Manage Territory Geographies" has been run.
When running the Enable Dimensions and Metrics job, a warning occurs, which results in the fact that the newly defined Geographies are not visible in the Territory Proposal Screen.
Due to this issue territories cannot be updated, which is blocking management in setting-up the new sales areas.

WARNING from log file:
Dropped row for metrics [DETAIL_REVENUE_CREATED; ] - Invalid element `<NULL_TIME_ATTRIBUTE>` - full row : BUnit_300000000518008
Geo_300000000183965_TM_UNSPECIFIED Prod_100000000288638_TM_UNSPECIFIED Territory1 Timeview1 <NULL

As recommended by Support, the following steps were taken:

1. run the Ess job "Refresh Denormalized Time Dimension Table for BI" from Schedule Processes.

2. Once the Ess job is complete, Please run the load and activate from Enable Dimensions.

A new error was generated afterwards: "Synchronization of the dimension with the code Acct failed. Duplicate members with the same integration ID 100000001259543 were found in the dimension source."

Cause

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