Search Results ar_system_param_h_v




Overview
Explore in AI Chat

Overview

AR_SYSTEM_PARAM_H_V is a dictionary view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family and is documented as VALID in the ETRM repository. The view presents a consolidated projection of Receivables system parameters joined to header-level extract lines maintained by the Subledger Accounting (XLA) engine, specifically for the cash basis accounting configuration and the gain/loss accounting flexfield assignments.

The name suffix "H" denotes the header level of the join, which is confirmed by the predicate HE.LEVEL_FLAG = 'H' in the view definition. This makes AR_SYSTEM_PARAM_H_V a convenient access point for resolving the accounting code combinations used when Receivables generates cash basis gain and loss entries, without requiring the caller to reconcile AR_SYSTEM_PARAMETERS_ALL against AR_XLA_LINES_EXTRACT manually.

Underlying Base Objects

The view is defined over two synonyms and references one package, all resolved within the APPS schema:

  • AR_SYSTEM_PARAMETERS_ALL (synonym) — the primary source of Receivables system-level setup, supplying the cash basis set of books, the gain code combination, the loss code combination, and the operating unit context via ORG_ID.
  • AR_XLA_LINES_EXTRACT (synonym) — the Subledger Accounting extraction entity that supplies header-level rows (LEVEL_FLAG = 'H') and the associated EVENT_ID.
  • FND_PROFILE (package) — referenced for the profile option infrastructure that governs operating unit and ledger context resolution at runtime.

The join is driven by ORG_ID equality between the two synonyms, with the header-level filter applied to the extract side. Because AR_SYSTEM_PARAMETERS_ALL is partitioned by operating unit (ORG_ID), the resulting view returns one logical row per matching header extract record per organization.

Key Columns

  • CASH_BASIS_SET_OF_BOOKS_ID — identifies the set of books designated for cash basis accounting in Receivables system parameters.
  • CODE_COMBINATION_ID_GAIN — the accounting flexfield combination used to record realized or unrealized exchange gain entries.
  • CODE_COMBINATION_ID_LOSS — the accounting flexfield combination used for exchange loss entries. This column is the target of the "code_combination_id_loss" search term and is exposed here as an NVL-protected value: the view text applies NVL(SYS.CODE_COMBINATION_ID_LOSS, SYS.CODE_COMBINATION_ID_GAIN), so when no dedicated loss account is configured, the gain account is returned instead. Consumers should therefore treat a non-null result as "the effective loss account" rather than a guarantee that a distinct loss combination exists.
  • SET_OF_BOOKS_ID — the set of books associated with the system parameter row, aliased in the column list as LEDGER_ID in the documented metadata.
  • EVENT_ID — the Subledger Accounting event identifier sourced from AR_XLA_LINES_EXTRACT for the matching header line.

Common Use Cases and Queries

The view is principally used to diagnose or report on the accounting combinations that Receivables will apply to cash basis gain and loss postings, and to trace those assignments back to their originating XLA event headers. A typical query resolves the effective loss account for an organization:

  • SELECT code_combination_id_gain, code_combination_id_loss FROM apps.ar_system_param_h_v WHERE set_of_books_id = :p_sob;
  • Join CODE_COMBINATION_ID_LOSS to FND_FLEX_VALUES_VL or GL_CODE_COMBINATIONS to render the human-readable account string for audit or reconciliation reports.
  • Restrict by EVENT_ID against AR_XLA_LINES_EXTRACT when investigating why a specific subledger event extracted an unexpected loss account.
  • Compare CASH_BASIS_SET_OF_BOOKS_ID across operating units to verify cash basis configuration consistency before period close.

Because the NVL expression can mask a missing loss configuration, reports intended to flag incomplete setup should query AR_SYSTEM_PARAMETERS_ALL directly to detect a null CODE_COMBINATION_ID_LOSS.