Search Results ar_receivables_trx_all




Overview
Explore in AI Chat

Overview

The AR_RECEIVABLES_TRX_ALL table is a core transactional and accounting setup table within Oracle E-Business Suite Receivables (AR) for versions 12.1.1 and 12.2.2. It serves as the master repository for defining and storing accounting rules for various Receivables activities. Each record represents a unique "Receivables Transaction Type," which is a configuration that dictates the general ledger (GL) accounts to be used for specific financial events. Its primary role is to ensure proper and consistent accounting by providing the default accounting flexfield (code combination) for transactions such as adjustments, cash receipts, finance charges, and penalties. The '_ALL' suffix denotes that it is a multi-organization access enabled (MOAC) table, storing data partitioned by the ORG_ID column.

Key Information Stored

The table's structure centers on linking a transaction type definition to its corresponding accounting instructions. The primary key is RECEIVABLES_TRX_ID, a unique internal identifier. The NAME column provides the unique, user-defined name for the transaction type (e.g., 'Finance Charge', 'Penalty', 'Manual Receipt'). The critical accounting linkage is the CODE_COMBINATION_ID, a foreign key to GL_CODE_COMBINATIONS, which stores the default GL account. The SET_OF_BOOKS_ID links the definition to a specific ledger. Other significant columns include DEFAULT_ACCTG_DISTRIBUTION_SET, which can reference a predefined distribution set from AR_DISTRIBUTION_SETS_ALL for more complex accounting rules, and STATUS, which controls whether the definition is active.

Common Use Cases and Queries

This table is central to financial reporting and transaction processing. A common use case is tracing the GL account used for a specific adjustment or receipt. For instance, to find the account used for all finance charge adjustments, one would join AR_ADJUSTMENTS_ALL to this table. Another critical scenario is system configuration, where administrators define or modify transaction types for new business requirements. A typical diagnostic query retrieves the setup for all active transaction types within a specific ledger:

  • SELECT art.name, art.description, gcc.segment1, gcc.segment2 FROM ar_receivables_trx_all art, gl_code_combinations gcc WHERE art.code_combination_id = gcc.code_combination_id AND art.set_of_books_id = &set_of_books_id AND art.status = 'A';

This table is also essential for reconciling subledger (Receivables) activity to the general ledger, as it provides the source of the accounted entries.

Related Objects

As indicated by its extensive foreign key relationships, AR_RECEIVABLES_TRX_ALL is a foundational object referenced by numerous transactional and setup tables. Key dependent transactional tables include AR_ADJUSTMENTS_ALL, AR_CASH_RECEIPTS_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL, which use RECEIVABLES_TRX_ID to inherit accounting rules. Setup tables like AR_SYSTEM_PARAMETERS_ALL reference it for system-wide defaults (e.g., PENALTY_REC_TRX_ID, FINCHRG_RECEIVABLES_TRX_ID). It is also referenced by payment-related setup in AR_RECEIPT_METHOD_ACCOUNTS_ALL and CE_BANK_ACCT_USES_ALL for defining accounts for earned and unearned discount activities. The table maintains integrity through its foreign keys to master tables GL_CODE_COMBINATIONS, GL_SETS_OF_BOOKS, and AR_DISTRIBUTION_SETS_ALL.