Fusion Financials Data Migration
Jun 2020
Madhavi Godbole
Approach to Fusion Financials Data Migration:
Data Migration in a Fusion Environment can be done by way of two approaches:
- File Based Data Import
- Automate Data Migration using Web Services.
This document is prepared to provide a high-level view on the above two approaches which can be used to migrate transactional and master data to Cloud Fusion Financials.
Approach 1: File Based Data Import
Oracle File Based Data Import (FBDI) is used when there is a need for high volume data uploads to Oracle ERP Cloud Service. It can used for both legacy data migration as well as daily or regular import of data.
Steps to Load Data into Interface Tables
Perform the following steps to load data to the interface tables:
- Download the relevant file-based data import template.
- Enter data in the template as per instructions entailed.
- Click the Generate CSV File button on the Instructions and CSV Generation worksheet in the template to create the CSV files in a zip file format.
- Save the zip file locally.
- Navigate to the Scheduled Processes page and select your import process and the locally saved data file and then submit the Load Interface File for Import process to upload your data from the CSV files to the interface tables.
Here is an example of Journal Upload on a Fusion Cloud Instance.
Step 1:
Download the FBDI Journal Import template from fusionappsoer (Oracle Enterprise Repository ) site by choosing the correct release of the fusion instance.
Image Captured from Google
Step 2:
Download the template as shown below:
Image captured from Google
The downloaded template has the following worksheet:
Image captured from Google
Image captured from Google
Step 3:
Generate CSV file after filling up the Journal data as per the Template.
Step 4:
Upload the zip file created in the previous step and Run the Load Interface file for Import, which load the GL_INTERFACE table in the Fusion Instance.
Step 5:
Finally, Submit the Scheduled process “Import Journals” to load the Journal in Fusion
Application.
Approach 2: Automate Data Migration using Web Services
You can automate the entire inbound data flow using web services as an alternative to the manual approach of FBDI.
In this approach, the source system will be connected to collect the data (e.g. Customer, Supplier, Trial Balance, AR Invoice etc.) and transformed thru the Business specific logic at the Fusion Middleware level.
The Web Services can be called from a wrapper program executed in the Fusion middleware to the load the data into Fusion Application.
Nice blog article
Your article helped me a lot, is there any more related content? Thanks!
Your article helped me a lot, is there any more related content? Thanks!
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Your articles are extremely helpful to me. Please provide more information!
I really appreciate your help
Thank you for your post. I really enjoyed reading it, especially because it addressed my issue. It helped me a lot and I hope it will also help others.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me. https://accounts.binance.com/en-NG/register-person?ref=JHQQKNKN
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Your article helped me a lot, is there any more related content? Thanks!
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Your article helped me a lot, is there any more related content? Thanks!
Trusted by Iraq’s top industries, BWER Company provides innovative weighbridge systems, enabling seamless load monitoring and weight compliance for transport, construction, and agriculture sectors.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you. https://www.binance.com/en-IN/register?ref=UM6SMJM3
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article. https://www.binance.com/bn/register?ref=UM6SMJM3
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Viagra for men buy cialis online europe Canadian health and care mall
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.