File-Based Data Import (FBDI)

Consider using the FBDI integration option if you need to import or migrate setup and transactional data in bulk into Oracle Fusion Cloud Manufacturing.

To use this option:

1. Download Microsoft Excel templates that are available for several manufacturing entities.
2. Provide the required data.
3. Generate a comma-separated values (CSV) file and upload it to the desired location.
4. Run processes to transfer the data to the interface tables.
5. Import the data to the target Oracle Manufacturing tables.

Key Features

• Used only for inbound integration of data into Oracle Manufacturing.
• Supports the import of large volumes of data into Oracle Manufacturing.

Best Practices

• Use this option to import large volumes of data, such as work orders, operation, material, and resource transactions, into Oracle Manufacturing during the initial migration stage, or on an ongoing basis in specific time intervals.
• You also can use this option to migrate setup data, such as work definitions, into Oracle Manufacturing after transforming the data from legacy systems.
• Review the field/attribute level instructions provided in the Microsoft Excel templates before entering the data that needs to be imported.

Constraints

• This option isn't suitable for importing manufacturing data on a real-time basis.
• It can't be used to upload attachments for work definitions and work orders.
• It can't be used to trigger Electronic Records and Electronic Signatures (ERES) events related to manufacturing.

Oracle Manufacturing Entities that FBDI Supports

Entity	Description
Import of Production Reports	Imports production reports with operations and material transactions.
Process Work Definition Import	Imports process work definitions along with their child entities.
Process Work Order Import	Imports process work orders along with their child entities
Process Work Order Material Transaction Import	Imports process work order material transactions along with their child entities.
Process Work Order Operation Transaction Import	Imports process work order operation transactions along with their child entities.
Work Definition Import	Imports work definitions along with their child entities.
Work Order Import	Imports work orders along with their child entities.
Work Order Material Transaction Import	Imports work order material transactions along with their child entities.
Work Order Material Transaction Import	Imports work order material transactions along with its child entities.
Work Order Operation Transaction Import	Imports work order operation transactions along with their child entities.
Work Order Resource Transaction Import	Imports work order resource transactions along with their child entities.

External data can be extracted and formatted into a source file for transfer, and then imported into Oracle Manufacturing. For more information, see File-Based Data Import (FBDI) for SCM.