Results for “ar_system_parameters_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR.AR_SYSTEM_PARAMETERS_ALL is the Oracle Receivables table that stores system-level options and default settings for each operating unit in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Each row defines the behavior of the Receivables module for a given ORG_ID, including accounting rules, tax defaults, AutoInvoice processing controls, AutoCash hierarchy, late charge configuration, credit and refund limits, and receipt matching behavior. Because it drives validation, defaulting, and posting logic across most Receivables functions, it is one of the primary configuration objects consulted at runtime by concurrent programs, forms, and public APIs.

The ETRM documentation records this object as a VALID table owned by the AR schema, with 153 documented columns. The Primary Key is AR_SYSTEM_PARAMETERS_PK, defined on ORG_ID. The metadata classifies this object heuristically as a Data Vault link, reflecting the fact that it interconnects Receivables system configuration with operational reference entities such as set of books, transaction types, batch sources, receivables activities, and GL code combinations.

Key Information Stored

The table’s grain is one row per operating unit, identified by ORG_ID, which serves as the primary key and the strongest business-key candidate. Because there is only one configuration row per organization, no additional unique index is required beyond the PK.

• ORG_ID — the operating unit identifier and sole primary key column.
• SET_OF_BOOKS_ID — the ledger (set of books) associated with the Receivables configuration.
• CASH_BASIS_SET_OF_BOOKS_ID — ledger reference used for cash-basis accounting.
• ACCOUNTING_METHOD — accrual versus cash basis processing.
• TAX_METHOD — the default tax calculation method (e.g., VAT, Sales Tax).
• CODE_COMBINATION_ID_GAIN / CODE_COMBINATION_ID_LOSS — GL accounts for exchange rate gain and loss posting.
• AUTOCASH_HIERARCHY_ID — the AutoCash rule hierarchy applied during receipt application.
• FINCHRG_RECEIVABLES_TRX_ID, PENALTY_REC_TRX_ID, IREC_SERVICE_CHARGE_REC_TRX_ID — receivables activities used for finance charges, penalties, and interest invoice service charges.
• LATE_CHARGE_INV_TYPE_ID, LATE_CHARGE_DM_TYPE_ID, LATE_CHARGE_BATCH_SOURCE_ID — transaction type, debit memo type, and batch source for late charge generation.
• REV_TRANSFER_CLEAR_CCID — clearance account for revenue transfer clearing.
• AUTO_REC_INVOICES_PER_COMMIT / AUTO_REC_RECEIPTS_PER_COMMIT — commit sizing for AutoInvoice/AutoLockbox processing.
• SALES_CREDIT_PCT_LIMIT, MAX_WRTOFF_AMOUNT, MIN_WRTOFF_AMOUNT, MIN_REFUND_AMOUNT — credit and adjustment thresholds.

Common Use Cases and Queries

Common usage centers on retrieving configuration for reporting, diagnosing AutoInvoice or AutoCash behavior, and validating setup before running Receivables processes. A typical query joins the table to the ledger and reference entities:

SELECT org_id, set_of_books_id, accounting_method, tax_method, autocash_hierarchy_id
FROM ar.ar_system_parameters_all
WHERE org_id = :org_id;

Reports frequently join to RA_CUST_TRX_TYPES_ALL, AR_RECEIVABLES_TRX_ALL, and GL_CODE_COMBINATIONS to resolve IDs into meaningful names. Operational diagnostics compare current settings against expected values before month-end close, and personalizations or extensions reference the same row to determine defaulting behavior.

Related Objects

• AR_SET_OF_BOOKS / ledger tables, referenced via SET_OF_BOOKS_ID and CASH_BASIS_SET_OF_BOOKS_ID.
• RA_CUST_TRX_TYPES_ALL, joined on LATE_CHARGE_INV_TYPE_ID and LATE_CHARGE_DM_TYPE_ID.
• RA_BATCH_SOURCES_ALL, joined on LATE_CHARGE_BATCH_SOURCE_ID.
• AR_RECEIVABLES_TRX_ALL, joined on PENALTY_REC_TRX_ID, FINCHRG_RECEIVABLES_TRX_ID, and IREC_SERVICE_CHARGE_REC_TRX_ID.
• GL_CODE_COMBINATIONS, joined on CODE_COMBINATION_ID_GAIN and REV_TRANSFER_CLEAR_CCID.
• AR_AUTOCASH_HIERARCHIES, joined on AUTOCASH_HIERARCHY_ID.