Search Results create_formula

Overview

The APPS.ZX_AR_FORMULA_MIG_PKG package body is a migration utility within the Oracle E-Business Suite Receivables (AR) tax configuration framework. Its central purpose is to migrate legacy Oracle Receivables tax setup — specifically tax group codes and their associated VAT tax relationships and rates — into the newer E-Business Tax (EBTax / ZX) regime model. In release 12.1.1 and 12.2.2, tax determination is governed by the ZX schema, in which tax rules are expressed through conditions, formulas, and rules rather than through the older AR tax group code construct. This package bridges that gap by transforming legacy AR tax group definitions into the corresponding ZX condition groups, formulas, and rules required for tax determination to function correctly after an upgrade.

Key Procedures and Functions

Three documented program units comprise the package's public interface:

• FORMULA_MIGRATION_MAIN — The primary driver procedure. It orchestrates the overall migration, iterating over legacy AR tax group data and coordinating the creation of ZX condition groups, formulas, and rules. It acts as the entry point that the migration process invokes.
• CREATE_FORMULA — Responsible for constructing and inserting the ZX formula records derived from legacy AR tax group definitions, writing to the ZX formula base, translation, and detail tables.
• CREATE_RULES — Builds the corresponding ZX tax rules that bind the migrated formulas and condition groups into the EBTax rule framework so that tax determination can evaluate them.

No parameter lists are documented in the metadata, so signatures are intentionally omitted here. Each unit is structured around standard API invocation patterns, with error handling and logging provided through the FND_API and FND_LOG dependencies.

Tables Accessed

The package reads legacy Receivables tax configuration and writes the equivalent ZX repository records:

• AR_TAX_GROUP_CODES and AR_TAX_GROUP_CODES_ALL — source legacy tax group code definitions, read to determine what must be migrated.
• AR_VAT_TAX_ALL — legacy VAT tax setup supplying rates and tax relationships.
• ZX_CONDITION_GROUPS_B — destination for condition group headers created during migration.
• ZX_FORMULA_B, ZX_FORMULA_B_S, ZX_FORMULA_B_TMP, ZX_FORMULA_DETAILS, ZX_FORMULA_DETAILS_S, ZX_FORMULA_TL — the formula base, sequence, temporary, detail, and translation tables populated by CREATE_FORMULA.
• ZX_RULES_B, ZX_RULES_B_S, ZX_RULES_B_TMP, ZX_RULES_TL — rule repository tables populated by CREATE_RULES.
• ZX_RATES_B, ZX_TAX_RELATIONS_T, ZX_PROCESS_RESULTS, ZX_PROCESS_RESULTS_S — supporting rate, relation, and migration result/audit tables.
• FND_LANGUAGES, FND_LOOKUPS, FND_GLOBAL — language, lookup, and session context services used during processing.

Usage Notes

This package is a migration-time utility and is not designed for routine transactional or runtime use. It is typically invoked during the E-Business Tax migration cycle, when legacy Oracle Receivables tax group codes must be converted into EBTax condition groups, formulas, and rules. The presence of the ZX_FORMULA_B_TMP and ZX_RULES_B_TMP temporary tables indicates a staged load approach, in which data is first populated into temporary structures before being validated and committed to the base and translation tables via the underscore _S sequence-backed tables and the ZX_MIGRATE_UTIL dependency. The package depends on FND_API and FND_LOG for standard API result handling and diagnostic logging, and on ARP_UTIL_TAX and ZX_MIGRATE_UTIL for supporting utility routines. It does not write directly to user-facing forms; execution occurs through the migration framework rather than end-user navigation. Because the metadata records zero references by other database objects, the package is a top-level entry point invoked by the migration process itself. Its status is listed as VALID in the ETRM documentation.