Search Results iby_trxn_ext_auths_v




Overview
Explore in AI Chat

Overview

The IBY_TRXN_EXT_AUTHS_V view is a dictionary-defined object owned by the APPS schema in Oracle E-Business Suite (12.1.1 and 12.2.2). It is delivered as part of the IBY — Payments product and presents consolidated authorization information for payment transactions processed through Oracle Payments. The view joins payment instrument extension records to their corresponding transaction operations, transaction summaries, core transaction data, credit card issuer information, and EFT processing profiles, producing a single denormalized result set suitable for reporting and integration consumption.

The view is marked VALID in ETRM and is typically consumed by external systems, reconciliation processes, and reporting layers that need to inspect the outcome of a payment authorization — including the settlement result, the authorization code, and the effective authorized amount — without navigating the underlying normalized Payments schema directly.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following objects (aliased in the view text):

The joins are largely inner joins across the extension, operation, summary, and core tables, with outer joins (+) on the credit card issuer, user EFT profile, and system EFT profile. The view filters on A.REQTYPE = 'ORAPMTREQ' and restricts transaction types to 2, 3, 20.

Key Columns

Common Use Cases and Queries

Typical scenarios include payment reconciliation, authorization status audits, and feeding downstream settlement systems by process profile.

SELECT authorization_id,
       authorization_status,
       authorization_result_code,
       effective_auth_amount,
       process_profile_code
  FROM apps.iby_trxn_ext_auths_v
 WHERE process_profile_code = :p_profile
   AND authorization_status = 'SETTLEMENT_PENDING';

To audit effective versus nominal authorization amounts by channel:

SELECT payment_channel_code, process_profile_code,
       SUM(authorization_amount)      authorized,
       SUM(effective_auth_amount)     effective
  FROM apps.iby_trxn_ext_auths_v
 GROUP BY payment_channel_code, process_profile_code;

The view should be treated as read-only; all corrective actions belong in the underlying IBY transaction tables.