Import Work Order Operation Transactions
Use the Import Work Order Operation Transactions scheduled process to create work order operation transactions in Oracle Fusion Cloud 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 Oracle Manufacturing. This process should be launched when you intend to import a operation transaction in Oracle 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.