Search Results create_zip

Overview

ZX_TAX_CONTENT_UPLOAD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the bulk loading and transformation of third-party tax content into the E-Business Tax (EBTax) repository. Its central role is to convert externally supplied tax content — geography hierarchies, jurisdictions, tax zones, postal code ranges, alternate city names, and tax rates — into the master and tax geography structures used by EBTax at runtime. The package operates against interface staging data in ZX_DATA_UPLOAD_INTERFACE and drives the creation of geography and jurisdiction records held in the HZ and ZX schemas.

The package is classified as OTHER in the ETRM documentation, meaning it is not a public, supported API in the same sense as the ZX tax calculation APIs; it is best understood as an internal content-loading utility that underpins the seeded concurrent programs used to import tax content, such as the geography and rate loading programs. The $Header comment references zxldgeorates.pls, and the version string indicates the file has been shipped since at least 2006, reflecting its long-standing role in EBTax content provisioning.

Key Procedures and Functions

The package exposes eight documented procedures, invoked as concurrent programs with the standard errbuf/retcode OUT parameters:

• LOAD_FILE — Loads the externally supplied tax content file into the ZX interface tables so that subsequent processing procedures can consume it. This is the entry point the user searched for with "load_file".
• PROCESS_DATA — Pre-processes interface data and orchestrates the other programs, accepting a batch size, number of workers, a tax content source identifier, and a tax regime code.
• POST_PROCESS_DATA — Performs post-processing of interface data and invokes the dependent programs after the main transformations complete.
• CREATE_GEOGRAPHY — Creates the master reference geography records, honouring batch size, worker id, number of workers, tax content source, and last run version.
• CREATE_TAX_ZONES — Creates tax geography for cities and jurisdictions for the specified tax content source, tax regime code, and tax zone type.
• CREATE_ZIP — Creates master geography for postal codes from the supplied tax content source.
• CREATE_ALTERNATE_CITIES — Creates geography identifiers for alternate city names, enabling aliases to resolve to the same master geography.
• CREATE_RATES — Creates tax rates for the given tax content source and tax regime code.

The procedures consistently take a p_tax_content_source (or p_tax_content_source_id) and p_last_run_version, which support incremental loading so that only content newer than the prior run is processed.

Tables Accessed

The package reads and writes a combination of EBTax, Trading Community Architecture, and Foundation tables, accessed through APPS synonyms:

• ZX_DATA_UPLOAD_INTERFACE — the staging table holding the raw uploaded tax content that LOAD_FILE populates and PROCESS_DATA consumes.
• ZX_CONTENT_SOURCES — identifies the content source (and version) driving incremental selects.
• HZ_GEOGRAPHIES / HZ_GEOGRAPHIES_S, HZ_GEOGRAPHY_IDENTIFIERS, HZ_GEOGRAPHY_RANGES, and HZ_HIERARCHY_NODES — hold master geography, identifiers, postal ranges, and hierarchy relationships produced by CREATE_GEOGRAPHY, CREATE_ZIP, and CREATE_ALTERNATE_CITIES.
• HZ_PARTIES, HZ_RELATIONSHIPS / HZ_RELATIONSHIPS_S — support party and relationship records associated with geography and jurisdiction content.
• ZX_JURISDICTIONS_B / ZX_JURISDICTIONS_B_S1 and ZX_ACCOUNTS / ZX_ACCOUNTS_S — hold jurisdiction and account (rate) definitions created by CREATE_TAX_ZONES and CREATE_RATES.
• FND_LANGUAGES — supplies language context, typically for the translated (_S / _TL) geography and jurisdiction columns.

Usage Notes

ZX_TAX_CONTENT_UPLOAD is invoked indirectly rather than from end-user forms. Its procedures are wrapped by concurrent programs in the EBTax responsibility, where LOAD_FILE first stages the content and PROCESS_DATA launches the geography, zone, zip, alternate city, and rate creation steps, with POST_PROCESS_DATA completing the run. Because each procedure observes the errbuf/retcode concurrent-program contract, these programs can be scheduled and monitored through the standard Concurrent Programs and Requests forms.

The package is referenced by no other documented packages, so it should be treated as a top-level utility rather than a dependency. When extending or troubleshooting tax content loads, the recommended path is to invoke the shipped concurrent programs rather than calling these procedures directly, since they assume correctly staged files in ZX_DATA_UPLOAD_INTERFACE and consistent content source and version values. The batch size, worker id, and worker count parameters indicate the package supports parallel workers for high-volume loads such as full geography imports, and p_last_run_version should always be passed from the prior successful run to preserve incremental processing semantics. Behavior is consistent across EBS 12.1.1 and 12.2.2.