Deleting Geography Data. Delete Has Been Running For Days. (Doc ID 2190217.1)

Last updated on OCTOBER 14, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Sales - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Customer wanted to delete Nokia Data for Canada and switch to Vertex.
Customer took the following steps:

1. Log into OSC.
2. Go to "Navigator" > "Setup and Maintenance"
3. Search for the task "Manage Geographies"
4. Search for the country in question (Canada)
5. Go to "Hierarchy Defined" for you country.
6. Select the first row on the "Geography Hierarchy"
7. Choose "Action" > "Delete"
8. You should be given a prompt similar to:
9. "Warning: the geography Canada and its children will be deleted. Related territory, tax, and shipping zone references will become invalid. Do you want to continue?"
10. Choose OK - You will start a batch process. This process will take some time.
11. Click "Save and Close"
12. Go to "Navigator" > "Scheduled Processes"
13. Monitor the "Delete Master Geographies" process until it has completed.
14. Return to "Manage Geographies" and search for the previous country.
15. Go to "Structure Defined" for you country.
16. Delete the first level under "Geography Structure"
17. When prompted, choose "Yes"
18. Click "Save and Close"

However, after step 13, the "Delete Master Geographies" process has not completed.
Customer needs this process to complete, so that the data will be deleted and then the customer can import Vertex data.

EXPECTED BEHAVIOR
Deleting the Nokia data for Canada should only take an hour.

STEPS
The issue can be reproduced at will with the following steps:
1. Log into OSC.
2. Go to "Navigator" > "Setup and Maintenance"
3. Search for the task "Manage Geographies"
4. Search for the country in question (Canada)
5. Go to "Hierarchy Defined" for you country.
6. Select the first row on the "Geography Hierarchy"
7. Choose "Action" > "Delete"
8. You should be given a prompt similar to:
9. "Warning: the geography Canada and its children will be deleted. Related territory, tax, and shipping zone references will become invalid. Do you want to continue?"
10. Choose OK - You will start a batch process. This process will take some time.
11. Click "Save and Close"
12. Go to "Navigator" > "Scheduled Processes"
13. Monitor the "Delete Master Geographies".
14. The "Delete Master Geographies" process does not completed.


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