Error when running Enable Dimensions to update new geographies in Territory Proposal
Last updated on AUGUST 21, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 1.0]
Oracle Fusion Sales - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 1.0]
Information in this document applies to any platform.
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."
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms