Updating the Data Load Periods for Pipeline_Data_Load
In Data Integration, update the load periods (start and end) for the Pipeline_Data_Load pipeline. This pipeline jobs loads transaction data from NetSuite into Planing and Budgeting Financials as a part of a scheduled data load process.
You need to update the Load periods one time annually at the start of the financial year.
To update the load periods for Pipeline_Data_Load:
-
On your Planning and Budgeting Home page, click the Application card, then click Data Exchange.
-
On the Data Integration page, in the search bar, enter Pipeline_Data_Load.
-
Click Pipeline_Data_Load.
-
Click the Edit Pipeline icon
.
-
Click the Variables tab.
-
For the Start Period variable, in Default Value, enter the previous month. The start period should match the period in the NSP_PER_ActCurrMo substitution variable.
-
Click Save.
After you update the parameters for the load periods, make sure you update the substitution variables.
For example, update NSP_PER_PriorYr to FY24 and NSP_PER_ActCurrYr to FY25.
For more information about substitution variable values, see Setting Up Values for Substitution and User Variables.