Search Results std_time

Overview

OPI_EDW_JOB_DETAIL_V is a reporting view that belongs to the Oracle Operations Intelligence (OPI) product family, a data-warehouse-oriented layer built on top of the Oracle E-Business Suite. In ETRM 12.1.1 and 12.2.2 this object is classified under the OPI - Operations Intelligence module and carries a status of Obsolete, meaning it is no longer part of the supported functional footprint of the current release. The view exists to serve as the source of data for several discrete manufacturing analytical reports, specifically Material Efficiency, Late Jobs, Percentage Scrap, Linearity Index, and Production Efficiency. It presents job-level production facts—material input, output, scrap, and time measures—joined against conformed dimension views for inventory, time, product line, and items. Because OPI follows a star-schema design, OPI_EDW_JOB_DETAIL_V is a semantic presentation layer over a fact table (OPI_EDW_JOB_DETAIL_F) that resolves warehouse surrogate keys into meaningful reporting attributes.

Underlying Base Objects

The documented view text shows that OPI_EDW_JOB_DETAIL_V is defined over five objects. The fact source is OPI_EDW_JOB_DETAIL_F, the job-detail fact table. It is joined to four dimension views: EDW_MTL_INVENTORY_LOC_M (inventory location), EDW_TIME_M (time), EDW_OPI_PRDL_M (product line), and EDW_ITEMS_M (items). The joins are equi-joins on foreign-key surrogate keys: LOCATOR_FK_KEY to INVL_LOCATOR_PK_KEY, TRX_DATE_FK_KEY to CDAY_CAL_DAY_PK_KEY, PRD_LINE_FK_KEY to PRDL_PRDL_PK_KEY, and ITEM_FK_KEY to IREV_ITEM_REVISION_PK_KEY. The ETRM metadata does not document separate base tables, and the view itself reports as not implemented in the reference database and having no documented referenced base objects, so the fact and dimension views above are the authoritative lineage. This structure is typical of OPI EDW objects, where conformed "_M" dimension views expose "_PK_KEY" primary keys consumed by fact-level "_V" views.

Key Columns

The view exposes warehouse surrogate keys alongside descriptive measures. Dimension keys include ALL_INV_ID, PCMP_ID, PORG_ID, OPERATING_UNIT_ID, PLANT_ID, ALL_TIME_ID, CAL_YR_ID, CAL_QTR_ID, CAL_PERIOD_ID, ALL_PRDL_ID, PRDL_ID, ALL_ITEMS_ID, ITEM_CAT_ID, and ITEM_ID, allowing reports to aggregate by organization, calendar, product line, and item category or revision. The quantitative measures are the core of the view: ACT_MTL_INP_VAL_G and PLN_MTL_INP_VAL_G (actual and planned material input value), ACT_OUT_VAL_G and PLN_OUT_VAL_G (actual and planned output value), ACT_SCR_VAL_G and PLN_SCR_VAL_G (actual and planned scrap value), ACT_OUT_QTY (actual output quantity), ACT_JOB_TIME (actual job time), and the columns most relevant to the user's search, STD_QTY and STD_TIME, which supply the standard quantity and standard time baselines. A derived flag, LATE_JOB, evaluates to 1 when ACT_CMPL_DATE exceeds PLN_CMPL_DATE and 0 otherwise, and a constant JOB column is included for counting job records. STD_QTY and STD_TIME are the denominators that drive efficiency ratios such as material efficiency and production efficiency.

Common Use Cases and Queries

Because the view underpins the five named OPI reports, typical usage compares actual results against standard and planned baselines. A material-efficiency query would divide ACT_OUT_QTY by STD_QTY to measure yield per job. A linearity or production-efficiency query would compare ACT_JOB_TIME to STD_TIME, while scrap analysis would use the ACT_SCR_VAL_G and PLN_SCR_VAL_G pair. Late-job reporting uses the pre-computed LATE_JOB flag, optionally grouped by PLANT_ID or PRDL_ID.

• Efficiency by product line: SELECT PRDL_ID, SUM(ACT_OUT_QTY)/SUM(STD_QTY) EFFICIENCY FROM OPI_EDW_JOB_DETAIL_V GROUP BY PRDL_ID;
• Standard versus actual time variance: SELECT ITEM_ID, ACT_JOB_TIME, STD_TIME FROM OPI_EDW_JOB_DETAIL_V WHERE STD_TIME > 0;
• Late job count by plant: SELECT PLANT_ID, SUM(LATE_JOB) LATE_JOBS FROM OPI_EDW_JOB_DETAIL_V GROUP BY PLANT_ID;

Given the Obsolete designation, these patterns are maintained for reference or migration rather than new development on supported releases.