Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion Blog
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

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.


 


Naveen Kumar

Comments   

+1 #1 Uday Kiran Reddy Nat 2021-11-23 13:06
Hi Naveen,

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
Quote
+1 #2 onlinecasinoers.com 2022-08-29 18:02
Hey! Would you mind if I share your blog with my myspace group?
There's a lot of folks that I think would
really appreciate your content. Please let me know. Many thanks
Quote
0 #3 onlineslotsart.com 2022-08-30 04:24
I’m not that much of a online reader to be honest but your sites really nice, keep it up!
I'll go ahead and bookmark your website to come back
later. All the best
Quote
0 #4 Lon 2022-09-01 07:33
Because the admin of this website is working, no
uncertainty very shortly it will be well-known, due to its quality contents.
Quote
0 #5 casinos français 2022-09-01 08:01
It's actually a nice and useful piece of info. I'm happy that you shared this helpful information with us.
Please keep us up to date like this. Thank you for sharing.
Quote
0 #6 casino online 2022-09-01 08:44
Hello! I could have sworn I've been to this web site before but after looking
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!
Quote
0 #7 Kristeen 2022-09-01 09:49
If you desire to obtain a great deal from this post then you have to apply such strategies to your won web site.
Quote
0 #8 casinosenligne.pro 2022-09-01 12:24
Great items from you, man. I have bear in mind your stuff
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.
Quote
0 #9 uscasinohub.com 2022-09-12 06:52
Thanks on your marvelous posting! I definitely enjoyed reading it,
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!
Quote
0 #10 onlineslotsart.com 2022-09-12 12:17
Thanks for sharing your thoughts about Oracle Training.
Regards
Quote
0 #11 best bitcoin casinos 2022-09-12 16:26
You ought to be a part of a contest for one of the most useful websites on the net.
I will recommend this blog!
Quote
0 #12 best bitcoin casinos 2022-09-13 02:23
Very good article. I am experiencing many of these issues as well..
Quote
0 #13 Minerva 2022-09-13 05:40
Whoa! This blog looks just like my old one! It's on a completely different topic but it has pretty much the
same layout and design. Great choice of colors!
Quote
0 #14 Adrienne 2022-09-14 04:53
In fact no matter if someone doesn't be aware of afterward its up to other people
that they will help, so here it takes place.
Quote
0 #15 gambling games 2022-09-16 17:40
I used to be able to find good info from your
blog posts.
Quote
0 #16 win real money slots 2022-09-17 05:06
Great post.
Quote
0 #17 Warner 2022-09-17 10:58
Right here is the right site for anyone who hopes to understand this topic.
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!
Quote
0 #18 Eduardo 2022-09-19 03:17
I am really enjoying the theme/design of your weblog. Do you ever run into any browser compatibility issues?
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?
Quote
+1 #19 maxcasinous.com 2022-09-19 18:25
Hi, Neat post. There is a problem together with your web site in web
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.
Quote
+1 #20 new online casinos 2022-09-20 16:07
I am extremely impressed with your writing skills and also with the layout on your
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.
Quote
+1 #21 uscasinohub.com 2022-09-21 22:17
Hello there, just became alert to your blog through
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!
Quote

Add comment


Security code
Refresh

About the Author

Naveen Kumar

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner