OIC - EPM - Data Load process in Data Management

 We can automate data management process, to run data load rule which is running successfully in data management. We can get doubt as we can schedule it in data management itself why we need OIC ??

Yes, you are correct we can schedule the data load rule to run on particular time using scheduling options in data management. But we can do more than that in OIC - Oracle Integration Cloud.

For example, If you want to run data load using just by changing Substitutional variables(start_Period, end_Period, import_mode, export_Mode), you can do that using OIC. If you are good at Groovy script, you can write a business rule also, to run Data Load rule by using EPM Automate commands.

OIC - to run data load rule by using substitutional variables:

1. Login OIC, Go to Connections, create REST API connection to connect to Oracle EPM Planning URL.
2. Go to Integrations and Click on Create to select Scheduled Orchestration. 
3. Select RestAPI, to pull Substitutional Variables into OIC using Get option.
   https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/planning_get_a_subst_variable_for_app_2.html
4. Select RestAPI, once again to run Data Load Rule.
   https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/cepma/epm_auto_run_data_rule.html
   Or
   https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/fdmee_integration_jobtype_106x0fea7396.html
5. You can add Wait Time, Notifications to send emails, While loops to send an repeat the tasks until completed also.
6. Once you are done with setup, you can activate and submit now to run the Integration.
7. You can check the status of integration in Monitoring -- Tracking tab

Thanks,

Mady