Search Results create_condition_groups




Overview
Explore in AI Chat

Overview

The APPS.ZX_MIGRATE_TAX_DEFAULT_HIER package is a migration utility within the Oracle E-Business Suite (EBS) ETRM (E-Business Tax) module. It supports the transition of legacy tax defaulting setups into the configuration model introduced with E-Business Tax in Release 12. In R12.1.1 and R12.2.2, tax determination is driven by a rules-based engine that evaluates condition groups, conditions, and rules rather than the older hierarchical defaulting structures found in pre-R12 applications. This package provides the procedural infrastructure to migrate historical default hierarchy definitions, condition groups, and associated rules into the ZX schema tables that the E-Business Tax engine consumes at runtime.

As a migration-focused package, it is intended for controlled, largely one-time or scheduled execution during implementation or upgrade activities rather than for routine transaction processing. The header comment indicates a version lineage tied to the 12010000 (12.1) code line, consistent with its use across both the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes four documented procedures. Parameter lists are intentionally not reproduced here; the descriptions below reflect documented purpose only.

  • MIGRATE_DEFAULT_HIERARCHY — The primary orchestrator. It drives the overall migration of the legacy tax default hierarchy into the R12 E-Business Tax structures, typically invoking the subordinate procedures to build condition groups, rules, and process results in sequence.
  • CREATE_CONDITION_GROUPS — Populates condition group definitions from the legacy hierarchy. This is the procedure most directly associated with the search term "create_condition_groups," and it is responsible for translating migrated defaulting logic into the condition group records the tax engine evaluates.
  • CREATE_RULES — Generates the determination rules that reference the migrated condition groups, establishing the logic by which tax is defaulted during transaction and document processing.
  • CREATE_PROCESS_RESULTS — Produces or reconciles process result records, tying the migrated configuration to the outcomes produced during tax determination.

Tables Accessed

The package reads and writes across both legacy and R12 tax tables, accessed through APPS synonyms. On the legacy side it references AP_TAX_CODES_ALL, AP_TAX_CODES_S, AR_VAT_TAX_ALL, AR_VAT_TAX_ALL_B, AR_VAT_TAX_S, AR_TAX_CONDITIONS_ALL, AR_TAX_GROUP_CODES_ALL, and AR_SYSTEM_PARAMETERS_ALL, which supply the source tax codes, VAT definitions, conditions, and grouping data. On the target side it writes to the E-Business Tax tables ZX_CONDITIONS, ZX_CONDITIONS_S, ZX_CONDITION_GROUPS_B, ZX_CONDITION_GROUPS_B_S, and ZX_CONDITION_GROUPS_TL, which store the migrated condition groups (base and translation layers) and conditions. Supporting references to FND_LANGUAGES and FND_PRODUCT_GROUPS are used for language and environment context during the migration.

Usage Notes

This package is normally invoked as part of upgrade or implementation activities, not from end-user forms. It may be called from concurrent programs, migration scripts, or custom PL/SQL that coordinates the E-Business Tax migration effort, and it is referenced by one other package within the application. Because it manipulates core tax configuration tables, execution should be performed in a controlled maintenance window with appropriate backups, and only when the corresponding migration prerequisites and setups are in place. Oracle does not document these procedures as public APIs, so direct invocation from custom code is generally discouraged; administrators should confirm supported entry points and patch-level behavior for the specific 12.1.1 or 12.2.2 environment before use.