Results for “aso_payments”

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

Overview

ASO_PAYMENTS is a transaction table in the ASO (Order Capture) schema of Oracle E-Business Suite, present and valid in both release 12.1.1 and 12.2.2. It stores payment-related information captured against a quote, including payment type, terms, credit card details, and monetary amounts. Because a single quote can carry multiple payment records across header, line, or shipment granularity levels, ASO_PAYMENTS functions as a child of the quote hierarchy rather than as a standalone entity. In the heuristic Data Vault classification mined from its foreign key structure, the table is best modeled as a link: it connects quote headers, quote lines, shipments, payment terms, and payment transaction extensions into a single associative record. The table is owned by ASO and carries 50 documented columns in the 12.2.2 physical schema.

Key Information Stored

The surrogate primary key is ASO_PAYMENTS_PK, defined on the single column PAYMENT_ID. A unique index, ASO_PAYMENTS_U1, is also defined on PAYMENT_ID, making it the only documented business-key candidate; all other uniqueness is enforced through the foreign key relationships to the quote hierarchy. The most significant columns are:

• PAYMENT_ID — surrogate primary key and the value a search for "aso_payments_pk" resolves to.
• QUOTE_HEADER_ID — foreign key to ASO_QUOTE_HEADERS_ALL, identifying the parent quote.
• QUOTE_LINE_ID — foreign key to ASO_QUOTE_LINES_ALL, when payment applies at line level.
• QUOTE_SHIPMENT_ID — foreign key to ASO_SHIPMENTS, when payment applies at shipment level.
• PAYMENT_TYPE_CODE and PAYMENT_OPTION — classify how the quote will be paid.
• PAYMENT_TERM_ID and PAYMENT_TERM_ID_FROM — foreign keys to PN_PAYMENT_TERMS_ALL, capturing terms and their source.
• PAYMENT_AMOUNT — the monetary value recorded against the payment.
• PAYMENT_REF_NUMBER — external or internal payment reference.
• CREDIT_CARD_CODE, CREDIT_CARD_HOLDER_NAME, CREDIT_CARD_EXPIRATION_DATE, CREDIT_CARD_APPROVAL_CODE, CREDIT_CARD_APPROVAL_DATE — credit card capture and authorization data.
• TRXN_EXTENSION_ID — foreign key to IBY_FNDCPT_TX_EXTENSIONS, tying the payment to the iPayment transaction extension.
• CUST_PO_NUMBER and CUST_PO_LINE_NUMBER — customer purchase order references.
• SECURITY_GROUP_ID and OBJECT_VERSION_NUMBER — multi-tenant security and optimistic locking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive flexfield columns.
• WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) — audit and concurrent program lineage.

Common Use Cases and Queries

Typical reporting scenarios include listing all payment records for a quote header, reconciling credit card authorizations, and joining payment data to quote lines and shipments for order-to-cash analysis. A representative query joining the primary key to its parent quote is:

• SELECT p.payment_id, p.quote_header_id, p.payment_type_code, p.payment_amount FROM aso.aso_payments p WHERE p.quote_header_id = :header_id;
• SELECT p.payment_id, p.payment_ref_number, p.credit_card_approval_code FROM aso.aso_payments p WHERE p.trxn_extension_id IS NOT NULL;
• SELECT p.payment_id, l.quote_line_id, s.shipment_id FROM aso.aso_payments p JOIN aso.aso_quote_lines_all l ON p.quote_line_id = l.quote_line_id LEFT JOIN aso.aso_shipments s ON p.quote_shipment_id = s.shipment_id;

Because ASO_PAYMENTS participates in the Order Capture quote model, reporting tools and OBIEE extracts frequently filter by PAYMENT_TYPE_CODE and aggregate PAYMENT_AMOUNT for quote-to-order conversion dashboards.

Related Objects

The table sits at the intersection of the quote hierarchy and the payment infrastructure. The most significant related objects, with their documented join columns, are:

• ASO_QUOTE_HEADERS_ALL — joined via ASO_PAYMENTS.QUOTE_HEADER_ID.
• ASO_QUOTE_LINES_ALL — joined via ASO_PAYMENTS.QUOTE_LINE_ID.
• ASO_SHIPMENTS — joined via ASO_PAYMENTS.QUOTE_SHIPMENT_ID.
• PN_PAYMENT_TERMS_ALL — joined via ASO_PAYMENTS.PAYMENT_TERM_ID.
• IBY_FNDCPT_TX_EXTENSIONS — joined via ASO_PAYMENTS.TRXN_EXTENSION_ID.
• FND_SECURITY_GROUPS — joined via ASO_PAYMENTS.SECURITY_GROUP_ID.

These relationships confirm ASO_PAYMENTS as the associative link between quote commercial terms and the Oracle Payments transaction layer in Oracle EBS 12.1.1 and 12.2.2.