Results for “offset_tax_basis_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX.ZX_EVNT_CLS_OPTIONS is a configuration table within the E-Business Tax (ZX) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the tax options that a first party organization has defined for a specific application event class. Each row represents the controlling behavior for how tax is calculated, defaulted, and validated when a given event class (for example, a payable invoice or an order line) is processed by the tax engine.

Because configuration rows carry the effective-dated business rules that drive downstream tax determination, the table behaves less like a lookup and more like a versioned policy store. The heuristic Data Vault classification mined from the foreign key structure is satellite-leaning, meaning the table is best modeled as a descriptive satellite attached to a hub or link formed by the application, entity, and event class keys, with the effective dating and flags describing the rule state.

Key Information Stored

The physical schema in 12.2.2 documents 38 columns. The most significant include:

• EVENT_CLASS_OPTIONS_ID — surrogate identifier, supported by unique index ZX_EVNT_CLS_OPTIONS_U1.
• APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE — the business context identifying which application entity and event class the options apply to; these form part of the primary key ZX_EVNT_CLS_OPTIONS_PK.
• FIRST_PTY_ORG_ID — the first party organization owning the option.
• EFFECTIVE_FROM and EFFECTIVE_TO — the effective dating range; EFFECTIVE_FROM participates in the primary key while EFFECTIVE_TO bounds expiration.
• ENABLED_FLAG — indicates whether the option row is active; also part of the composite primary key.
• DET_FACTOR_TEMPL_CODE — foreign key to ZX_DET_FACTOR_TEMPL_B, linking the option to a determining factor template.
• DEFAULT_ROUNDING_LEVEL_CODE and ROUNDING_LEVEL_HIER_1_CODE through ROUNDING_LEVEL_HIER_4_CODE — rounding hierarchy defaults.
• ALLOW_OVERRIDE_FLAG, ALLOW_MANUAL_LINES_FLAG, ALLOW_MANUAL_LIN_RECALC_FLAG — control flags governing user interaction with calculated tax lines.
• TAX_TOLERANCE and TAX_TOL_AMT_RANGE — tolerance thresholds applied during tax validation.
• OFFSET_TAX_BASIS_CODE and ALLOW_OFFSET_TAX_CALC_FLAG — offset tax behavior configuration.
• ALLOW_EXEMPTIONS_FLAG with EXMPTN_PTY_BASIS_HIER_1_CODE and EXMPTN_PTY_BASIS_HIER_2_CODE — exemption handling and hierarchy basis.

Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) support concurrency and traceability.

Common Use Cases and Queries

Consultants and support analysts query this table to confirm how tax options are configured for a specific event class, to troubleshoot rounding or override behavior, and to audit effective-dated configuration changes.

• Retrieve active options for an event class:

  SELECT event_class_code, first_pty_org_id, det_factor_templ_code,
         default_rounding_level_code, allow_override_flag, effective_from
  FROM   zx.zx_evnt_cls_options
  WHERE  application_id = :app_id
  AND    entity_code = :entity_code
  AND    event_class_code = :event_class_code
  AND    enabled_flag = 'Y'
  AND    SYSDATE BETWEEN effective_from AND NVL(effective_to, SYSDATE);

• Identify event classes linked to a determining factor template for impact analysis.
• Report tolerance and rounding configuration across organizations for compliance review.
• Historical comparison of options by joining on EFFECTIVE_FROM and EFFECTIVE_TO ranges.

Related Objects

• ZX_DET_FACTOR_TEMPL_B — referenced via DET_FACTOR_TEMPL_CODE; the primary foreign key relationship providing determining factor templates.
• ZX_EVENT_CLASSES — defines the event classes referenced by EVENT_CLASS_CODE.
• ZX_PARTY_TAX_PROFILE — party-level tax configuration that complements first party organization settings.
• ZX_TAX_REGIMES_B and ZX_REGIME_RATES_B — tax regime and rate definitions consumed during calculation.
• ZX_LINES and ZX_LINES_DET_FACTORS — resulting calculated tax lines and their determining factors.
• ZX_API_PUB and related E-Business Tax public APIs — programmatic entry points that read these options during tax determination.