Base table :
1) WIP_DISCRETE_JOBS
2) WIP_LINES
3) WIP_ENTITIES
4) WIP_OPERATIONS
5) WIP_TRANSACTIONS
Concurrent Program to import data :
WIP Mass Load
Interface Table :
WIP_JOB_SCHEDULE_INTERFACE
Error table :-
WIP_INTERFACE_ERRORS
Run The Conncurent for the submison of the discrete jobs into the base table :
apps.fnd_request.submit_request
(application => 'WIP',
program => 'WICMLP', -- CONCURRENT PROGRAM SHORT NAME
description => '',
start_time => TO_CHAR(SYSDATE,'DD-MON-YY HH24:MI:SS'),
sub_request => FALSE,
argument1 => '1041'--Group ID,
);
fnd_file.put_line (fnd_file.LOG,'MESSEGE');
EXAMPLE :
INSERT INTO wip_job_schedule_interface
(created_by
,creation_date
,last_updated_by
,last_update_date
,process_phase
,process_status
,job_name
,load_type
,primary_item_id
,class_code
,status_type
,start_quantity
,first_unit_start_date
,alternate_bom_designator
,bom_revision
,alternate_routing_designator
,routing_revision
,wip_supply_type
,completion_subinventory
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,organization_id
,GROUP_ID
)
VALUES (created_by -----> created_by needs to be changed
,SYSDATE -----> creation_date needs to be changed
, last_updated_by -----> last_updated_by needs to be changed
,SYSDATE ---->last_update_date needs to be changed
,2 -----> process_phase
,1 -----> process_status
,WIP_JOB_NUMBER_S.nextval -----> job_name has to be unique and needs to be changed
,1 ----> load_type
,ln_item_code ----> primary_item_id needs to be changed
,'Standard' ----> class_code
,1 ----> status_type
,start_quantity ----> start_quantity needs to be changed
,SYSDATE ----> first_unit_start_date
,NULL -----> alternate_bom_designator
,NULL -----> bom_revision
,NULL -----> alternate_bom_designator
,NULL -----> routing_revision
,2 ----> wip_supply_type
,'WIP_COMP' ----> completion_subinventory
,NULL -----> attribute_category
,NULL -----> attribute1
,NULL -----> attribute2
,NULL -----> attribute3
,NULL -----> attribute4
,NULL -----> attribute5
,NULL -----> attribute6
,NULL -----> attribute7
,NULL -----> attribute8
,NULL -----> attribute9
,NULL -----> attribute10
,organization_id ----->organization_id needs to be changed
, GROUP_ID -----> GROUP_ID needs to be changed
);
"&Interface_id : The resource or resource instance specified does not exist on the job."
ReplyDeleteFor this error, Any Solution is there. I tried with changes of Scheduled Yes/No Both. But it is not resolved. If any solution please reply me(mahiemahi[at]gmail).