Search Results ra_item_exception_rates




Overview
Explore in AI Chat

Overview

RA_ITEM_EXCEPTION_RATES is a Receivables (AR) transaction table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores product-level tax rate exceptions. It belongs to the AR schema and is validated across both releases. The table captures the reduced or overridden tax rates that apply to a specific inventory item when the standard tax rate determined by the item's tax classification is not applicable. In EBS Tax and Receivables processing, this object provides the exception data consumed during tax calculation for invoice lines, allowing a business to apply a distinct rate for an item within a defined period and reason.

Under the ETRM metadata, the object has 48 columns and a single-column primary key, RA_ITEM_EXCEPTION_RATES_PK, defined on ITEM_EXCEPTION_RATE_ID. The relational profile is essentially a satellite: the table extends a parent item with descriptive attributes (rates, reason, effective dates) and lacks the multi-parent structure typical of a link. This is a heuristic classification and should be treated as a modeling suggestion rather than a normative Data Vault designation.

Key Information Stored

The following columns represent the most functionally significant data held by RA_ITEM_EXCEPTION_RATES:

Common Use Cases and Queries

Typical uses include auditing tax exceptions applied to transactions, verifying the effective rate for an item on a given date, and reconciling exception records back to invoice lines.

To retrieve active exceptions for a given item:

SELECT ier.item_exception_rate_id,
       ier.item_id,
       ier.location1_rate,
       ier.reason_code,
       ier.start_date,
       ier.end_date
FROM   ar.ra_item_exception_rates ier
WHERE  ier.item_id = :p_item_id
AND    TRUNC(SYSDATE) BETWEEN ier.start_date
                          AND NVL(ier.end_date, TRUNC(SYSDATE));

To trace invoice lines that used an exception rate, join RA_CUSTOMER_TRX_LINES_ALL on ITEM_EXCEPTION_RATE_ID:

SELECT l.customer_trx_line_id,
       l.item_exception_rate_id,
       r.reason_code
FROM   ra_customer_trx_lines_all l,
       ra_item_exception_rates   r
WHERE  l.item_exception_rate_id = r.item_exception_rate_id(+);

The table supports period-based reporting on exception usage, reason-code analysis, and validation of the location segment data supplied through the ten LOCATION_ID_SEGMENT columns.

Related Objects

  • RA_CUSTOMER_TRX_LINES_ALL — references this table through ITEM_EXCEPTION_RATE_ID; the primary transactional consumer of exception rate records.
  • AR_TRX_LINES_GT — global temporary staging table that also references ITEM_EXCEPTION_RATE_ID during transaction interface processing.
  • AR_LOCATION_VALUES_OLD — referenced by each of the ten LOCATION_ID_SEGMENT_1 through LOCATION_ID_SEGMENT_10 foreign keys; supplies the valid location values used in rate determination.
  • RA_ITEM_EXCEPTION_RATES_PK / RA_ITEM_EXCEPTION_RATES_U1 — primary key and unique index on ITEM_EXCEPTION_RATE_ID, enforcing uniqueness for join integrity.

In practice, RA_ITEM_EXCEPTION_RATES is best treated as a satellite of the item and location reference data, with RA_CUSTOMER_TRX_LINES_ALL acting as the principal downstream consumer of its exception rates.