Importing Jobs and Schedules

You can use the Import Jobs and Schedules window to submit the WIP Mass Load program.

When the WIP Mass Load program is submitted, the system searches the Open Job and Schedule Interface (WIP_JOB_SCHEDULE_ INTERFACE) table for rows with the specified Group ID. It then creates standard and non-standard discrete jobs, updates existing jobs, and creates pending repetitive schedules for all valid rows. If a row fails validation, an error message is generated. You can view these errors and update failed rows using the Pending Jobs and Schedules window.

Note: When a job is changed to complete, closed, or canceled status - an informational warning message displays if open purchase orders or requisitions exist for any of the operations.

The assembly unit number can be changed through WIP Mass Load for discrete jobs that are unreleased, project related, and use unit effectivity. You can change job status is from Unreleased to Released in the same process.

You can also use Oracle Advanced Planning to submit the WIP Mass Load program and perform the same actions on planned orders, reschedule recommendations, or suggested schedules sourced for Oracle Advanced Planning.

The Job and Schedule Interface Report is automatically printed when the WIP Mass Load program is submitted. This report lists the standard and non-standard jobs that were created, the jobs that were updated, and the repetitive schedules that were created. It also lists the jobs and repetitive schedules rows that failed to process. If you resubmit the Job and Schedule Interface Report after the WIP Mass Load program has cleared the Open Job and Schedule Interface table of successfully processed records, only records for failed rows are listed.

arrow icon   To import jobs and schedules:

  1. Navigate to the Import Jobs and Schedules window. The Parameters window appears.

  2. Enter a Group ID number.

    The system polls the WIP_JOB_SCHEDULE_INTERFACE table for rows with this group identification number. When rows with this number are found, the system validates the data and either creates a job or repetitive schedule, reschedules an existing job, or enters an error message. Rows with errors in them remain in the table and can be updated and resubmitted. See: Processing Pending Jobs and Schedules

  3. Choose OK.

  4. Submit the import request. See: Submitting a Request.

Related Topics