Search Results year_fk




Overview
Explore in AI Chat

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:

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:

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.