Import Work Order Operation Transactions

Use the Import Work Order Operation Transactions scheduled process to create work order operation transactions in Manufacturing.

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

  • Import Operation Transactions (WIP_IMPORT_OPERATION_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 Operation 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

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area
  • Error and warning messages encountered while running the process are displayed in the process log file
  • When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area
  • You can use Correct Work Orders and Transactions for Import to correct any failed records
  • You can use Purge Interface Records (All option) to clear off any batches that are not required.