Import Work Definitions
Use the Import Work Definitions scheduled process to create and update manufacturing work definitions using file-based data import (FBDI). You can create and update work definition headers, operations, operation items, operation outputs, operation resources, and operation alternate resources.
When to Use
Creating or updating work definitions using FBDI is a 3-step process:
- Prepare the data using either WorkDefinitionTemplate.xlsm for discrete manufacturing work definitions, or ProcessWorkDefinitionTemplate.xlsm for process manufacturing work definitions.
- Load the data to the interface tables using the Load Interface File for Import process. This process validates that the data have been entered as per the expected data type, e.g., number or date and time format.
- Import the data from the interface tables to production tables using the Import Work Definitions process. This process validates that the data satisfy the business rules.
You should run the Import Work Definitions process after the Load Interface File for Import process completes successfully.
Privileges Required
Verify that you have the following privilege 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 Definitions process:
- Import Work Definitions (WIS_IMPORT_WORK_DEFINITIONS_PRIV)
Specifications
Use these specifications when you run the scheduled process.
Specification | Description |
---|---|
Job Type |
As needed. |
Frequency | As needed. |
Time of Day | Any time. |
Duration | Varies, depending on the volume of data that you import. If your import includes a lot of work definition headers and child entities, then the process needs more time to finish. |
Compatibility | There should be only one import process running at a given point of time. However, you can have as many batch codes as you like in the template. When submitting the import job, one batch can be selected, or submit without a batch selection can be done to process all batches that are ready. |
Parameters
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. |
Troubleshooting Information
- You can view the status of the process in the Scheduled Processes work area.
- The validation errors that prevented the creation of update of the work definitions are displayed in the output file (.txt).
- Any interactive warning validations aren’t performed.
- When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.
- You can use Purge Records from Interface scheduled process to remove imported records with status COMPLETED_ERRORS from the work definition interface tables.