Search Results pull_fact_data

Overview

MSD_PULL_FACT_DATA is an APPS-owned PL/SQL package that belongs to the Oracle E-Business Suite data-collection layer used by supply chain and demand planning products. Its central responsibility is to extract or "pull" fact data from EBS operational tables into staging (MSD_ST_*) tables that downstream planning engines can consume. In the context of ETRM 12.1.1 and 12.2.2, the package acts as a marshalling point for transactional facts — shipments, bookings, forecasts, pricing, unit-of-measure and currency conversions, and events — assembling them into a consistent form prior to collection by the planning schema. The package header carries a header revision string dated 2005, indicating the interface has been stable across releases; it remains a documented, non-API ("OTHER" classification) object. Each public procedure is designed to be invoked as a standalone concurrent request or from a wrapper program, driving one category of fact pull at a time and returning standard concurrent-manager OUT parameters (errbuf, retcode) for status reporting.

Key Procedures and Functions

• PULL_FACT_DATA — The umbrella entry point that orchestrates the overall fact-data pull, coordinating the individual extract routines below.
• PULL_SHIPMENT_DATA — Extracts shipment facts from EBS into the shipment staging area for downstream planning and analytics.
• PULL_BOOKING_DATA — Extracts booking (order/booking) facts into the booking staging table.
• PULL_UOM_CONVERSION — Populates unit-of-measure conversion factors so quantities can be normalized across planning units.
• PULL_CURRENCY_CONVERSION — Populates currency conversion rates so monetary facts can be normalized across currencies.
• PULL_MFG_FORECAST — Extracts manufacturing forecast data, mapping it into the manufacturing forecast staging table; this is the specific procedure users reach when searching for "pull_mfg_forecast".
• PULL_PRICING_DATA — Extracts pricing/list information into the price-list staging table.
• PULL_EVENTS — Extracts event data, capturing dated occurrences relevant to planning time-series.
• PULL_OPPORTUNITIES_DATA — Documented in 12.2.2 metadata (commented out in the older source excerpt), extracting opportunity facts; typically invoked with a company-refresh parameter.
• PULL_SALES_FORECAST — Documented in 12.2.2 metadata (commented out in the older source excerpt), extracting sales forecast facts.

No parameter lists beyond the shared concurrent-manager pair (errbuf, retcode) are documented; parameter signatures should not be assumed beyond what the source shows.

Tables Accessed

• MSD_ST_SHIPMENT_DATA — target/source staging table for shipment facts.
• MSD_ST_BOOKING_DATA — staging table for booking facts.
• MSD_ST_MFG_FORECAST — staging table for manufacturing forecast facts.
• MSD_ST_PRICE_LIST — staging table for pricing data.
• MSD_ST_UOM_CONVERSIONS — staging table for UOM conversion factors.
• MSD_ST_CURRENCY_CONVERSIONS — staging table for currency conversion rates.
• MSD_ST_TIME — time dimension staging used to anchor fact records to planning buckets.
• DUAL — used for trivial scalar/validation queries.

These are accessed via APPS synonyms; the package reads current EBS facts and writes them into the MSD_ST_* staging tables for collection.

Usage Notes

MSD_PULL_FACT_DATA is typically invoked through the concurrent manager, either as individual fact-pull programs (for example, manufacturing forecast) or via wrapper programs that call PULL_FACT_DATA to perform a coordinated refresh. It is referenced by one other package, confirming it is called programmatically rather than only scheduled directly. Because it is classified as OTHER and not a supported API, custom code should not depend on its internal behavior across patches; use the documented procedures as entry points and rely on the standard concurrent-manager OUT parameters for error handling.