Import Work Order Material Transactions

Use the Import Work Order Material Transactions scheduled process to create work order material transactions and Report Orderless Transactions in Oracle Fusion Cloud Manufacturing.

This process ensures that the transaction records in work order material transaction open interface table are successfully validated, and work order material transactions created for those record that pass validation. Records that failed validation will not be processed and will remain in the interface table. They can be corrected and resubmitted.

When to Use

The Import Work Order Material Transactions process enables you to create work order material transactions in Manufacturing. This process should be launched when you intend to import a material transaction in Oracle Manufacturing, and you have populated the work order material transaction open interface table with the required data.

Privileges Required

Verify that you have the following privileges to run Load Interface File for Import process:

• Load File to Interface (FUN_FSCM_FILE_TO_INTERFACE_PRIV)
• Load Interface File for Import (FUN_FSCM_LOAD_INTERFACES_PRIV)
• Manage File Import and Export (FND_MANAGE_FILE_IMPORT_AND_EXPORT_PRIV)
• Transfer File (FUN_FSCM_TRANSFER_FILE_PRIV)

Verify that you have the following privilege to run Import Work Order Material Transactions:

• Import Material Transactions (WIP_IMPORT_MATERIAL_TRANSACTIONS_PRIV)

Specifications

Use these specifications when you run the scheduled process.

Specification	Description
Job Type	Ad hoc job or scheduled. Schedule the process if the import data volumes are high and data is imported at regular intervals.
Frequency	As required, to import data based on volume of data to be transferred. If the data volumes are high, run this a few times a day.
Time of Day	Any time
Duration	Runtime of this process will vary based on the volume of data records.

Parameters

You must define at least a range of work order numbers or dates to process the report.

Parameter	Optional or Required	Description	Parameter Value	Special Combinations Required
Batch	Optional	User defined batch code identifying the group of work definitions that are being imported.	The user defined batch code to be imported.	If no batch is selected, then all the batches in the READY status will be considered.
Partition Size	Optional	Size of the record to be processed per worker.	Example: 500	None

Troubleshooting Information

• You can view the status of the Import Work Order Material Transactions in the Scheduled Processes work area.
• Any interactive warning validations are NOT performed.
• When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.
• There are separate file-based data import (FBDI) templates for Discrete Work Order and Process Work Order Material Transactions.
• You can use Correct Work Orders and Transactions for Import task to correct any failed records.
• You can use Purge Interface Records (All option) to clear off any batches that are not required.