WIP job creation api

WIP job creation api

In this post , We will be discuss about WIP job creation api. Here we were talking about Discrete job. First of all I will Clear you one thing , As per the Oracle Metalink Note (1326639.1) , These is no Standard API available for WIP job creation but we can achieve the API functionality through Work Order Interface for creating WIP Jobs. This Work Order Interface has other many uses , Which I will be share more in this post. Please find below the complete details of WIP job creation api using Work Order Interface.

 

 

WIP job creation api using Work Order Interface

 

The Work Order Interface enables you to import Discrete Jobs and Repetitive Schedules header information, Discrete Jobs operations, material, resource and scheduling information using a single process.

 

These are the below Options we can achieve through Work Order Interface

- Planned orders for new Discrete jobs using the Work Order Interface.
- Discrete Jobs operations, components, resources, resource usage and scheduling details.
- Update and reschedule recommendations for existing Discrete Jobs.
- Suggested Repetitive Schedules.

 

The WIP job creation api/Work Order Interface consists of two tables: 

• WIP_JOB_SCHEDULE_INTERFACE table (Open Job and Schedule Interface table); header information can be loaded into the WIP_JOB_SCHEDULE_INTERFACE table.
• WIP_JOB_DTLS_INTERFACE table (WIP Job Details Interface table); operations, components, resources, and scheduling information can be loaded into the
• WIP_JOB_DTLS_INTERFACE table.

Example Of WIP job creation api

INSERT INTO wip_job_schedule_interface
(
 organization_code
, primary_item_id
, job_name
, start_quantity
, net_quantity
, first_unit_start_date
, class_code
, status_type
, COMPLETION_SUBINVENTORY
, group_id
, load_type
, process_phase
, process_status
, created_by
, creation_date
, last_updated_by
, last_update_date
)
values
(
'TSO' -- organization_id
,833708 -- primary_item_id
,WIP_JOB_NUMBER_S.nextval -- job_name
,40 -- start_quantity
,40 -- Net Quantity
,to_date('01-NOV-2018','DD-MON-RRRR') --first_unit_start_date
,'Discrete' --class_code
,3 --status_type 1.UnReleased 3. Released 4.Complete 6.On Hold 7. Cancelled
,'ASSY' --COMPLETION_SUBINVENTORY
,10 -- group_id
,1 -- load_type
/*
1 Create Standard Discrete Job
2 Create Pending Repetitive Schedule
3 Update Standard or Non-Standard Discrete Job
4 Create Non-Standard Discrete Job
*/
,2 -- process_phase 2 Validation 3 Explosion 4 Complete 5 Creation
,1 -- process_status 1 Pending 2 Running 3 Error 4 Complete 5 Warning
,5678 -- created_by
, SYSDATE -- creation_date
,5678 -- last_updated_by
, SYSDATE -- last_update_date
);