Delete Master Geography Data for the Selected Country

You can use this scheduled process to delete the master geography data for a particular country.

On deleting master geographies, all the related references like territory, tax zone, shipping zone, jurisdiction and so on become invalid. You must contact Oracle Support and raise a Support Request (SR). The Support team assists you to run a script on your application to identify dependencies. If there are no dependencies, it's safe to delete geography data for that specific country.

When to Use

This scheduled process deletes the geography data for a country.

Privileges Required

Verify that you have any of the following roles or privileges:

• Roles:

  • Application Implementation Consultant

  • Sales Admin role containing ORA_GEO_ADMIN_DUTY privilege.

• Privileges:

  • Run Trading Community Resource Reporting Hierarchy Generation

  • HZ_RUN_TRADING_COMMUNITY_RESOURCE_REPORTING_HIERARCHY_GENERATION_PRIV

  • HZ_RUN_TRADING_COMMUNITY_GEOGRAPHY_NAME_REFERENCING_MAINTENANCE_PRIV
  • HZ_RUN_TRADING_COMMUNITY_IMPORT_BATCH_PROCESS_PRIV
  • ORA_HZRESOURCE_ORGANIZATION_ADMINISTRATOR_DUTY
  • ORA_ZX_TAX_ADMINISTRATION_DUTY_CRM
  • ORA_HRC_HUMAN_CAPITAL_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB
  • ORA_ZCH_MASTER_DATA_MANAGEMENT_APPLICATION_ADMINISTRATOR_JOB
  • ORA_MANAGE_TRADING_COMMUNITY_IMPORT_BATCH_DUTY
  • ORA_MANAGE_TRADING_COMMUNITY_IMPORT_PROCESS_DUTY

Before You Start

Review the following before scheduling this scheduled process:

• Recommended Frequency:

  • You must create a support request with the details of the need to delete the master geography data for a country.

    Note: When you delete the master geography data, the geography and its children are deleted. In turn, all the related territory, tax, and shipping zone references become invalid. For example, ERP relies on geography data to calculate tax, and if you accidentally delete the geography data, the tax calculations become invalid. Such deletions may also result in the re-provisioning of Point of Delivery (PODs) in some cases. So, you must back up this master geography data before deleting the master geography data.
• Compatibility:
  • This scheduled process is self-incompatible and also incompatible with the Group Territory Geographies.

Parameters

Parameter	Optional or Mandatory	Description	Parameter Values	Special Combinations Required	Notes
Country Code	Mandatory	Specifies the Country for which data must be deleted.	Example: IN India	None