Running the Pipeline for ERP Metadata Load and Data Extraction

Run one of the provided pipelines for ERP metadata load and data extraction.

Metadata from Fusion ERP data sources is seamlessly integrated to Oracle Fusion Cloud Enterprise Performance Management, with the exception of input currencies.

You can use any of these pipelines:

• PCF Pipeline—Loads and runs all the processes for both daily and periodic cash forecasting.
• PCF Pipeline Daily—Loads and runs the processes for daily cash forecasting.
• PCF Pipeline Periodic—Loads and runs the processes for periodic cash forecasting.

The PCF Pipeline master process initiates these sub processes to extract data from ERP:

• Refresh Members
• Load Hierarchies
• Refresh Database
• Stage Data
• Load Data
• Daily Currency Translation to Entity Currency
• Periodic Currency Translation to Entity Currency
• Extract and Aggregate Data for Predictive Cash Forecast
  • Upload Interface Error and Job Output File to Universal Content Management
  • Daily Process Forecast/Periodic Process Forecast

Review the pipeline schedules, and schedule the PCF Pipeline process at an interval to match the periodic time granularity at which forecasting is performed (daily or weekly or monthly).