Search Results zx_rules_b

Overview

The ZX_RULES_B table is a core repository within the Oracle E-Business Tax (ZX) module for Oracle EBS 12.1.1 and 12.2.2. It serves as the master definition table for tax rules, which are the fundamental logic components that govern the outcome of various tax determination processes. These processes include calculating tax rates, determining tax statuses, and applying tax exemptions. Each row in this table defines a single, executable rule linked to a specific tax regime, tax, configuration owner, and tax determination event class. The integrity and configuration of data in ZX_RULES_B are critical for the accurate and compliant calculation of taxes on transactions throughout the E-Business Suite.

Key Information Stored

The table's primary key is TAX_RULE_ID, a unique system-generated identifier for each rule. Essential foreign key columns establish the rule's context and applicability. The TAX_REGIME_CODE and TAX_EVENT_CLASS_CODE link the rule to a specific tax regime (e.g., VAT, Sales Tax) and a tax event class (e.g., Standard Invoice, Credit Memo), respectively. The APPLICATION_ID ties the rule to a specific EBS application, such as Payables or Receivables. The DET_FACTOR_TEMPL_CODE references a determinant factor template (ZX_DET_FACTOR_TEMPL_B), which defines the conditions the rule evaluates. The CONTENT_OWNER_ID links to the ZX_PARTY_TAX_PROFILE table, identifying the legal entity or party that owns the rule configuration. Other columns typically store rule execution priority, effective dates, and the rule type.

Common Use Cases and Queries

Primary use cases involve troubleshooting tax determination issues, auditing rule configurations, and developing custom reports. A common query retrieves all active rules for a specific tax regime and event to understand the determination logic flow. For example:

• Identifying rules applied to a transaction for debugging: Analysts join ZX_RULES_B to ZX_PROCESS_RESULTS via TAX_RULE_ID, filtering by transaction ID.
• Auditing rule setup by configuration owner: Querying rules with a specific CONTENT_OWNER_ID and effective date range.
• Reporting on rule priorities within a determination process: Selecting rules for a given TAX_REGIME_CODE and TAX_EVENT_CLASS_CODE, ordered by priority to see evaluation sequence.

Direct data manipulation (DML) on this table is strongly discouraged; rule creation and maintenance should be performed exclusively through the E-Business Tax Manager user interface or supported APIs to maintain data integrity.

Related Objects

ZX_RULES_B is central to the E-Business Tax data model. It has direct foreign key relationships with several key setup tables: ZX_REGIMES_B (tax regimes), ZX_EVENT_CLASSES_B (event classes), ZX_DET_FACTOR_TEMPL_B (determinant templates), and ZX_PARTY_TAX_PROFILE (content owners). It is also referenced by critical runtime and supporting objects. The ZX_PROCESS_RESULTS table stores the outcome of applying these rules to individual transactions. The ZX_RULES_TL table provides translated rule names and descriptions for multiple languages. Furthermore, the ZX_RULES_B table is a primary source for the tax rules engine, which is invoked by the ZX_TAX_SERVICE_PUB API during transaction tax calculation.