Search Results create_zone_type




Overview
Explore in AI Chat

Overview

ZX_GEO_JUR_MIGR_PKG is an Oracle E-Business Suite migration utility package owned by the APPS schema and classified as OTHER within the E-Business Tax (ZX) product family. Its name reflects its purpose: ZX (E-Business Tax), GEO_JUR (geography and jurisdiction), and MIGR (migration). The package exists to migrate legacy geography and jurisdiction configuration data into the geography model used by Oracle's E-Business Tax engine, laying the foundation for tax jurisdiction determination on transactions.

In Oracle EBS 12.1.1 and 12.2.2, tax content is built on the HZ geography hierarchy (countries, geography types, and zones). During upgrade or initial tax configuration, the seeded geography and zone structures used by tax jurisdictions must be created programmatically. ZX_GEO_JUR_MIGR_PKG provides that programmatic path, allowing administrators and migration scripts to create geography types, zone types, and zone ranges consistent with the data structures expected by the tax engine.

Key Procedures and Functions

Three documented procedures constitute the public interface of this package:

  • CREATE_GEO_TYPE — Creates geography types, the top-level classifications (such as country-based geography classifications) that group geographies into hierarchical structures used by the tax and geography engines.
  • CREATE_ZONE_TYPE — Creates zone types, which define the classification of zones (for example, tax zones or region-based groupings) applied to geographies. Zone types are a prerequisite for defining individual zones used in tax jurisdiction determination.
  • CREATE_ZONE_RANGE — Creates a zone range and its associated zone relation data. It accepts parameters describing the zone type, zone name, zone code, zone code type, a zone name prefix, effective start and end dates, plus a zone relation table. It returns the newly created zone geography identifier via an OUT parameter. This procedure is the primary vehicle for populating the zone hierarchy with effective-dated membership data.

No functions are documented in the package specification.

Tables Accessed

Package metadata identifies the following tables, referenced through APPS synonyms:

  • HZ_GEOGRAPHIES — The central geography table, holding countries, regions, and other geography and zone records created or updated by the procedures.
  • AR_SYSTEM_PARAMETERS_ALL — The Receivables system parameters, consulted to resolve operating context and configuration settings that govern geography setup.
  • FND_ID_FLEX_STRUCTURES — The descriptive flexfield structure definitions, used to identify the flexfield context associated with geography or tax-related attributes.
  • FND_SEGMENT_ATTRIBUTE_VALUES — Segment attribute values, referenced to determine flexfield segment behavior, such as whether attributes are enabled or displayed.
  • PLITBLM — The PL/SQL index-by table logging structure, used for diagnostic logging of migration activity.

Usage Notes

ZX_GEO_JUR_MIGR_PKG is a low-level utility and is not exposed through standard EBS forms or concurrent programs. It is documented as referenced by zero other packages, indicating it sits at the edge of the dependency graph and is primarily invoked by migration or setup routines and custom extensions. Typical usage includes one-off data migration scripts executed during upgrade to release 12, preparation of geography and zone hierarchies before enabling E-Business Tax jurisdictions, and customized batch loaders for high-volume tax geography setup. Because it is an AUTHID CURRENT_USER package, execution privileges and object resolution follow the caller, so it should be invoked with appropriate APPS-level grants and only by users or scripts authorized to modify geography and tax configuration data. Migrations should be performed in a controlled maintenance window, with table backups and validation of the resulting HZ_GEOGRAPHIES and zone-relation records, as the procedures write directly to shared geography structures used by both Oracle Receivables and E-Business Tax.