Import Work Order Resource Transactions

Use the Import Work Order Resource Transactions scheduled process to create work order resource transactions in manufacturing.

This process ensures that the transaction records in work order resource transaction open interface table are successfully validated, and work order resource 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 Resource Transactions process enables you to create work order resource transactions in Manufacturing. This process should be launched when you intend to import a resource transaction in Manufacturing, and you have populated the work order resource 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 Work Order Import Resource Transactions:

Import Resource Transactions (WIP_IMPORT_RESOURCE_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.
Compatibility	There should only be one instance of the Import Work Order Resource Transactions process running at one time for a batch. There can be multiple instances at the same time for separate batches.

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

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.