Search Results transaction_reason_code

Overview

JL_BR_PO_FUNCTIONAL_MATRIX is a configuration and reference table within the Oracle E-Business Suite Latin America Localizations (JL) module, specifically targeting Brazilian fiscal requirements for purchase order processing. The table stores tax recoverability rules and compounded base information for two of Brazil's most significant transaction taxes: IPI (Imposto sobre Produtos Industrializados, a federal excise tax on manufactured goods) and ICMS (Imposto sobre Circulação de Mercadorias e Serviços, a state-level value-added tax). Its role is to define, by fiscal context, whether and how IPI and ICMS amounts embedded in a purchase order are recoverable as tax credits, and how compounded tax bases are calculated when taxes apply on top of one another.

The ETRM metadata classifies this object as standalone under a heuristic Data Vault assessment, meaning the mined foreign-key structure shows no dependency edges to other objects. From a data-modeling perspective this suggests treating the table as a reference hub or reference satellite: the composite business key itself functions as the identity, and the non-key attributes (recoverability and compounding flags/rates) are descriptive payload. Because no FK relationships were mined, no separate link table is implied.

Key Information Stored

The table is keyed by a single composite primary key, JL_BR_PO_FUNCTIONAL_MATRIX_PK, which is composed of three business-key columns rather than a generated surrogate. Consequently, all three PK columns are simultaneously business-key candidates and no independent unique index is documented beyond the PK constraint itself.

• CONTRIBUTOR_TYPE — Identifies the contributing party or fiscal role for which the matrix row applies. This is the column the user searched for, and it is the first component of the composite primary key. It distinguishes the entity contributing to the transaction, driving which recoverability rules are selected.
• ESTABLISHMENT_TYPE — Defines the establishment or business-purpose classification (for example, industrial, commercial, or equivalent fiscal establishment category) under which the rule is valid. It is the second PK component and scopes the rule to a location or organizational behavior.
• TRANSACTION_REASON_CODE — Supplies the fiscal reason or nature of the transaction, the third PK component. Together with the prior two columns, it uniquely identifies the functional rule.
• IPI recoverability and compounding attributes — Documented as the descriptive payload: indicators and parameters governing whether IPI is recoverable and whether the IPI base is compounded onto another tax base.
• ICMS recoverability and compounding attributes — The parallel descriptive payload for ICMS, controlling credit recoverability and compounded-base treatment.

Common Use Cases and Queries

The primary use case is generation and validation of Brazilian purchase order tax lines, where the tax engine resolves IPI and ICMS recoverability and compounded-base treatment by looking up the keying combination. Reporting scenarios include audit extracts of recoverability rules, impact analysis when fiscal legislation changes, and diagnostic queries explaining why a particular PO line recovered or did not recover a tax credit.

A typical lookup pattern constrains the three key columns:

• SELECT * FROM JL_BR_PO_FUNCTIONAL_MATRIX WHERE contributor_type = :p_contributor AND establishment_type = :p_estab AND transaction_reason_code = :p_reason;
• Distinct-value profiling: SELECT contributor_type, COUNT(*) FROM JL_BR_PO_FUNCTIONAL_MATRIX GROUP BY contributor_type;
• Completeness check across the full key space via a cross-join of the three key domains, flagging combinations with no configured rule.

Note the metadata states the table is not implemented in this database; queries must therefore be run only in environments where the JL Brazil localization is licensed and installed.

Related Objects

The mined FK structure is empty, so related objects are inferred from module context rather than documented joins. The most significant are: JL_BR_PO_FUNCTIONAL_MATRIX is consulted by the Brazilian PO tax calculation and validation logic, and shares its keying conventions with other JL Brazil fiscal reference tables keyed on contributor, establishment, and transaction reason. Actual join columns are limited to the three PK columns: CONTRIBUTOR_TYPE, ESTABLISHMENT_TYPE, and TRANSACTION_REASON_CODE. Because no foreign keys were mined, any joins to purchase order, supplier, or fiscal classification tables should be validated in the target instance before being relied upon.