Now that we know about Manually Executing Data Load Rules and Batch Job in Data Management. Let’s now discuss how Data load rules and batch jobs can be scheduled to update the data in NSPB and match it with NetSuite without manually executing the job everytime there is a new data in NetSuite. It is recommended that batch job execution is scheduled on the time that the application is not in use or lesser people is updating the data in NetSuite.
Creating Batch Job
1. Log in to EPM Cloud Planning
2. Go to Navigator and click Data Management
3. Go to Setup tab and click Batch Definition
4. Under Batch Definition Summary, click + Add.
5. Under Batch > Definition, enter Name and select Target Application and Type
Note: In Type, if you select “Batch”, you can only include batches and not data rule. If you select “Data”, you cannot include batches.
6. In Batch Jobs, click + Add and search icon. Pop-up window will appear and select the rule you wanted to add in the batch job.
7. Arrange the sequence of the rules by adding Job Sequence and click Save.
For more information, you may visit Oracle Help Center: Working with Batch Definitions.
Scheduling Batch Job
1. Navigate to Data Management and go to Workflow > Batch Execution
2. Click the batch you wanted to schedule and click Schedule.
3. Choose from Hourly, Daily, Weekly or Monthly if you want to repeat the job execution but for one time execution, select Simple. Select Timezone and specify the date and time.
4. Click OK and pop-up message will display: Scenario has been scheduled successfully.
For more information, visit Oracle Help Center: Scheduling Jobs.
Make sure to follow the New to NetSuite > NSPB category to be notified when new articles are posted.
