Search Results zx_event_classes_b_pk

Overview

The ZX_EVENT_CLASSES_B table is a core repository within the Oracle E-Business Tax (ZX) module for Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the master definition table for tax event classes, which are fundamental categories of business transactions that have tax implications, such as Sales, Purchases, or Inventory Transfers. The table's role is to provide a standardized, system-defined classification system that drives the entire tax determination process. As documented, this table contains seeded data only, meaning its records are delivered by Oracle during installation or upgrade and should not be modified by custom data inserts, updates, or deletions. This ensures the integrity of the tax engine's foundational classifications.

Key Information Stored

The primary information stored is the unique identifier for each tax event class. While the full column list is not detailed in the provided metadata, the documented primary key and foreign key relationships definitively identify the core column. The TAX_EVENT_CLASS_CODE column is the primary key (ZX_EVENT_CLASSES_B_PK) and holds the unique alphanumeric code that identifies each event class, such as 'PURCHASE_INVOICE' or 'SALES_INVOICE'. This code is the critical piece of data referenced throughout the E-Business Tax schema. Other columns in the table likely support descriptive and control attributes, such as an enabled flag or creation metadata, but the TAX_EVENT_CLASS_CODE is the essential, relationship-driving field.

Common Use Cases and Queries

The primary use case is to understand or report on the taxonomy of business events that are subject to tax processing. Common activities include identifying which event classes are active or mapping internal transaction types to the standard E-Business Tax classifications. A typical query would join this table with its corresponding translation table, ZX_EVENT_CLASSES_TL, to retrieve user-friendly names in a specific language. For troubleshooting or analyzing tax rule setup, one would join this table to the tax rules table (ZX_RULES_B) to see all rules defined for a specific event class. A fundamental sample SQL pattern is:

• SELECT b.tax_event_class_code, tl.name, tl.description FROM zx_event_classes_b b, zx_event_classes_tl tl WHERE b.tax_event_class_code = tl.tax_event_class_code AND tl.language = USERENV('LANG');

Given the table is seeded, data manipulation language (DML) operations are not standard practice and are strongly discouraged.

Related Objects

As a master table, ZX_EVENT_CLASSES_B is referenced by numerous critical transactional and setup tables within the E-Business Tax schema, as confirmed by the provided foreign key metadata. The TAX_EVENT_CLASS_CODE column is joined to the following key objects:

• ZX_EVENT_CLASSES_TL: Provides translated names and descriptions for the event classes.
• ZX_EVNT_CLS_MAPPINGS: Used for mapping transaction types to tax event classes and for internal company event class mappings (referenced by two separate foreign keys).
• ZX_EVNT_CLS_TYPS: Associates event classes with specific tax event types.
• ZX_LINES and ZX_LINES_DET_FACTORS: The tax lines and their detail factors are classified by the event class.
• ZX_REC_NREC_DIST: Tracks recoverable and non-recoverable tax distributions by event class.
• ZX_RULES_B: The central tax rules table; every tax rule is defined for a specific tax event class.

This extensive relationship network underscores the table's central role as a controlling entity for tax configuration and processing logic.