Search Results bus_grp_fk




Overview
Explore in AI Chat

Overview

ISC_EDW_RECEIVE_PAY_CYCLE_S is an Oracle E-Business Suite supply chain analytics view owned by the APPS schema and delivered as part of the ISC (Supply Chain Intelligence) product family. It is a star-schema-style reporting view that exposes the "receive-to-pay cycle time" measure, the elapsed duration between the receipt of goods and the subsequent payment to a supplier. The view is defined in the ETRM repository with status VALID and is primarily intended for use by Oracle Supply Chain Intelligence and Oracle Business Intelligence (OBIEE) dashboards, where it serves as a presentation-layer source for procurement cycle-time analytics. Because it is a view rather than a table, it materializes no data of its own; it resolves joins across the EDW conformed dimensions and the PO distribution fact at query time.

Underlying Base Objects

The view is defined with an explicit six-way join. The fact-side object is POA_EDW_PO_DIST_F, the purchasing distribution fact table that stores purchase order distribution grain records, including the RECEIVE_TO_PAY_CYCL_TIME measure. The remaining five objects are conformed EDW dimensions: EDW_GEOGRAPHY_M, EDW_ORGANIZATION_M, EDW_ITEMS_M, EDW_TIME_M, and EDW_TRD_PARTNER_M. Join predicates link the fact keys to their dimension primary keys: ITEM_FK_KEY to IREV_ITEM_REVISION_PK_KEY, SHIP_TO_ORG_FK_KEY to ORGA_ORGANIZATION_PK_KEY, SHIP_LOCATION_FK_KEY to GLOC_LOCATION_PK_KEY, SUPPLIER_SITE_FK_KEY to TPLO_TPARTNER_LOC_PK_KEY, and GOODS_RECEIVED_DATE_FK_KEY to CDAY_CAL_DAY_PK_KEY. No underlying base objects are separately documented in ETRM metadata; the join is derived from the embedded view text.

Key Columns

The view projects twelve foreign-key surrogate columns plus one measure. Because the user searched on area_fk, that column is prominent: AREA_FK maps to GEO.ARE1_AREA1_PK_KEY, the geography area surrogate key used for regional slicing.

Common Use Cases and Queries

Typical uses include supplier scorecarding, procurement efficiency analysis, and period-over-period cycle-time trending. Analysts aggregate the measure while grouping by geography, organization, supplier, or time dimension keys, and they join the surrogate keys back to the dimension views for descriptive labels.

  • Average receive-to-pay cycle time by supplier and region.
  • Trend of cycle time by quarter and operating unit.
  • Category-level procurement performance benchmarking using CATG_FK.

Sample query:

SELECT AREA_FK, PERIOD_FK, TRD_PARTNER_FK,
  AVG(RECEIVE_TO_PAY_CYCLE_TIME) AS AVG_CYCLE_TIME
FROM APPS.ISC_EDW_RECEIVE_PAY_CYCLE_S
GROUP BY AREA_FK, PERIOD_FK, TRD_PARTNER_FK;

For descriptive output, join TRD_PARTNER_FK to EDW_TRD_PARTNER_M and AREA_FK to EDW_GEOGRAPHY_M. Filtering on specific FK values (for example, AREA_FK) is efficient provided bind variables are used, since the underlying joins are key-based.