Results for “edw_time_m”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view ISC_EDW_ORD_RECV_PAY_CYCLE_S belongs to the Oracle Supply Chain Intelligence (ISC) product family, a Business Intelligence or "Daily Business Intelligence" style reporting layer that was delivered with Oracle E-Business Suite releases and is classified in the ETRM metadata as Obsolete. Its documented purpose is to serve the Procure to Pay Cycle Time reports, providing pre-aggregated cycle-time measurements that span the procurement chain from purchase order creation, through goods receipt, to supplier payment.

The suffix _S in the object name typically indicates a "summary" or star-schema style materialized view design used in the ISC/EDW (Enterprise Data Warehouse) arena objects. Each row represents a measured cycle time segmented by conformed dimensions such as geography, organization, item category, trade partner, and time. The view is designed for analytical querying rather than transactional processing, and is populated from the ISC EDW star schemas rather than from live transactional tables.

Because the metadata states "Not implemented in this database," the object is not present in the current instance, either because the ISC module was never installed, was decommissioned, or the report layer was superseded. The year_fk column, which the user searched for, is a conformed foreign key to the time dimension and is one of the principal slicing attributes for annual cycle-time analysis.

Underlying Base Objects

The view text reveals that it is defined over a small set of EDW star-schema objects rather than operational tables. The documented base objects are:

• POA_EDW_PO_DIST_F — the purchase order distribution fact table, supplying the three cycle-time measures and the foreign keys to item, organization, geography, trade partner, and the two calendar date roles.
• EDW_GEOGRAPHY_M — the geography dimension, joined via the ship-to location key.
• EDW_ORGANIZATION_M — the organization dimension, joined via the ship-to organization key.
• EDW_ITEMS_M — the items dimension, joined via ITEM_FK_KEY to IREV_ITEM_REVISION_PK_KEY.
• EDW_TIME_M — the time dimension, used twice: once as TIME (PO approval date) and once as CTIME (goods received date).
• EDW_TRD_PARTNER_M — the trade partner dimension, joined via SUPPLIER_SITE_FK_KEY to TPLO_TPARTNER_LOC_PK_KEY.

The joins are equi-joins on surrogate keys, confirming a conventional star-schema retrieval pattern. No transactional tables (PO_HEADERS_ALL, RCV_SHIPMENT_HEADERS, AP_INVOICES_ALL) are referenced directly; the view depends entirely on the EDW layer.

Key Columns

The view exposes fifteen columns. The first twelve are foreign keys to conformed dimensions, and the final three are the cycle-time facts:

• AREA_FK, COUNTRY_FK, REGION_FK — geography hierarchy keys from EDW_GEOGRAPHY_M.
• BUS_GRP_FK, INT_ORGA_FK, LEGAL_ENT_FK, OPER_UNIT_FK — organization hierarchy keys from EDW_ORGANIZATION_M.
• CATG_FK — item category key from EDW_ITEMS_M.
• TRD_PARTNER_FK — supplier/trade partner location key from EDW_TRD_PARTNER_M.
• PERIOD_FK, QTR_FK, YEAR_FK — time dimension keys mapped from the calendar period, quarter, and year of the purchase order approval date. YEAR_FK is the conformed key to the EDW calendar year and is the natural filter for annual trend analysis.
• ORDER_TO_PAY_CYCLE_TIME — elapsed time from PO approval to payment.
• ORDER_TO_RECEIVE_CYCLE_TIME — computed as CTIME.CDAY_CALENDAR_DATE - TIME.CDAY_CALENDAR_DATE.
• RECEIVE_TO_PAY_CYCLE_TIME — elapsed time from goods receipt to payment.

Common Use Cases and Queries

Typical usage centers on trend, outlier, and supplier scorecard analyses. A representative query that isolates annual performance by operating unit is:

• SELECT year_fk, oper_unit_fk, TRD_PARTNER_FK, AVG(ORDER_TO_PAY_CYCLE_TIME) avg_otp, AVG(RECEIVE_TO_PAY_CYCLE_TIME) avg_rtp FROM ISC_EDW_ORD_RECV_PAY_CYCLE_TIME_S GROUP BY year_fk, oper_unit_fk, TRD_PARTNER_FK;

Other analytics include comparing ORDER_TO_RECEIVE_CYCLE_TIME against RECEIVE_TO_PAY_CYCLE_TIME to identify whether delays originate in receiving or in accounts payable, and joining YEAR_FK, QTR_FK, and PERIOD_FK back to EDW_TIME_M to produce human-readable period labels. Because the object is obsolete and not implemented, these patterns should be regarded as historical reference; on current 12.1.1 or 12.2.2 instances, equivalent metrics are usually obtained from the corresponding OBIEE or DBI subject areas rather than by querying this view directly.