Search Results oe_payments




Overview
Explore in AI Chat

Overview

OE_PAYMENTS is a transactional table in the ONT (Order Management) schema of Oracle E-Business Suite, holding commitment payment information captured against order headers and lines. It supports payment-related processing for order management transactions, including credit card authorizations, receipt method details, and commitment amounts applied or interfaced to downstream financial systems. The table exists in both Release 12.1.1 and 12.2.2 with a documented physical schema of 53 columns in 12.2.2.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is standalone. This suggests OE_PAYMENTS behaves primarily as an independent entity rather than a dependent link or satellite, though its foreign keys to AR_RECEIPT_METHODS and IBY_FNDCPT_TX_EXTENSIONS indicate enrichment relationships that a formal model might treat as reference or lookup links.

Key Information Stored

The surrogate primary key is PAYMENT_TRX_ID. A unique index, OE_PAYMENTS_U1, defines the business-key candidate as the combination of HEADER_ID, LINE_ID, and PAYMENT_NUMBER, establishing payment uniqueness within an order line context.

The most significant columns include:

Common Use Cases and Queries

Typical reporting scenarios include reconciling order commitment payments, auditing credit card authorizations, and tracking amounts interfaced to receivables. A representative query retrieves all payments for a given order:

  • SELECT p.PAYMENT_NUMBER, p.PAYMENT_AMOUNT, p.PAYMENT_TYPE_CODE, p.RECEIPT_METHOD_ID FROM OE_PAYMENTS p WHERE p.HEADER_ID = :header_id;
  • Join to AR_RECEIPT_METHODS on RECEIPT_METHOD_ID to resolve the receipt method name for payment method reporting.
  • Aggregate COMMITMENT_APPLIED_AMOUNT and COMMITMENT_INTERFACED_AMOUNT by HEADER_ID to validate interfacing completeness.
  • Filter on DEFER_PAYMENT_PROCESSING_FLAG and INVOICED_FLAG to isolate payments pending invoicing.

Related Objects

The following objects are most significant in relation to OE_PAYMENTS:

  • AR_RECEIPT_METHODS — referenced via RECEIPT_METHOD_ID; defines the receipt method used for the payment.
  • IBY_FNDCPT_TX_EXTENSIONS — referenced via TRXN_EXTENSION_ID; supplies payment transaction extension attributes.
  • OE_ORDER_HEADERS_ALL — parent order header identified by HEADER_ID.
  • OE_ORDER_LINES_ALL — parent order line identified by LINE_ID.
  • OE_PAYMENTS_U1 — unique index enforcing the HEADER_ID, LINE_ID, PAYMENT_NUMBER business key.