Search Results ra_customer_trx_lines_all




Overview
Explore in AI Chat

Overview

RA_CUSTOMER_TRX_LINES_ALL is the core transactional line table in the Oracle Receivables (AR) module. It stores the individual invoice, debit memo, chargeback, credit memo, and commitment lines that make up the header records held in RA_CUSTOMER_TRX_ALL. Every receivable document created in Oracle E-Business Suite, whether entered manually, imported through AutoInvoice, or generated by an external source such as Order Management, decomposes into one or more rows in this table. The table is owned by the AR schema and is classified as VALID in the ETRM repository for both Release 12.1.1 and 12.2.2, where it is documented with 158 columns.

The heuristic Data Vault classification mined from the foreign key structure is hub-leaning. This suggests that, in a dimensional or Data Vault style model, RA_CUSTOMER_TRX_LINES_ALL is best treated as the central hub for transaction line events, with satellites capturing descriptive, tax, revenue, and accounting attributes that change over time. The table participates in a dense network of relationships, both as a child of RA_CUSTOMER_TRX_ALL and as a parent to numerous downstream AR, subledger accounting, and external application tables.

Key Information Stored

The surrogate primary key is CUSTOMER_TRX_LINE_ID, enforced by the RA_CUSTOMER_TRX_LINES_PK constraint and the unique index RA_CUSTOMER_TRX_LINES_U1. This column uniquely identifies each line and is the join key used across nearly every dependent table. The business-key candidate is the composite of CUSTOMER_TRX_ID and LINE_NUMBER, enforced by the RA_CUSTOMER_TRX_LINES_UK1 unique index, which ties the line to its parent transaction in document-number sequence.

Common Use Cases and Queries

The table is central to receivables reporting, revenue analysis, tax reconciliation, and integration reconciliation. A typical pattern joins the line table back to the transaction header to obtain customer and document context:

  • Transaction detail reporting: join RA_CUSTOMER_TRX_LINES_ALL to RA_CUSTOMER_TRX_ALL on CUSTOMER_TRX_ID to retrieve invoice number, customer, and line amounts for a given period.
  • Revenue recognition review: join to RA_RULES on ACCOUNTING_RULE_ID and to the distribution table RA_CUST_TRX_LINE_GL_DIST_ALL on CUSTOMER_TRX_LINE_ID to analyze deferred versus recognized revenue.
  • Credit and adjustment lineage: self-joins on PREVIOUS_CUSTOMER_TRX_LINE_ID or LINK_TO_CUST_TRX_LINE_ID trace credit memos and chargebacks to the original invoice line, essential for returns analysis.
  • Tax reconciliation: join to ZX_LINES on TAX_LINE_ID and to AR_SALES_TAX on SALES_TAX_ID to reconcile calculated tax against recorded tax.
  • AutoInvoice validation: compare lines staged in RA_INTERFACE_LINES_ALL against inserted RA_CUSTOMER_TRX_LINES_ALL rows to detect import failures.

Related Objects