Search Results result_date




Overview
Explore in AI Chat

Overview

PMI_EDW_BTCH_QC_F_IV is an interface (reporting) view belonging to the Process Manufacturing Intelligence (PMI) product family within Oracle E-Business Suite. PMI was Oracle's earlier generation of process manufacturing analytics, subsequently superseded by the Process Manufacturing modules and Oracle Business Intelligence Applications. The view name follows the standard EBS naming convention: the PMI_EDW prefix denotes the Process Manufacturing Intelligence Enterprise Data Warehouse layer, BTCH_QC identifies batch quality control subject matter, the _F suffix indicates a fact-style structure, and the _IV suffix denotes an interface view. In ETRM the object carries an "Obsolete" designation, meaning it is retained for documentation and backward-compatibility reference rather than active delivery.

The view presents batch quality control results at the sample level, combining batch, routing, operation, and sample attributes with user-defined flexfield columns. Its purpose in the EBS reporting stack is to flatten the underlying batch QC fact into a form suitable for extraction, transformation, and load into the PMI data warehouse or an external analytical repository.

Underlying Base Objects

The view is defined over a single documented base object, PMI_EDW_BTCH_QC_F, which supplies all one hundred plus columns projected by the interface view. ETRM documentation records no additional referenced base tables, so the view functions as a projection and light transformation layer rather than a join. The transformation is limited to three expressions: the Oracle pseudo-column ROWID is aliased as ROW_ID, and USER_ATTRIBUTE15 is additionally exposed under the alias OPERATION_CODE. Every remaining column is passed through unchanged.

The associated metadata notes that the view is "Not implemented in this database," confirming that in the documented 12.2.2 environment the object does not physically exist. Referencing it without first validating deployment will therefore raise an ORA-00942 error. In 12.1.1 environments the same caveat applies, since the PMI product line predates and sits outside the core process manufacturing schema delivered with those releases.

Key Columns

The columns most relevant to batch QC analysis are:

Common Use Cases and Queries

The principal use case is extracting batch QC results for a given sample. A targeted lookup by sample number follows the pattern:

  • SELECT batch_no, sample_no, sample_desc, operation_no, result, assay_uom, result_date, accept FROM pmi_edw_btch_qc_f_iv WHERE sample_no = :sample_no;

Warehouse-oriented queries aggregate by dimension key, for example joining ITEM_FK_KEY and TIME_FK_KEY to conformed dimensions to trend assay results over time. Batch-level reporting filters on BATCH_NO and ROUTINGSTEP_NO to reconstruct the QC history of a production batch. Because the view is obsolete and not implemented, any practical implementation must first confirm the object exists in the target schema and, where it does not, reproduce the projection directly against PMI_EDW_BTCH_QC_F with the same ROW_ID and OPERATION_CODE aliases.