Search Results zx_evnt_cls_mappings




Overview
Explore in AI Chat

Overview

The ZX_EVNT_CLS_MAPPINGS 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 functions as a critical mapping and configuration table, establishing the relationship between E-Business Tax's internal tax event classes and the corresponding business event classes defined across other Oracle Applications. This mapping is fundamental to the tax engine's ability to correctly identify and process tax-relevant transactions originating from various source modules, such as Order Management, Payables, and Receivables. By defining these associations, the table ensures that the appropriate tax determination logic is triggered for a given business event.

Key Information Stored

The table's primary purpose is to link a tax event class to an application event class. Key columns include the unique identifier EVENT_CLASS_MAPPING_ID, which serves as the primary key. The TAX_EVENT_CLASS_CODE references a tax event class defined in ZX_EVENT_CLASSES_B, while the REFERENCE_APPLICATION_ID points to the source application (via FND_APPLICATION). The table also stores the INTRCMP_TX_EVNT_CLS_CODE for related intercompany tax events and the DET_FACTOR_TEMPL_CODE, which links to a default determination factor template (ZX_DET_FACTOR_TEMPL_B) for this mapping. This template provides the initial set of tax conditions and factors to evaluate for the mapped event.

Common Use Cases and Queries

This table is primarily referenced for configuration analysis, troubleshooting tax determination issues, and generating integration reports. A common query involves listing all configured mappings to understand tax coverage for application events. For example, to see all mappings for a specific source application like Order Management (APPLICATION_ID=660), one might use:

  • SELECT zecm.tax_event_class_code, zecm.reference_application_id, fa.application_short_name FROM zx_evnt_cls_mappings zecm, fnd_application fa WHERE zecm.reference_application_id = fa.application_id AND fa.application_id = 660;

Another critical use case is tracing the flow of tax determination. When a transaction line fails to calculate tax, consultants often verify that a valid event class mapping exists for the transaction's source, ensuring the tax engine is invoked correctly.

Related Objects

As a central configuration entity, ZX_EVNT_CLS_MAPPINGS has extensive relationships with other E-Business Tax objects. It is a parent table referenced by several key transactional and setup tables via foreign keys. Documented relationships include:

  • ZX_EVENT_CLASSES_B: References TAX_EVENT_CLASS_CODE and INTRCMP_TX_EVNT_CLS_CODE to define the tax event classes involved.
  • ZX_DET_FACTOR_TEMPL_B: References DET_FACTOR_TEMPL_CODE for the default determination template.
  • FND_APPLICATION: References REFERENCE_APPLICATION_ID to identify the source application.
  • ZX_EVNT_TYP_MAPPINGS: Child table that uses EVENT_CLASS_MAPPING_ID to map specific event types within the mapped class.
  • ZX_RULES_B: References EVENT_CLASS_MAPPING_ID, linking tax rules to a specific event class mapping.
  • ZX_LINES_DET_FACTORS: References EVENT_CLASS_MAPPING_ID, storing determination factors for transaction lines.
  • ZX_PRODUCT_OPTIONS_ALL: References EVENT_CLASS_MAPPING_ID for product-related tax options.
  • 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_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_TYP_MAPPINGS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS,  object_name:ZX_EVNT_TYP_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_TYP_MAPPINGS , 

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

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_EVNT_TYP_MAPPINGS,  object_name:ZX_EVNT_TYP_MAPPINGS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MAPPINGS. This table contains seeded data only. ,  implementation_dba_data: ZX.ZX_EVNT_TYP_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_PRODUCT_OPTIONS_ALL 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PRODUCT_OPTIONS_ALL,  object_name:ZX_PRODUCT_OPTIONS_ALL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table store the tax system options for multiple applications. Each record stores tax options of an operating unit for a specific application. ,  implementation_dba_data: ZX.ZX_PRODUCT_OPTIONS_ALL , 

  • 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_PRODUCT_OPTIONS_ALL 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PRODUCT_OPTIONS_ALL,  object_name:ZX_PRODUCT_OPTIONS_ALL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table store the tax system options for multiple applications. Each record stores tax options of an operating unit for a specific application. ,  implementation_dba_data: ZX.ZX_PRODUCT_OPTIONS_ALL , 

  • 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 , 

  • View: ZX_P2P_CALC_TXN_INPUT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:ZX.ZX_P2P_CALC_TXN_INPUT_V,  object_name:ZX_P2P_CALC_TXN_INPUT_V,  status:VALID,  product: ZX - E-Business Tax ,  implementation_dba_data: APPS.ZX_P2P_CALC_TXN_INPUT_V , 

  • 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 , 

  • View: ZX_P2P_CALC_TXN_INPUT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:ZX.ZX_P2P_CALC_TXN_INPUT_V,  object_name:ZX_P2P_CALC_TXN_INPUT_V,  status:VALID,  product: ZX - E-Business Tax ,  implementation_dba_data: APPS.ZX_P2P_CALC_TXN_INPUT_V ,