Search Results ar_receivable_applications_all




Overview
Explore in AI Chat

Overview

The AR_RECEIVABLE_APPLICATIONS_ALL table is a core transactional table within Oracle E-Business Suite Receivables (AR). It serves as the central repository for all accounting information related to the application of cash receipts and credit memos against outstanding debit items, such as invoices and debit memos. This table is fundamental to the cash application and settlement process, recording the financial linkages that reduce customer account balances and update the general ledger. Its multi-org structure, indicated by the "_ALL" suffix, stores data for all operating units, with access typically controlled by the MOAC (Multi-Org Access Control) security profile.

Key Information Stored

The table's primary key is RECEIVABLE_APPLICATION_ID. Its columns define the complete financial relationship between the applied item and the target item. Critical columns include CASH_RECEIPT_ID (link to the receipt), PAYMENT_SCHEDULE_ID (link to the target invoice schedule), APPLIED_PAYMENT_SCHEDULE_ID (link to the applied credit memo schedule), and AMOUNT_APPLIED. Accounting is managed via CODE_COMBINATION_ID for the main entry, with separate columns for EARNED_DISCOUNT_CCID and UNEARNED_DISCOUNT_CCID. The STATUS column indicates if the application is 'APP', 'UNAPP', 'ACC', or 'UNID'. The SET_OF_BOOKS_ID ties the entry to a specific ledger, and POSTING_CONTROL_ID manages the transfer of this data to the general ledger.

Common Use Cases and Queries

This table is essential for reconciliation, audit reporting, and custom aging analyses. Common queries involve tracing the application history of a specific cash receipt or invoice. For example, to find all applications for a given invoice payment schedule, one would query: SELECT * FROM ar_receivable_applications_all WHERE payment_schedule_id = <PS_ID>;. To analyze unapplied cash for a customer, a query would join to AR_PAYMENT_SCHEDULES_ALL and filter on status = 'UNAPP'. Reporting on earned discount activity requires joining the table to GL_CODE_COMBINATIONS via the EARNED_DISCOUNT_CCID. The table is also central for troubleshooting accounting entries generated by the Receivables to General Ledger transfer process.

Related Objects

The table maintains extensive foreign key relationships with other core Receivables and General Ledger tables, as documented in the ETRM metadata. Primary relationships include:

These relationships enforce data integrity and are critical for constructing accurate joins in operational and financial reports.