Set Up and Administer Territory Management Troubleshooting Guide (Doc ID 1392206.1)

Last updated on APRIL 27, 2023

Applies to:

Purpose

Oracle Fusion Territory Management’s Enable Dimensions and Metrics task allows a territory management administrator
to indicate which of the twelve seeded dimensions should be enabled and also which of the metrics will be used by the application.
Additionally, the tasks allow for the ad-hoc start of the synchronization process of the Oracle Fusion Territory Management schema
and Oracle Essbase hypercube with the sources:

either online transaction processing (OLTP) application (in a nondata-warehouse deployment)
or with the Oracle Business Intelligence Data Warehouse (in the case of a data-warehouse deployment).

Oracle Essbase serves as the Oracle Fusion Territory Management metrics data repository.

Dependent Technologies:

Helpful Log Channels:

Territory Management: Stage Environment synchronization process runs as an ESS Job and utilizes SOA BPEL to coordinate synchronization web services.
Log messages captured in ESS and SOA may be useful in determining the cause of warnings or errors in the synchronization process.

1. ESS Job log

a. When reviewing the Stage Environment, on the Enable Dimensions and Metrics task, click on the Process Status link,

which will pop-up a Processing Details window which shows the associated ESS job.

b. Scroll the the far right to see the 'View Log' column and click the icon to download the process log.

c. Review any messages indicated in the log.

2. SOA Enterprise Manager Instance

a. Log in to Enterprise Manager

b. Navigate to SOA > soa-infra > default > SalesTerrMgmtTerritoriesSetupComposite

c. Click on the 'Instance Id' link (typically the first entry, when sorted by default with most recently run instances first)

d. Review for any faults lts reported at the top of the Flow Trace window.

Problem Catalog:

1. Members of the Account dimension are not visible
2. Members of dimensions other than Account are not visible
3. Auxiliary dimensions 1, 2, and 3 not populated after the stage process completes
4. Industry dimension not populated after the stage process completes
5. Geography dimension not populated after the stage process completes
6. Stage process completes with errors due to invalid territories
7. Stage process errors out when invalid territories are detected
8. Promote process completes with errors due to invalid territories
9. Stage process completes with errors due to failed BI connection
10. Stage process completes with errors due to invisible parents of visible members
11. Stage process waits in processing state for extended period because of ESS server issues

Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.