Search Results evnt_cls_mapping_id

Overview

ZX.ZX_TRX_PRE_PROC_OPTIONS_GT is a global temporary table (GTT) in the Oracle E-Business Tax (EBTax) schema ZX. It acts as a transient staging container that the tax engine uses during the pre-processing phase of tax determination for a transaction. Rows are visible only to the session that inserts them, and the data duration is defined as SYS$TRANSACTION, meaning the rows persist until the inserting transaction commits or rolls back. This design allows concurrent sessions to run tax processing for different transactions without interfering with one another.

The table carries the option and control flags that govern how the tax service provider integration is invoked for a given transaction event, including the caller's intent when the provider is contacted. From a Data Vault modeling perspective, the mined relationship data classifies this object as a standalone structure with no documented foreign key dependencies; it is therefore most naturally modeled as a hub-like anchor keyed on the business key, rather than a link or satellite, though the GTT nature means it is not a durable warehouse entity.

Key Information Stored

The documented primary key is ZX_TRX_PRE_PROC_OPTIONS_GT_PK, composed of APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, and TRX_ID. A unique index, ZX_TRX_PRE_PROC_OPTIONS_GT_U1, enforces the same four columns as the business-key candidate.

• APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID — the composite business key that identifies the transaction being pre-processed.
• PARTNER_PROCESSING_FLAG — the flag the user searched for; it indicates the purpose for which the tax service provider is called, with documented values C (Calculate), F (First Time Calculation), and S (Synchronize).
• PROD_FAMILY_GRP_CODE — lookup indicating the product family of the event class, with documented values P2P and O2C.
• TAX_REGIME_CODE, TAX_EVENT_TYPE_CODE — the tax regime and tax event type driving the determination.
• TAX_PROVIDER_ID — identifier of the third-party service provider that determined tax; null when no provider integration applies.
• EVNT_CLS_MAPPING_ID — event class mapping identifier used to resolve configuration.
• EVENT_ID — unique identifier of the triggering event, stamped on all transaction lines passed to the tax API.
• ALLOW_TAX_CALCULATION_FLAG, RECORD_FLAG, RECORD_FOR_PARTNERS_FLAG, QUOTE_FLAG — control flags that gate calculation, recording, and provider-facing processing behavior.
• INTERNAL_ORGANIZATION_ID, LEGAL_ENTITY_NUMBER, ESTABLISHMENT_NUMBER — organization and legal-entity context for the transaction.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Because the table is a session-scoped GTT, it is not intended for persistent reporting; it is queried during debugging and diagnostics of tax processing. The most common pattern is to inspect the flags that were set for a specific transaction while the transaction is open.

• Confirm which provider-processing mode was requested: SELECT PARTNER_PROCESSING_FLAG, TAX_PROVIDER_ID FROM ZX.ZX_TRX_PRE_PROC_OPTIONS_GT WHERE TRX_ID = :trx_id;
• Diagnose product-family and regime behavior: SELECT PROD_FAMILY_GRP_CODE, TAX_REGIME_CODE, ALLOW_TAX_CALCULATION_FLAG FROM ZX.ZX_TRX_PRE_PROC_OPTIONS_GT WHERE APPLICATION_ID = :app_id AND EVENT_CLASS_CODE = :event_class;
• Trace a specific event across lines using EVENT_ID.

Downstream reporting should target the persistent ZX transaction tables rather than this GTT.

Related Objects

The metadata records no foreign keys, so relationships are functional rather than enforced. The most significant related objects are the EBTax transactional tables and APIs that read or write pre-processing options:

• ZX_LINES / ZX_LINES_SUMMARY — share the APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, and TRX_ID key context.
• ZX_LINES_DET_FACTORS — line detail factors used during the same calculation pass.
• ZX_EVNT_CLS_MAPPINGS — source of EVNT_CLS_MAPPING_ID.
• ZX_REGIMES_B / ZX_REGIMES_TL — source of TAX_REGIME_CODE.
• ZX_EVENTS — source of EVENT_ID and the tax event that triggers the API call.
• ZX_STATUS_PROCESSING / ZX_PROCESSING_RESULTS — records outcomes of the processing for the same transaction.