How to Automate Data Import Process in Oracle fusion.

How to Automate Data Import Process in Oracle fusion.

 

In this post , We will discuss how we can Automate Data Import Process in Oracle fusion. In fusion , We have 'Load interface Files for Import' Schedules process by which we import data from Data Templates to Oracle Fusion. But in this program , we also need to select the Data file name which we have uploaded in Oracle fusion and this is the constraint because when we are doing automate then how can we put the file name manually in this program parameter.

 

So I am going to discuss here , how we can automate our data import in fusion.

 

suppose , you want to do integration of Oracle fusion ,with any third party tool , which creates your supplier information and this third party tool puts new supplier information file in oracle fusion FTP. Now , you want to automate the data import from this file to oracle fusion. but if you will run 'Load interface Files for Import'  then also you need to put the file name manually in this process. but if you are scheduling this program so that your data will be automatic move to oracle fusion then how can you select the file name every time in your scheduled program.

 

For this , Oracle fusion has provided another scheduled process 'Load Multiple Interface Files for Import' in which you don't need to put select the file in this process.

 

Here you can see below , I have selected Import process 'Import Suppliers' and File Prefix 'PozSuppliersInt' then after that click on Advanced button above to schedule this process.

 

Schedule this program as below and now your Data Import process has been automate :)

 

 

 

How to Automate Data Import Process in Oracle fusion.