WIP Open Interface

WIP Jobs and Schedules Open Interface 

The WIP Mass Load program does all of the following:

•  Validates the data in the Interface table
•  Derives values for additional columns
•  Creates new discrete jobs, updates existing jobs, schedules and/or creates pending repetitive schedules
•  Optionally launches the Job and Schedule Interface Report (WIPMLINT)
•  Deletes successfully processed records from the interface table
•  Failed records can be resubmitted using the Pending Jobs and Schedules window.
•  All processing is initiated via the Import Jobs and Schedules window and managed by the concurrent manager.

Open Interface :
Jobs and Schedule Interface

Base Tables:
WIP_DISCRETE_JOBS
WIP_ENTITIES
WIP_OPERATIONS

Interface Tables:

WIP_JOB_SCHEDULE_INTERFACE - 

Table holds Open Job and Schedule Interface details.

Load jobs header information into the WIP_JOB_SCHEDULE_INTERFACE table.

WIP_JOB_DTLS_INTERFACE - 

Table holds WIP Job Details Interface table

Load operations, components, resources, and scheduling information into the WIP_JOB_DTLS_INTERFACE table.

LOAD_TYPE:  To load or Update
1 - Resources, 
2 - Components
3 - Operations
4 - Resource usage

Mandatory Columns:

GROUP_ID: used to group rows in the interface table to be processed in batches by WIP Load.

PROCESS_PHASE: 

1 -  Records in load phase.

2- Validation.

PROCESS_STATUS: 

1 - Pending

2 - Running

3 - Error/fail

6 - Complete/Success .

 SUBSTITUTION_TYPE:  

1 - Delete 

2 - Add 

3 - Change

 It will error out for all other values.

Instructions to Launch Interface:

Step 1) Identify the Jobs that are to be updated: filter conditions and criteria.

Step 2) Insert records into interface tables.

Step 3) Run standard interface program: USE the Import Jobs AND Schedules window to launch the WIP Mass Load (WICMLX) concurrent program. 

References:

• Oracle Work in Process User’s Guide, Release 11i