Results for “ar_system_parameters_ou_v”

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

Overview

The AR_SYSTEM_PARAMETERS_OU_V view is a Receivables (AR) reporting and integration object owned by the APPS schema. Its documented purpose is to expose, for each operating unit defined in the E-Business Suite, whether that operating unit has Receivables system options configured. The view text is attributed to Release 11.5 and remains valid in subsequent releases including 12.1.1 and 12.2.2, where Multi-Org access control is enforced through the MO_GLOBAL package.

The view joins the HR_OPERATING_UNITS definition of operating units to AR_SYSTEM_PARAMETERS_ALL using an outer join, so that every operating unit visible to the querying session appears in the result set regardless of whether AR system parameters exist for it. A derived column, SYSTEM_OPTION_DEFINED, returns 'YES' or 'NO' to indicate setup completion. Because it derives its data from the standard AR setup tables and applies Multi-Org security through MO_GLOBAL.CHECK_ACCESS, the view functions both as a configuration diagnostic and as a lightweight integration surface for external systems that need to confirm Receivables readiness per operating unit.

Underlying Base Objects

The view is defined over three documented base objects:

• AR_SYSTEM_PARAMETERS_ALL (SYNONYM) — the Receivables system options table, partitioned by ORG_ID and holding one row per operating unit that has completed AR setup.
• HR_OPERATING_UNITS (VIEW) — the Human Resources operating unit definition, supplying ORGANIZATION_ID, NAME, and related organizational attributes.
• MO_GLOBAL (PACKAGE) — the Multi-Org access control package; MO_GLOBAL.CHECK_ACCESS(HR.ORGANIZATION_ID) restricts results to operating units the current user is authorized to access.

The join between HR_OPERATING_UNITS and AR_SYSTEM_PARAMETERS_ALL is an outer join (AR.ORG_ID(+)), which guarantees that unconfigured operating units are still returned. The ORG_ID and SET_OF_BOOKS_ID columns of AR_SYSTEM_PARAMETERS_ALL drive the SYSTEM_OPTION_DEFINED and system-option logic.

Key Columns

• OPERATING_UNIT — the operating unit name, taken from HR.NAME.
• ORG_ID — the operating unit identifier (HR.ORGANIZATION_ID); the view is ordered by this column.
• SYSTEM_OPTION_DEFINED — derived flag. Returns 'NO' when AR.SET_OF_BOOKS_ID is either -1 or NULL, and 'YES' otherwise, indicating whether Receivables system options have been defined for the operating unit.

The DECODE expression central to the view treats the sentinel value -1 (and a missing row) as equivalent to "not defined," reflecting the internal representation used by Receivables before system options are saved.

Common Use Cases and Queries

The view is typically used to audit setup coverage, to drive user-facing lists of operating units, or to gate downstream integration calls. A standard query lists all accessible operating units and their setup status:

• SELECT OPERATING_UNIT, ORG_ID, SYSTEM_OPTION_DEFINED FROM APPS.AR_SYSTEM_PARAMETERS_OU_V ORDER BY ORG_ID;
• Filtering for unconfigured units: SELECT ORG_ID, OPERATING_UNIT FROM APPS.AR_SYSTEM_PARAMETERS_OU_V WHERE SYSTEM_OPTION_DEFINED = 'NO';
• Resolving an ORG_ID to its name during integration: SELECT OPERATING_UNIT FROM APPS.AR_SYSTEM_PARAMETERS_OU_V WHERE ORG_ID = :p_org_id;

Because access is filtered by MO_GLOBAL.CHECK_ACCESS, results are automatically restricted to the responsibilities and operating units to which the session is granted, making the view safe to expose in reports and lightweight API validation routines without additional security predicates.