Oracle Fusion SCM FBDI Templates

Share

Oracle Fusion SCM FBDI Templates

Oracle Fusion Supply Chain Management (SCM) includes features to help businesses manage their supply chain processes. One of these features is File-Based Data Import (FBDI), which is a bulk data import tool that allows users to import high volumes of data from external systems into Oracle Fusion Applications.

FBDI templates are essentially spreadsheets designed to gather data in a specific format that can be used by the FBDI tool. The templates correspond to various entities in Oracle Fusion SCM, such as items, suppliers, purchase orders, etc.

The specific steps to use these templates are as follows:

  1. Download the FBDI Template: From the Oracle Application homepage, navigate to ‘Scheduled Processes’ under ‘Tools’. Here, search for a process with the name ‘Load Interface File for Import’ and download the zip file for the relevant entity (e.g., ‘Item Import’).

  2. Prepare the Data: Open the downloaded spreadsheet and populate it with the data to be imported. Each sheet in the spreadsheet corresponds to a different table in the Oracle Fusion database.

  3. Generate CSV File: After populating the data, go to the ‘Instructions’ sheet within the template and click ‘Generate CSV’. This will create a CSV file of your data, which can be uploaded to the Oracle Fusion application.

  4. Upload the CSV File: Back on the Oracle Application homepage, navigate to ‘File Import and Export’ under ‘Tools’. Here, upload the generated CSV file.

  5. Run the Import Process: Finally, navigate back to ‘Scheduled Processes’. Search for the relevant import process (e.g., ‘Import Items’) and run it, selecting the uploaded file as the input.


Share

Leave a Reply

Your email address will not be published. Required fields are marked *