Search Results oprn_class_desc




Overview
Explore in AI Chat

Overview

APPS.EDW_OPI_OPRN_OPRC_LCV is a reporting and integration view in the Oracle E-Business Suite (EBS) data warehouse layer, exposed under the APPS schema. The name follows Oracle's EDW (Enterprise Data Warehouse) naming convention for views that feed operational reporting, extract, and analytics pipelines spanning Oracle Process Manufacturing (OPM) and discrete manufacturing data models. The "LCV" suffix denotes a local coverage view within the EDW_OPI (Open Interfaces / Process Intelligence) family, indicating that it consolidates source records for extraction into downstream staging areas or BI repositories.

The view presents a denormalized, presentation-ready projection of operation class definitions. It combines the operation class code, the operation class description, and the local instance identifier into a single descriptive column, and additionally exposes the description ("oprn_class_desc") as a standalone field. This dual representation is characteristic of EDW coverage views, which frequently emit both a composite display value and individual attributes so that consumers do not have to concatenate values themselves. The view is documented in ETRM for Release 12.2.2 and applies equally to 12.1.1 deployments where the OPM and EDW modules are installed.

The mention of "oprn_class_desc" in search queries confirms that users reach this view primarily to resolve operation class descriptions rather than to perform transactional processing.

Underlying Base Objects

The documented view text defines the projection over exactly two base relations: FM_OPRN_CLS (aliased FO) and EDW_LOCAL_INSTANCE (aliased I). No additional base tables are documented in the ETRM metadata associated with this view.

  • FM_OPRN_CLS — the OPM operation class master table. It supplies OPRN_CLASS, OPRN_CLASS_DESC, LAST_UPDATE_DATE, and CREATION_DATE. This is the authoritative source for operation classification within process manufacturing.
  • EDW_LOCAL_INSTANCE — the EDW instance registry. It supplies INSTANCE_CODE, which identifies the source EBS instance and allows the view to stamp each row with its origin.

Because the FROM clause lists the two tables without a WHERE predicate, the view produces a cross join: every operation class row is combined with every row in EDW_LOCAL_INSTANCE. In a standard EBS installation this is typically a single-row instance record, so the effective cardinality equals the number of rows in FM_OPRN_CLS. In multi-instance or consolidated warehouse configurations, the row count multiplies by the number of registered instances, which is the intended behavior for local coverage views that must carry instance provenance.

Key Columns

  • Column 1 ('ALL') — a literal constant, conventionally used by EDW ETL routines as a wildcard or aggregation marker.
  • Column 2 (OPRN_CLASS || '-' || I.INSTANCE_CODE || '-OPM') — the composite key or display code, blending the operation class, instance code, and the "-OPM" suffix that flags the process manufacturing origin.
  • Column 3 ('OPRC') — a literal type/domain discriminator, identifying the record as belonging to the operation class category.
  • Column 4 (OPRN_CLASS_DESC || '(' || OPRN_CLASS || ')') — the formatted label, combining the human-readable description with the underlying code in parentheses.
  • OPRN_CLASS_DESC — the raw operation class description from FM_OPRN_CLS; this is the column most commonly searched for and referenced by consumers.
  • Five NULL placeholders — reserved slots that maintain a fixed column layout across the EDW view family for union compatibility.
  • LAST_UPDATE_DATE and CREATION_DATE — audit timestamps propagated from FM_OPRN_CLS for incremental extraction and change tracking.

Common Use Cases and Queries

The view is typically used to populate lookup or dimension tables in a reporting layer, to validate operation class codes during conversions, and to drive parameter lists in process manufacturing reports. A representative query follows:

  • Retrieve all operation class descriptions: SELECT oprn_class_desc FROM apps.edw_opi_oprn_oprc_lcv ORDER BY oprn_class_desc;
  • Resolve composite label and instance: SELECT column2, oprn_class_desc, last_update_date FROM apps.edw_opi_oprn_oprc_lcv WHERE column2 LIKE '%-OPM';
  • Incremental extraction: SELECT * FROM apps.edw_opi_oprn_oprc_lcv WHERE last_update_date >= :last_run;

Because the column names in the fixed-width projection are not explicitly aliased in the documented text, consumers should query the view definition or use positional references when exact column labels are required. Filters should generally be pushed against OPRN_CLASS_DESC or the audit dates to keep result sets compact given the cross-join construction.