Oracle tables related to the Accounts Receivables(AR)

Here are some of the common Oracle tables related to the Accounts Receivables in Oracle Fusion 

Oracle Fusion Accounts Receivables (AR) stores key transactional and configuration data across various tables. 

Below are the important tables in Oracle Fusion AR categorized by their function:

1. Customer and Party Tables

• HZ_PARTIES – Stores customer and other party information.
• HZ_CUST_ACCOUNTS – Holds customer account details linked to HZ_PARTIES.
• HZ_CUST_SITE_USES_ALL – Stores customer site usages (e.g., Bill-To, Ship-To).
• HZ_LOCATIONS – Stores address/location details.
• HZ_CONTACT_POINTS – Contains customer contact information.

2. Transactions (Invoices, Credit Memos, Debit Memos)

• RA_CUSTOMER_TRX_ALL – Stores AR transaction headers (invoices, credit memos, debit memos).
• RA_CUSTOMER_TRX_LINES_ALL – Holds transaction line details, linked to RA_CUSTOMER_TRX_ALL.
• RA_CUST_TRX_LINE_GL_DIST_ALL – Stores GL distribution details for transactions.
• RA_CUST_TRX_TYPES_ALL – Stores transaction types (Standard Invoice, Credit Memo, etc.).

3. Receipts and Payments

• AR_CASH_RECEIPTS_ALL – Holds receipt headers (payments made by customers).
• AR_CASH_RECEIPT_HISTORY_ALL – Stores receipt status history.
• AR_RECEIVABLE_APPLICATIONS_ALL – Stores details of receipt applications (linking receipts to invoices).
• AR_PAYMENT_SCHEDULES_ALL – Holds invoice payment schedules.

4. Adjustments, Refunds, and Chargebacks

• AR_ADJUSTMENTS_ALL – Stores adjustment details applied to invoices.
• AR_REFUNDS_ALL – Contains refund details linked to receipts.
• AR_CASH_RECEIPT_HISTORY_ALL – Maintains historical data for cash receipts.
• AR_CHARGEBACKS_ALL – Stores chargeback-related information.

5. Accounting Tables

• XLA_AE_HEADERS – Stores accounting entry headers.
• XLA_AE_LINES – Holds accounting line details.
• XLA_DISTRIBUTION_LINKS – Links subledger data to accounting transactions.
• GL_IMPORT_REFERENCES – Links AR transactions to General Ledger (GL).

6. Aging and Collections

• AR_AGING_BUCKETS – Defines aging bucket configurations.
• AR_AGED_TRIAL_BALANCE – Holds aged balances for customer transactions.