WIP Job Interfaces - WIP_INTERFACE_ERRORS, wip_job_schedule_interface, wip_job_dtls_interface

WIP Job Interfaces

WIP JOB INTERFACES
************************

Interface Tables for WIP Jobs are :-
------------------------------------
wip_job_schedule_interface
wip_job_dtls_interface

How to Import data from Interface Tables to Base Tables
------------------------------------------------------------
Navigation path: WIP - discrete - import jobs and schedules

Concurrent Program to import data :- WIP Mass Load
group_id = 1 (Same group id as in Interface Table)

Error table :- WIP_INTERFACE_ERRORS


Two types of job creation is there
---------------------------------
1. Create a new job with existing Bills and Routings
2. Create a new job with new Operations, new Resources and new Components


1. New Job with existing Bills and Routings( Here we need to create only job with the assebly item already defined in bom and routing. )
---------------------------------------------------------------------------------------------

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
(
'MST' -- organization_id
,973708 -- primary_item_id
,WIP_JOB_NUMBER_S.nextval -- job_name
,2 -- start_quantity
,2 -- Net Quantity
,to_date('09-MAY-2008','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
,6437 -- created_by
, SYSDATE -- creation_date
,6437 -- last_updated_by
, SYSDATE -- last_update_date
);


2. Create a new job with new Operations, new Resources and new Components
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Load Type will be differenct in details interface table

a) Create Job

INSERT INTO wip_job_schedule_interface
(
organization_code
, primary_item_id
, job_name
, start_quantity
, net_quantity
, FIRST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, CLASS_CODE
, COMPLETION_SUBINVENTORY
, group_id
, header_id
, load_type
, process_phase
, process_status
, created_by
, creation_date
, last_updated_by
, last_update_date
)
values
(
'XXX' -- organization_id
,944397 -- primary_item_id
,WIP_JOB_NUMBER_S.nextval -- job_name
,2 -- start_quantity
,2 -- Net Quantity
,to_date('09-MAY-2008','DD-MON-RRRR') --FIRST_UNIT_START_DATE
,sysdate --LAST_UNIT_COMPLETION_DATE
,'Nonstandard' --CLASS_CODE
,'FG' --COMPLETION_SUBINVENTORY
,1 -- group_id
,3530 -- header_id
,4 -- load_type
,2 -- process_phase
,1 -- process_status
,6157 -- created_by
,SYSDATE -- creation_date
,6157 -- last_updated_by
,SYSDATE -- last_update_date
)


b) Create Component

INSERT INTO wip_job_dtls_interface (
organization_id
, operation_seq_num
, department_id
, inventory_item_id_new
, wip_supply_type
, date_required
, quantity_per_assembly
, required_quantity
, quantity_issued
--, mrp_net_flag
--, description
, group_id
, parent_header_id
, load_type
, substitution_type
, process_phase
, process_status
, created_by
, creation_date
, last_updated_by
, last_update_date
)
values
(303 --organization_id
,10 --operation_seq_num
,507 --department_id
,963166 --inventory_item_id_new
,7 --wip_supply_type
,sysdate + 2 --date_required
,1 --quantity_per_assembly
,2 --required_quantity
,1 --Quantity_Issued
--,1 --mrp_net_flag
--,'Sample comp' --description
,32060 --group_id
,3530 --parent_header_id
,2 --load_type 1. resource 2. component 3. operation 4. multiple resource usage
,2 --substitution_type 1.Delete, 2.Add 3.Change
,2 --process_phase
,1 --process_status
,6157 --created_by
,SYSDATE
,6157 --last_updated_by
, SYSDATE )

c) Operation Sequence

INSERT INTO wip_job_dtls_interface (
organization_id
, operation_seq_num
, department_id
, first_unit_start_date
, first_unit_completion_date
, last_unit_start_date
, last_unit_completion_date
, minimum_transfer_quantity
, count_point_type
, BACKFLUSH_FLAG
, group_id
, parent_header_id
, load_type
, substitution_type
, process_phase
, process_status
, created_by
, creation_date
, last_updated_by
, last_update_date
)
values
(303 --organization_id
,10 --operation_seq_num
,507 --department_id
,sysdate --First_Unit_Start_Date
,sysdate+2 --first_unit_comletion_date
,sysdate --last_unit_start_date
,sysdate + 3 --last_unit_completion_date
,1 --minimum_transfer_quantity
,1 -- count_point_type
,1 --BACKFLUSH_FLAG
,32060 --group_id
,3530 --parent_header_id
,3 --load_type 1. resource 2. component 3. operation 4. multiple resource usage
,2 --substitution_type 1.Delete, 2.Add 3.Change
,2 --process_phase
,1 --process_status
,6157 --created_by
,SYSDATE
,6157
, SYSDATE )

c) Resource

INSERT INTO wip_job_dtls_interface (
organization_id
, operation_seq_num
, resource_seq_num
, resource_id_new
, required_quantity
, assigned_units
, applied_resource_units
, usage_rate_or_amount
, group_id
, parent_header_id
, load_type
, substitution_type
, process_phase
, process_status
, created_by
, creation_date
, last_updated_by
, last_update_date
)
values
(303 --organization_id
,10 --operation_seq_num
,1 --resource_seq_num
,5075 --resource_id_new
,10 --required_quantity
,1 --assigned_units
,15 --applier_resource_units
,5 --usage_rate_or_amount
,32060 --group_id
,3530 --parent_header_id
,1 --load_type 1. resource 2. component 3. operation 4. multiple resource usage
,2 --substitution_type 1.Delete, 2.Add 3.Change
,2 --process_phase
,1 --process_status
,6157 --created_by
,SYSDATE
,6157 --last_updated_by
, SYSDATE )