Search Results qc_test

Overview

OPI_EDW_OPM_JOB_DETAIL_FCV is a public view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as OPI.OPI_EDW_OPM_JOB_DETAIL_FCV with a status of VALID. It is the fact source view of Job Details for Oracle Process Manufacturing (OPM) extraction, engineered to feed the Enterprise Data Warehouse (EDW) / Daily Business Intelligence reporting layer. The view flattens OPM batch (job) transaction and valuation data into a dimensional "fact" layout: business measures are paired with a set of surrogate foreign keys that resolve to the surrounding EDW dimensions (inventory location, item, production line, time, currency, unit of measure, and instance). Because it is exposed in the APPS schema, it may be queried directly for custom reporting or other data requirements without altering the underlying OPM application logic. Its naming convention — the OPI prefix and the FCV suffix — signals its identity as an OPM-specific, fact-oriented EDW view, distinct from the base transactional tables in the OPM and Oracle Manufacturing schemas that it aggregates.

Underlying Base Objects

The supplied ETRM metadata documents no referenced base objects for this view, so its dependency list cannot be confirmed from that source alone. In practice, a fact source view such as this derives its columns from OPM job, transaction, and valuation tables. The foreign key columns described in the view metadata — LOCATOR_FK, ITEM_FK, PRD_LINE_FK, TRX_DATE_FK, SOB_CURRENCY_FK, BASE_UOM_FK, and INSTANCE_FK — correspond to EDW dimension tables maintained for OPM, while the measure columns represent aggregations over job input, by-product, and material valuation data. Administrators can resolve the concrete dependency tree in a specific environment by querying ALL_DEPENDENCIES or the Dictionary view for OPI_EDW_OPM_JOB_DETAIL_FCV, which will enumerate the base objects the view is compiled against in that instance.

Key Columns

• JOB_DETAIL_PK (VARCHAR2 121): primary key following the PRODTAG structure for OPI.
• LOCATOR_FK (VARCHAR2 44): foreign key to the inventory location dimension at the OPM inventory organization group level.
• ITEM_FK (VARCHAR2 4000): foreign key to the item dimension at item-organization level.
• PRD_LINE_FK (CHAR): foreign key to the production line dimension.
• TRX_DATE_FK (VARCHAR2 120): foreign key to the time dimension at calendar day level.
• SOB_CURRENCY_FK and BASE_UOM_FK: foreign keys to the set-of-books currency and unit of measure dimensions respectively.
• INSTANCE_FK (VARCHAR2 30): foreign key to the instance dimension; USER_FK1 through USER_FK5 are reserved user-defined dimension keys.
• ACT_BPR_VAL_B / ACT_BPR_VAL_G: actual by-product value from a job in functional and warehouse currency.
• ACT_INP_VAL_B / ACT_INP_VAL_G: actual input (ingredient and component) value in functional and warehouse currency.
• ACT_MTL_INP_VAL_B: actual material input value from the job.
• ACT_JOB_TIME, ACT_CMPL_DATE, ACT_CNCL_DATE: elapsed batch time (start to end, subject to the shop calendar), actual completed date, and actual cancelled date.

Common Use Cases and Queries

The view supports OPM batch cost, yield, and by-product reporting, particularly in the context of quality or process analysis (relevant to "qc_test" searches) where users trace job detail measures for a given item or production line. Typical queries join the fact columns to the dimension tables and aggregate the valuation measures.

SELECT jd.TRX_DATE_FK,
       jd.ITEM_FK,
       SUM(jd.ACT_INP_VAL_B)     AS total_input_value,
       SUM(jd.ACT_BPR_VAL_B)     AS total_byproduct_value,
       SUM(jd.ACT_MTL_INP_VAL_B) AS total_material_input
FROM   APPS.OPI_EDW_OPM_JOB_DETAIL_FCV jd
WHERE  jd.PRD_LINE_FK = :prod_line
GROUP  BY jd.TRX_DATE_FK, jd.ITEM_FK;

For batch cycle-time analysis, ACT_JOB_TIME is aggregated by combining the time and production line dimensions. The currency measures allow both functional (B) and warehouse (G) comparisons within a single query, while the user-defined keys accommodate organization-specific reporting extensions.