Search Results formula_pk_rowid

Overview

The EDW_PMI_PFRM_PFRM_LTC_IV view is an Oracle E-Business Suite database object associated with the Process Manufacturing Intelligence (PMI) product family. PMI is now classified as obsolete within the ETRM 12.2.2 documentation set, meaning Oracle no longer supports or enhances the underlying functionality. The view belongs to the Enterprise Data Warehouse (EDW) layer, whose naming convention reflects its purpose: it exposes process-manufacturing formula master data in a flattened, denormalized form suitable for extraction, reporting, and downstream analytics. The _IV suffix typically denotes an internal or versioned variant of a warehouse integration view.

The view's role is primarily as a read-only reporting access point. Rather than writing queries directly against the transactional PMI formula tables, consumers—such as business intelligence tools, ETL jobs, or custom reports—query the view to obtain consistent column names and derived attributes. Notably, the ETRM metadata states this view is not implemented in this database, so it exists for documentation and lineage purposes and may be present only in installations where PMI was previously enabled.

Underlying Base Objects

The view is defined over a single base object: EDW_PMI_PFRM_PFRM_LTC. The ETRM metadata documents no additional referenced base objects, indicating a straightforward one-to-one projection rather than a join-based view. The base table stores the extract-level formula records, and the _IV view wraps it to expose a canonical column set and to add at least one derived column.

The relationship between the two is largely direct column mapping. All source columns—including ALL_FK, DESCRIPTION, FORMULA_CLASS, FORMULA_DP, FORMULA_NUMBER, FORMULA_PK, FORMULA_PK_KEY, INSTANCE_CODE, NAME, the five USER_ATTRIBUTE columns, and VERSION—are carried through. Two notable transformations occur in the view text: FORMULA_PK_ROWID is aliased as ROW_ID, and USER_ATTRIBUTE5 is aliased as OPERATION_CODE, a common warehouse pattern for repurposing a generic descriptive flexfield column as a semantic indicator.

Key Columns

• FORMULA_NUMBER – The user-facing identifier for a process formula. This is the column referenced in the user's search and is the primary business key used to locate a specific formula.
• FORMULA_PK / FORMULA_PK_KEY – Primary-key surrogate identifiers for the formula record, used for stable joins across warehouse entities.
• NAME – Descriptive name assigned to the formula.
• DESCRIPTION – Free-text description providing additional context.
• FORMULA_CLASS – Classification of the formula, useful for filtering formulas by category.
• FORMULA_DP – Formula discipline or grouping attribute carried from the source.
• VERSION – Version number of the formula record, enabling historical tracking of revisions.
• INSTANCE_CODE – Identifies the source instance, supporting multi-instance or consolidated warehouse deployments.
• ROW_ID – Alias for FORMULA_PK_ROWID, providing the Oracle ROWID of the underlying formula row.
• OPERATION_CODE – Alias for USER_ATTRIBUTE5, typically signifying the operation type (such as insert or update) in warehouse loads.
• USER_ATTRIBUTE1–5 – Descriptive flexfield segments available for organization-specific extensions.
• ALL_FK / ALL_FK_KEY – Foreign-key linkage columns connecting the formula to related warehouse dimensions.

Common Use Cases and Queries

Because the view is not implemented in the documented database, the scenarios below describe typical usage where PMI is present. Analysts use this view to inventory formulas, track version history, and reconcile formula master data across instances. A simple lookup by formula number resembles:

• SELECT FORMULA_NUMBER, NAME, DESCRIPTION, FORMULA_CLASS, VERSION FROM EDW_PMI_PFRM_PFRM_LTC_IV WHERE FORMULA_NUMBER = :formula_number;
• SELECT INSTANCE_CODE, FORMULA_CLASS, COUNT(*) FROM EDW_PMI_PFRM_PFRM_LTC_IV GROUP BY INSTANCE_CODE, FORMULA_CLASS; — inventory and distribution reporting.
• SELECT FORMULA_NUMBER, VERSION, OPERATION_CODE FROM EDW_PMI_PFRM_PFRM_LTC_IV ORDER BY FORMULA_NUMBER, VERSION; — version and change-tracking audits.

Given the obsolete status, organizations should validate availability in their specific environment and plan migration away from PMI-based extract objects where practical.