Search Results oe_system_parameters




Overview
Explore in AI Chat

Overview

OE_SYSTEM_PARAMETERS is an Oracle E-Business Suite (EBS) Order Management (ONT) view that exposes the Order Management system parameters applicable to the current operating unit. As documented in the ETRM metadata, the view is an "ORG stripped view based on the OE_SYSTEM_PARAMETERS_ALL table to get the system parameters for the current operating unit as set in the client info." In practice, this means the view presents a single row of Order Management setup and control values scoped to the operating unit currently established in the session, rather than returning parameters for every organization.

The view is available in both 12.1.1 and 12.2.2. It is a reporting and integration convenience object: report developers, form logic, and interfaces reference it instead of the underlying multi-org table so that the correct operating unit context is applied automatically through the USERENV('CLIENT_INFO') mechanism. The metadata notes that the view is "not implemented in this database" in the source ETRM record, which simply indicates it was not present in the particular instance from which the metadata was extracted; the definition remains the canonical documented form.

Underlying Base Objects

The view text shows OE_SYSTEM_PARAMETERS is defined over three objects:

  • OE_SYSTEM_PARAMETERS_ALL — the base multi-org table holding the system parameter values across organizations. The view selects from it and filters to the current operating unit.
  • HR_ORGANIZATION_UNITS HOU — outer-joined (flagged with (+)) on ORG_ID to resolve the organization name for the operating unit.
  • HR_ORGANIZATION_UNITS HU2 — joined on MASTER_ORGANIZATION_ID to resolve the master organization name.

The operating unit restriction is enforced by the predicate comparing ORG_ID against the value decoded from USERENV('CLIENT_INFO'), with a fallback of -99 when the client information is blank or unset. Multiple organizations are supported (the view is not marked as a single-org view), and the same underlying table Oe_System_Parameters (without the _ALL suffix) may be referenced in code where org stripping is already guaranteed.

Key Columns

Common Use Cases and Queries

The most common use is retrieving Order Management setup values for the active operating unit within a report or concurrent program. A representative query follows:

  • SELECT organization_name, master_organization_name, credit_hold_level_code, process_orders_sorted_by FROM oe_system_parameters;
  • SELECT org_id, customer_relationships_flag, audit_trail_enable_flag, compute_margin_flag FROM oe_system_parameters WHERE org_id = :p_org_id;

Because the view filters on client information, it is typically queried after the operating unit context has been initialized (for example, from a responsibility bound to a single operating unit). Developers requiring a specific organization regardless of session context should query OE_SYSTEM_PARAMETERS_ALL directly and apply an explicit ORG_ID predicate.