In Oracle Fusion, FBDI, ADFDI, and HDL are key tools for data loading and integration. Here's a breakdown of each:
1. FBDI (File-Based Data Import) :
- Purpose:
- FBDI is used for bulk loading data into Oracle Fusion applications using flat files (typically CSV).
- It's designed for loading large volumes of data, such as master data (e.g., customers, suppliers, employees) and transactional data.
- Process:
- Download predefined Excel templates from Oracle.
- Populate the templates with your data.
- Generate CSV files from the Excel templates.
- Create a ZIP file containing the CSV files.
- Upload the ZIP file to Oracle Fusion using the Load Interface File for Import process.
- Run the Import process to load the data into the application tables.
- Key Features:
- Bulk data loading.
- Standardized Excel templates.
- Validation of data before import.
- Error handling and reporting.
- Use Cases:
- Loading initial data during implementation.
- Mass updates of master data.
- Loading large volumes of transactional data.
2. ADFDI (ADF Desktop Integration) :
- Purpose:
- ADFDI allows users to work with Oracle Fusion data directly within Microsoft Excel.
- It provides a spreadsheet-based interface for viewing, editing, and creating data.
- It is more for data maintenance, than very large data loads.
- Process:
- Download an ADFDI-enabled Excel workbook.
- Connect to your Oracle Fusion environment.
- Download data into the spreadsheet.
- Modify or add data.
- Upload the changes back to Oracle Fusion.
- Key Features:
- Spreadsheet-based data management.
- Real-time data synchronization with Oracle Fusion.
- User-friendly interface.
- Validation of data before upload.
- Use Cases:
- Data maintenance and updates.
- Working with data in a familiar Excel environment.
- Allowing end users to update data.
3. HDL (HCM Data Loader) :
- Purpose:
- HDL is specifically designed for loading data into Oracle Fusion HCM (Human Capital Management).
- It's a powerful tool for loading large volumes of HCM data, including worker data, organization structures, and compensation information.
- Process:
- Create data files in a specific format (typically CSV or DAT).
- Upload the data files to Oracle Fusion using the HCM Data Loader tool.
- HDL processes the data files and loads the data into the HCM tables.
- Key Features:
- Optimized for HCM data loading.
- Support for complex HCM data structures.
- Flexible data file format.
- Incremental and full loads.
- Object versioning.
- Use Cases:
- Loading employee data during implementation.
- Mass updates of HCM data.
- Integrating HCM data with other systems.
Key Differences Summarized :
- FBDI: General-purpose bulk data loading using Excel templates.
- ADFDI: Spreadsheet-based data management within Excel for end users.
- HDL: Specialized bulk data loading for Oracle Fusion HCM.
