Results for “zx_rep_matrix_ext_t”

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

Overview

ZX_REP_MATRIX_EXT_T is a table in the ZX (E-Business Tax) schema that stores tax information used for matrix reporting in Oracle E-Business Suite 12.1.1 and 12.2.2. The table is documented as VALID and, per the ETRM 12.2.2 physical schema, contains 109 columns. Its documented purpose is to hold one row for every row present in ZX_REP_TRX_DETAIL_T, meaning it acts as a wide, denormalized reporting companion to the transactional tax detail table. The "MATRIX" naming and the repeated TAX1 through TAX4 column groups indicate a fixed-width, multi-tax-line reporting structure: each row can carry detail for up to four taxes applied to a single transaction detail line, together with their rates, regimes, recoverability attributes, and amounts.

From a Data Vault modeling perspective, the mined metadata classifies this object as standalone (no downstream foreign keys). As a modeling suggestion, it most closely resembles a satellite attached to the ZX_REP_TRX_DETAIL_T hub: it is keyed by a surrogate identifier and carries descriptive, time-relevant attributes for a single parent row, with no independent business keys of its own beyond the foreign-key link.

Key Information Stored

The primary key is ZX_REP_MATRIX_EXT_T_PK on DETAIL_TAX_LINE_MAT_ID, which is a system-generated surrogate identifier and also serves as the unique business-key candidate via ZX_REP_MATRIX_EXT_T_U1. The most significant columns fall into two groups:

• DETAIL_TAX_LINE_ID – foreign key to ZX_REP_TRX_DETAIL_T; the link to the parent transaction detail row.
• TAX<n>_STATUS_CODE, TAX<n>_REGIME_CODE, TAX<n> – status, regime, and tax name for each of up to four taxes.
• TAX<n>_RATE_CODE / TAX<n>_RATE – the tax rate code applied and its numeric rate.
• TAX<n>_RATE_CODE_NAME, TAX<n>_RATE_CODE_DESCRIPTION – descriptive attributes of the rate code used in reporting.
• TAX<n>_RECOVERABLE_FLAG, TAX<n>_RECOVERY_RATE – recoverability indicator and recovery percentage.
• TAX<n>_AMT, TAX<n>_AMT_FUNCL_CUR / TAX<n>_AMT_FUNCL_CURR – tax amounts in entered and functional currency.
• TAX<n>_LINE_NUMBER – the tax line sequence reference.
• TAXABLE<n>_AMT, TAXABLE<n>_AMT_FUNCL_CURR – taxable bases and their functional-currency equivalents.
• TAX<n>_DISC_AMT, TAX<n>_DISC_AMT_FUNCL_CURR, TAXABLE_DISC_AMT – discount amounts per tax and the taxable discount base.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_LOGIN_ID – concurrent program context for the reporting process that populated the row.

Common Use Cases and Queries

This table supports tax matrix and audit reporting, where users need to view multiple tax lines and their recovered and taxable amounts alongside the source transaction detail. A typical query joins the parent table to retrieve full tax context:

• Join to parent detail: SELECT m.*, d.* FROM zx.zx_rep_matrix_ext_t m, zx.zx_rep_trx_detail_t d WHERE m.detail_tax_line_id = d.detail_tax_line_id.
• Recoverable tax analysis: filter on TAXn_RECOVERABLE_FLAG = 'Y' and aggregate TAXn_AMT_FUNCL_CURR by TAXn_REGIME_CODE to quantify recoverable versus non-recoverable tax.
• Functional-currency reconciliation: compare TAXn_AMT against TAXn_AMT_FUNCL_CURR, and TAXABLEn_AMT against TAXABLEn_AMT_FUNCL_CURR, to identify exchange differences.
• Concurrent program tracing: group by REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID to audit which reporting run produced specific rows.

Related Objects

The dominant relationship is with the parent reporting detail table and the surrounding E-Business Tax reporting model:

• ZX_REP_TRX_DETAIL_T – joined on DETAIL_TAX_LINE_ID; the FK source and the table for which this object stores exactly one row per parent row.
• ZX_REP_MATRIX_EXT_T_U1 / _PK – the unique index and primary key constraints enforcing DETAIL_TAX_LINE_MAT_ID uniqueness.
• ZX_REP_TRX_TAX_LINES / related ZX_REP_* reporting tables – companion reporting objects populated by the same concurrent programs and commonly reported together.
• ZX tax determination objects (regime and rate code reference tables) – referenced conceptually through TAXn_REGIME_CODE and TAXn_RATE_CODE lookups.
• Concurrent program definitions in FND_CONCURRENT_PROGRAMS – linked via PROGRAM_ID and PROGRAM_APPLICATION_ID for run traceability.

As with any ZX reporting object, this table should be treated as read-only reference data generated by the tax reporting process rather than as a source of transactional truth.