Oracle Fusion/Financials/AR

RA_CUSTOMER_TRX_LINES_ALL

Transaction line detail — revenue, tax, freight, and rounding lines.

Key Columns

CUSTOMER_TRX_IDCUSTOMER_TRX_LINE_IDLINE_TYPE

Parent Table

RA_CUSTOMER_TRX_ALL

AR transaction header — invoice, credit memo, or debit memo issued to a customer.

Child Tables

RA_CUST_TRX_LINE_GL_DIST_ALL

GL distribution generated from transaction lines for accounting.

Common Joins

RA_CUSTOMER_TRX_ALLvia CUSTOMER_TRX_ID

The transaction header this line belongs to — customer, transaction number, and date.

RA_CUST_TRX_LINE_GL_DIST_ALLvia CUSTOMER_TRX_LINE_ID

The GL accounting distribution generated from this line once Create Accounting runs.

Used In

Creating an AR invoice

Manual AR invoices are created from Receivables > Billing > Create Transaction, generating a header in RA_CUSTOMER_TRX_ALL with lines in RA_CUSTOMER_TRX_LINES_ALL.

CreditMemoService — create and apply an AR credit memo via SOAP

CreditMemoService is the Oracle Fusion Receivables SOAP web service for creating standard credit memos. WSDL: https://<your-fusion-host>:443/fscmService/CreditMemoService?WSDL (POST the SOAP envelope to the same URL without ?WSDL, WS-Security UsernameToken). Primary operation: createCreditMemo, which takes a credit-memo header (business unit, transaction source, transaction type, date, bill-to customer/site, currency) plus a repeating line block (line number, description, amount, tax classification). Application to an existing invoice is expressed on the request by referencing the transaction being credited (the 'apply to' / applied-to-document element on the header or line) — confirm the exact element names against the WSDL for your release. It returns the created credit memo's customer transaction id and number.