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
- ROW_ID — the ROWID of the underlying OE_SYS_PARAMS_UPG_V row, useful for direct row identification and DML targeting.
- ORG_ID — the operating unit identifier for which the system parameters are defined.
- ORGANIZATION_NAME — the name of the operating unit, resolved from HR_ORGANIZATION_UNITS.
- MASTER_ORGANIZATION_ID — the identifier of the master organization associated with the operating unit, retrieved via the OE_SYS_PARAMETERS package.
- MASTER_ORGANIZATION_NAME — the name of the master organization, resolved through the second HR_ORGANIZATION_UNITS join; this column directly corresponds to the searched term.
- CUSTOMER_RELATIONSHIPS_FLAG, AUDIT_TRAIL_ENABLE_FLAG, COMPUTE_MARGIN_FLAG, FREIGHT_RATING_ENABLED_FLAG, FTE_SHIP_METHOD_ENABLED_FLAG — configuration flags reflecting Order Management behavior settings.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
- CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield context and segment 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.
-
View: OE_SYS_PARAMS_UPG 12.1.1
APPS.OE_SYS_PARAMS_UPG·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ONT module →
-
View: OE_SYS_PARAMS_UPG 12.2.2
APPS.OE_SYS_PARAMS_UPG·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ONT module →
-
VIEW: APPS.OE_SYS_PARAMS_UPG 12.2.2
-
VIEW: APPS.OE_SYS_PARAMS_UPG 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
eTRM - ONT Tables and Views 12.1.1
OM WorkFlow Activity Skip Log.
-
eTRM - ONT Tables and Views 12.2.2
OM WorkFlow Activity Skip Log.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - ONT Tables and Views 12.1.1
OM WorkFlow Activity Skip Log.
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - ONT Tables and Views 12.2.2
OM WorkFlow Activity Skip Log.
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person