top of page
Image by Anton Sobotyak

Faster Refreshes, Cleaner Data, Lower Costs - Get Your Pipeline Parameters Right

Oct 30
4 min read

Updated: 5 days ago

At a glance - Pipeline parameters are shared settings. They decide how and when Oracle Fusion Data Intelligence fills your data warehouse. They cover the refresh timetable, language, currency, exchange rate type, fiscal calendar and the start of your history. Set them before you run any functional area pipeline. 

🔧︎ Where Functional Area Pipelines Fit


A functional area pipeline loads data for one business area into the warehouse. General Ledger under Finance and Sales under NetSuite are good examples. Each pipeline has its own settings.

Pipeline parameters sit one level higher. Every functional area inherits them. A careful setup here pays off across all your pipelines.



🔄︎ Pipeline States and Allowed Actions


A pipeline’s state decides what you can do with it.

Pipeline state 

Operations allowed 

Details 

Saved 

Edit, Delete 

Activate through the Edit wizard or delete it. 

InActive 

Edit, Activate, Delete 

Activate through the Edit wizard or delete it. 

Activation Scheduled 

Edit, Delete 

Editing cancels the earlier schedule and creates a new one. 

Activation in Progress 

View 

Read-only until activation ends. 

Activation Complete 

Edit, Delete, Reset, Deactivate, Refresh Data 

The fully live state.  


Once activation is complete - 


  • Edit: Limited to Attribute Selection, Column Options, Entity Options, Dimension Keys, Schedule and Save. After editing, the pipeline is ready for Refresh Data or an AdHoc run. View the information icon that's displayed.


  • Reset: Flags the pipeline for a data reset, with an information icon. The next incremental job performs it. Refresh Data does it immediately.


  • Refresh Data: Starts an AdHoc run right away if no incremental job is running. It becomes a full refresh if you edited or reset the pipeline earlier.


  • Deactivate: Moves the pipeline back to InActive.


⏲  Pipeline Parameters:


All functional areas share four key parameters: Currency, Exchange Rate Type, Initial Extraction Date, and Incremental Job Start Time, grouped into four categories.


  • Data Refresh Schedule: How often and when the incremental load runs.


  • Data Maintenance Schedule: When the full reload runs. It stays apart from the incremental refresh.


  • Global Parameters: Analytics language, Analytics currency, Exchange Rate Type and Enterprise Calendar. They apply across all your Oracle Fusion Data Intelligence offerings.


  • Initial Extract Date: How far back the first full load reaches.


📝︎  Steps for setting up pipeline parameters


Set these up for your data model file before running any functional area pipeline.


Two things to know first:


  • Updates can take over your refresh - Application updates appear on the Release Updates tile in the Console. Some upgrade the data model. If an upgrade is pending at your refresh time, it runs instead of that day’s refresh. It takes longer, so data may arrive late.


  • Clock changes can skip a run - When clocks move forward an hour, schedules in the skipped hour do not run. For example - In the U.S., the clock jumps from 2 am to 3 am on the second Saturday of March. A refresh set in that window will not run that day. Schedule before 2 am or after 3 am to be safe.


  1. Log in to FDI Console.

  2. Open the Console. Select Data Configuration under Application Administration.

  3. On the Data Configuration page, select Pipeline Settings under Configurations.

  4. Under Data Refresh Schedule, pick the frequency from the Interval list. Then set the time, day and month for the incremental load.

🛈 Pro tip: Use city-based time zones Choose a city zone such as Europe/Bucharest or America/Los_Angeles, not EST or PST. The refresh then uses local clock time, so daylight saving changes do not shift it. 
  1. Under Data Maintenance Schedule, schedule full data loads on their own. This keeps them from disturbing the incremental refresh.

  2. Enter these details under Global Parameters:

Parameter 

Purpose 

Analytics Language 

Sets the language of the extracted data. Choose one. 

Analytics Currency 

Sets the common currency for storing amounts. 

Use Fusion Default Exchange Rate Type 

Whether to adopt the default exchange rate type from Oracle Fusion Cloud Applications. 

Exchange Rate Type 

The rate type used to convert amounts to the analytics currency, such as Corporate for a stable currency. 

Enterprise Calendar 

The fiscal calendar for reporting. All time options in the reporting layer come from it. 


⚠︎  Handle with care - 

The system displays the "Effective Date”. The effective date indicates how far back the data is available in the warehouse. The warehouse may have data beyond the relative period. In the next application update, the system deletes this older data. 


  1. The initial extract date applies to full loads. Choose Absolute or Relative as the Date Type:


  • Absolute: Enter the date to load transactions from. Only later transactions reach the warehouse, so the first load stays small. But history keeps growing over time.

  • Relative: Enter a number and choose Days, Weeks, Months or Years. The window moves daily.


🖈Golden rule - 

After extraction, avoid changing the initial extract date. If you must, change it, reset the data warehouse and reactivate the functional areas. 

  1. Click Save. The pipelines are ready to run on your schedule.



➤ Key Things to Remember - 


  • Set once, apply everywhere: Every functional area shares these settings.

  • Schedule with care: Use city-based time zones, keep full loads apart from incremental ones, and avoid the skipped daylight saving hour.

  • Language changes need a reset: Reset the warehouse after switching language.

  • Prefer relative extract dates: They control size, speed and cost.

  • Leave the initial extract date alone: If it must change, reset and reactivate.


Ready to Get Your Pipeline Parameters Right?

Whether you’re scheduling your first incremental refresh, choosing the right analytics currency and exchange rate type, or setting a relative extract date to keep your warehouse lean, getting pipeline parameters right is what keeps your analytics accurate, timely and cost-efficient without storing data you don’t need.


These settings apply to every functional area, so a small mistake early on can follow you into every pipeline you run. CLODAIN’s Quick Start Configuration gets Oracle Fusion Data Intelligence deployed, connected and validated in an 8-week engagement, with your refresh schedule, currency, calendar and extract dates set up correctly from day one.


→ See where you stand: Take the free Oracle FDI Readiness Assessment.


→ Or talk it through: Book a free introductory call to map out your pipeline configuration strategy on Oracle Fusion Data Intelligence!




 
 

Recent Posts

See All

Reach out to us to explore how our AI-driven data solutions can drive your business forward.

Let's start the conversation.

© 2026 Clodain. All rights reserved. | Privacy Policy

Connect with Us:

  • Email Clodain
  • Clodain on LinkedIn
bottom of page