Search Results zx_rules_b




Overview
Explore in AI Chat

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.

  • Table: ZX_RULES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_B,  object_name:ZX_RULES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. ,  implementation_dba_data: ZX.ZX_RULES_B , 

  • Table: ZX_RULES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_B,  object_name:ZX_RULES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. ,  implementation_dba_data: ZX.ZX_RULES_B , 

  • Table: ZX_RULES_TL 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_TL,  object_name:ZX_RULES_TL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table provides multilingual support (MLS) for each tax rule. MLS enables you to store and print data that you define in multiple languages. ,  implementation_dba_data: ZX.ZX_RULES_TL , 

  • Table: ZX_EVNT_CLS_MAPPINGS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_CLS_MAPPINGS,  object_name:ZX_EVNT_CLS_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: ZX_EVNT_CLS_MAPPINGS stores mappings of tax event classes to event classes of Oracle Applications. ,  implementation_dba_data: ZX.ZX_EVNT_CLS_MAPPINGS , 

  • Table: ZX_DET_FACTOR_TEMPL_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B,  object_name:ZX_DET_FACTOR_TEMPL_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores templates for usage of determining factors. Each record represents one determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B , 

  • Table: ZX_EVENT_CLASSES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVENT_CLASSES_B,  object_name:ZX_EVENT_CLASSES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event classes. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVENT_CLASSES_B , 

  • Table: ZX_DET_FACTOR_TEMPL_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B,  object_name:ZX_DET_FACTOR_TEMPL_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores templates for usage of determining factors. Each record represents one determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B , 

  • Table: ZX_EVENT_CLASSES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVENT_CLASSES_B,  object_name:ZX_EVENT_CLASSES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event classes. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVENT_CLASSES_B , 

  • Table: ZX_EVNT_CLS_MAPPINGS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_CLS_MAPPINGS,  object_name:ZX_EVNT_CLS_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: ZX_EVNT_CLS_MAPPINGS stores mappings of tax event classes to event classes of Oracle Applications. ,  implementation_dba_data: ZX.ZX_EVNT_CLS_MAPPINGS , 

  • Table: ZX_RULES_TL 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_TL,  object_name:ZX_RULES_TL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table provides multilingual support (MLS) for each tax rule. MLS enables you to store and print data that you define in multiple languages. ,  implementation_dba_data: ZX.ZX_RULES_TL , 

  • Table: ZX_PROCESS_RESULTS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS , 

  • Table: ZX_PROCESS_RESULTS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS , 

  • Table: ZX_REGIMES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_REGIMES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_PARTY_TAX_PROFILE 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_PARTY_TAX_PROFILE 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE ,