Search Results ar_system_parameters_all




Overview
Explore in AI Chat

Overview

The AR_SYSTEM_PARAMETERS_ALL table is a central configuration repository within Oracle E-Business Suite Receivables (AR). It stores the system-level operational and accounting options that govern the behavior of the Receivables module across all operating units in a multi-org environment. Its role is critical for defining the default rules, accounts, and references used in core AR processes such as transaction processing, cash application, revenue recognition, and the calculation of late charges and finance charges. The presence of the ORG_ID column and the "_ALL" suffix signifies it is a multi-organization table, containing a distinct row of configuration parameters for each operating unit assigned to the Receivables responsibility.

Key Information Stored

The table's columns define the foundational setup for an operating unit. While the provided metadata highlights key foreign key relationships, the columns themselves hold critical configuration values. The SET_OF_BOOKS_ID column is paramount, linking the operating unit's AR transactions to the primary accounting ledger in General Ledger (GL). Other essential columns include default accounts for gains, losses, and revenue clearing (e.g., CODE_COMBINATION_ID_GAIN, REV_TRANSFER_CLEAR_CCID), and references to control transaction types and batch sources for automated charges (LATE_CHARGE_INV_TYPE_ID, LATE_CHARGE_BATCH_SOURCE_ID). It also stores identifiers for the hierarchy rules used in AutoCash (AUTOCASH_HIERARCHY_ID) and the specific receivables transactions used for penalties and service charges.

Common Use Cases and Queries

This table is primarily queried for configuration validation, audit reporting, and as a source for joins in operational reports. A common use case is verifying the ledger and key setup parameters for an operating unit. For instance, to retrieve the primary ledger and late charge setup for a specific operating unit, one might execute:

SELECT asp.set_of_books_id,
    asp.late_charge_inv_type_id,
    asp.late_charge_batch_source_id
FROM ar_system_parameters_all asp
WHERE asp.org_id = :p_org_id;

Another frequent pattern involves joining to GL_SETS_OF_BOOKS_11I to report on the ledger name, or to RA_CUST_TRX_TYPES_ALL to display the name of the default late charge transaction type. System administrators and functional consultants often query this table to document the complete Receivables system setup for an operating unit.

Related Objects

As documented in the foreign key metadata, AR_SYSTEM_PARAMETERS_ALL has integral relationships with several core EBS tables. The most significant relationship, and the one relevant to the user's search for "gl_sets_of_books_11i", is the dual foreign keys to the GL_SETS_OF_BOOKS_11I table. The first links via SET_OF_BOOKS_ID to define the primary ledger, and the second via CASH_BASIS_SET_OF_BOOKS_ID for cash basis accounting. Other critical documented relationships include:

  • RA_CUST_TRX_TYPES_ALL for the default Late Charge Invoice and Debit Memo transaction types (LATE_CHARGE_INV_TYPE_ID, LATE_CHARGE_DM_TYPE_ID).
  • RA_BATCH_SOURCES_ALL for the default Late Charge batch source (LATE_CHARGE_BATCH_SOURCE_ID).
  • AR_RECEIVABLES_TRX_ALL for transaction definitions used in Penalty, Finance Charge, and Service Charge calculations.
  • GL_CODE_COMBINATIONS for specific default accounting flexfields (e.g., gain account, revenue clearing account).
  • AR_AUTOCASH_HIERARCHIES for the default rule set governing automatic cash application.