Search Results zx_event_classes_b




Overview
Explore in AI Chat

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.

  • 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_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_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_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_EVENT_CLASSES_TL 12.1.1

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

  • Table: ZX_EVNT_CLS_TYPS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_CLS_TYPS,  object_name:ZX_EVNT_CLS_TYPS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_CLS_TYPS , 

  • Table: ZX_EVNT_CLS_TYPS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_CLS_TYPS,  object_name:ZX_EVNT_CLS_TYPS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_CLS_TYPS , 

  • Table: ZX_EVENT_CLASSES_TL 12.2.2

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

  • 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_REC_NREC_DIST 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_REC_NREC_DIST 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_LINES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_LINES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_LINES_DET_FACTORS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS , 

  • Table: ZX_LINES_DET_FACTORS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS ,