Search Results zx_evnt_cls_mappings

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.