Results for “oe_sys_params_upg”

22 results




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

Overview

OE_SYS_PARAMS_UPG is an APPS-owned view in the Oracle E-Business Suite Order Management (ONT) module. It exposes the upgraded Order Management system parameters at the operating unit level, joining organizational context to the parameter values maintained in the underlying OE_SYS_PARAMS_UPG_V view. The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is classified under the ONT - Order Management product. It is commonly referenced during reporting, diagnostics and integration work involving Order Management setup, particularly where the master organization relationship must be resolved for each operating unit. Because the view surfaces a resolved organization name for the master organization, it is a practical source for identifying the master organization assigned to an operating unit without writing custom joins against HR_ORGANIZATION_UNITS.

Underlying Base Objects

Per the documented view text and ETRM 12.2.2 metadata, OE_SYS_PARAMS_UPG is defined over the following referenced objects:

  • OE_SYS_PARAMS_UPG_V (VIEW) — the primary source, aliased SP, supplying the system parameter columns.
  • HR_ORGANIZATION_UNITS (VIEW) — joined twice, as HOU and HOU2, to resolve the operating unit name and the master organization name respectively.
  • OE_SYS_PARAMETERS (PACKAGE) — invoked in the WHERE clause via OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID', SP.ORG_ID) to resolve the master organization ID for each operating unit.
  • HR_GENERAL (PACKAGE) and HR_SECURITY (PACKAGE) — referenced indirectly through HR_ORGANIZATION_UNITS to support organizational security and name resolution.

The join predicates are SP.ORG_ID = HOU.ORGANIZATION_ID(+) for the operating unit name and OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID', SP.ORG_ID) = HOU2.ORGANIZATION_ID for the master organization name. The outer join on HOU allows parameters to remain visible even where no matching organization unit row exists.

Key Columns

Common Use Cases and Queries

Typical scenarios include verifying which master organization is tied to an operating unit, extracting Order Management parameter settings for audit or migration, and resolving MASTER_ORGANIZATION_NAME for reporting joins. A common query filters by either the operating unit name or the master organization name:

  • SELECT org_id, organization_name, master_organization_id, master_organization_name FROM oe_sys_params_upg WHERE master_organization_name = '&master_org';
  • SELECT org_id, organization_name, compute_margin_flag, freight_rating_enabled_flag FROM oe_sys_params_upg WHERE org_id = &org_id;
  • SELECT master_organization_id, master_organization_name FROM oe_sys_params_upg ORDER BY organization_name;

Because the view depends on organizational security and the OE_SYS_PARAMETERS package, users should ensure the querying responsibility has access to the relevant operating units; otherwise HR_SECURITY may filter results. The view is read-only in practice and should not be used for updates, as the underlying data is maintained through Order Management setup rather than direct DML.