FBDI is one of the many ways in Oracle Fusion Cloud to do conversions. FBDI stands for File Based Data Import. In cloud environment, FBDI is the best way to get mass conversions done in shortest time. All entities are not provided with FBDI currently in Oracle Cloud. During the Planning phase itself, time and budget calculated based on the availability of FBDI, ADFDI or web services. This is important during the plan and design phase as the write access to Database is restricted for SaaS users (Software as a Service).
Pre-Requisites for FBDI:
1. Machine should have Excel or equivalent software which can execute macros in Excel
2. For Excel, users should make sure the Macros are enabled
3. FBDI for the component should exist in the docs.oracle.com
4. It is better to download the FBDI template which has is of the same version as of the Cloud Environment.
Stages:
1. Downloading the template
2. Preparing data for the template
3. Generating the .zip files
4. Uploading the file to oracle
5. Move data to Interface tables
6. Move data to Base tables
Stage I – Download the Template
Download the template from the Oracle website.
Navigation: docs.oracle.com -> Cloud -> Applications -> Product Management (select your version here from the drop down) -> Books -> File-Based Data Import for Oracle Supply Chain Management Cloud -> Expand All -> Select Item -> Download the template
It is essential to match the version of the SaaS and the version of the FBDI template download to avoid issues.
Downloading the right FBDI template:
Stage II – Preparing the Data
Preparing data for the template
This is the crucial part of the entire process. The only process which differentiates from other conversions. Rest of the process is generic for any FBDI upload. Basic instructions are provided in the first worksheet of every FBDI template.
There are multiple worksheets for Item creation, but this demo is restricted to EGP_SYSTEM_ITEMS_INTERFACE only.
In the EGP_SYSTEM_ITEMS_INTERFACE there are multiple fields that are present. Out of which only few are mandatory, rest can be configured based on the specific requirements.
-
Transaction Type – Create (for creation of Items)
-
Batch ID – Derived from Item Batches
-
Batch Number – Derived from Item Batches
-
Item Number – Name of the Item (In Oracle Cloud Item Name is referred as Item Number)
-
Organization Code – Refers to the name of the Item Master Code ( not the name).
-
Description – Refers to Item Description
-
Template Name – This is the Item Template Name
-
Source System Code – Refers to the Source system from “Manage Trading Community Source Systems”
-
Item Class Name – Refers to Name of the Items to which the items are uploaded
-
Primary Unit of Measure—Refers to Unit of Measure Name (not the code)
-
Lifecycle Phase – Refers to the lifecycle phase of the item
-
Item Status – Refers to the status of the item
-
Deriving Batch ID and Batch Number from Item Batches:
Only users who have the role of “Product Data Steward” can view Item Batches in their Item Workbench Tasks panel.
Navigation -> Home -> Product Management -> Product Information Management -> Tasks Panel
Check for the available batches by click on search(Create one if no item batch is available)
-
Note down the Batch Number and Batch Id from here. If the Batch Id is not visible on the screen, get it from the columns view as shown in above screenshot.
- Manage Source System can be obtained from the FSM setup task “Manage Trading Community Source Systems”
Primary Unit of Measure Name can be obtained from the FSM setup task “Manage Units of Measure”. Refer below screenshot
Manage Lifecycle Phases can be obtained from the FSM setups “Manage Lifecycle Phases”. Production is one of the phases present in the instance by default.
Save the details in the worksheet.
Stage III – Generate .zip File
-
Once all the required data is filled. Click on “Generate CSV File” button present on the first worksheet of the template
-
The macro runs and generates a series of csv files zipped into one file. Name the file with an appropriate name for easy reference.
Stage IV- Upload the files to Oracle Cloud
-
The zip file generated should be uploaded to the UCM File server location
-
Navigation: Home-> Navigator-> File Import and Export
Choose the location of the zip file and provide the correct Account. Here it is scm/item/import
Stage V- Move data to Interface Tables
This stage involves moving the prepared data from UCM server to Interface tables. Oracle cloud performs basic validations on the data and moves the process to success/ error accordingly.
Navigation: Home -> Navigator-> Scheduled Processes -> Schedule New Process -> Load Interface File for Import
It is very important to provide the right Import Process and the Data File.
Stage VI- Move data to Base Tables
The data uploaded now is in interface tables, the data will be moved to Base Table if the validated data meets all the criteria for getting created as an item.
Navigation: Home-> Navigator -> Scheduled Processes-> Item Import
Enter the Batch Id and other parameters as needed.
The process should end in Succeeded status. In case of any errors refer the log file for the failure reason.
Verify the Item Creation by searching for the item manually.
Thank you for watching out this space
About the Author:
Naveen Kumar is an Oracle ERP consultant with an experience of 12 years. He has implemented many ERP projects in High-Tech and Retail industries. He is a Cloud enthusiast and an early-bird in implementing Cloud SCM projects.
Comments
Thanks for the detailed steps.
I am from OIC and for the FBDI import process,the OIC evnts are not triggering to OIC .
Can you please advise any configuration checks need to do in fusion application?
Note:But for from fusion UI,for any item updates : evnts are triggering to IC and requets processing fine.
Thanks,
Uday KIran
udaykirannbgmail.com
There's a lot of folks that I think would
really appreciate your content. Please let me know. Many thanks
I'll go ahead and bookmark your website to come back
later. All the best
uncertainty very shortly it will be well-known, due to its quality contents.
Please keep us up to date like this. Thank you for sharing.
at some of the posts I realized it's new to me. Anyhow, I'm certainly happy I stumbled upon it and I'll be book-marking
it and checking back regularly!
previous to and you are just too fantastic. I actually
like what you've got right here, really like what you are stating and the best way wherein you assert it.
You are making it entertaining and you still
take care of to stay it sensible. I can't wait to learn much more from you.
This is actually a great website.
you could be a great author.I will make sure to bookmark your blog
and will eventually come back in the foreseeable future.
I want to encourage you to definitely continue your great writing, have a nice
morning!
Regards
I will recommend this blog!
same layout and design. Great choice of colors!
that they will help, so here it takes place.
blog posts.
You realize a whole lot its almost hard to argue with you (not that
I actually would want to…HaHa). You certainly put a
brand new spin on a subject which has been discussed
for many years. Excellent stuff, just excellent!
A small number of my blog readers have complained about
my blog not working correctly in Explorer but looks great
in Firefox. Do you have any ideas to help fix this issue?
explorer, may check this? IE still is the marketplace chief and a huge component to people will
miss your magnificent writing due to this problem.
weblog. Is this a paid theme or did you modify it yourself?
Anyway keep up the excellent quality writing, it's rare to see a
nice blog like this one these days.
Google, and found that it is truly informative.
I am gonna watch out for brussels. I'll appreciate if you
continue this in future. Many people will be benefited from your writing.
Cheers!
RSS feed for comments to this post