Is there an API to Reschedule Operations in Discrete Job
I am trying to find an API that will provide functionality similar to "Reschedule" button in the Job/Schedule Details > Operations form. With this form, I can select any operation in the routing and provide either a First Unit Start Date or Last Unit Completion Date. The rescheduling will automatically adjust the operation selected and any subsequent operations on the job.
So far I have tried using WIP Interface tables - wip_job_schedule_interface and wip_job_dtls_interface.
INSERT INTO wip_job_schedule_interface( LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, GROUP_ID, HEADER_ID, WIP_ENTITY_ID, ORGANIZATION_ID, PROCESS_PHASE, PROCESS_STATUS, LOAD_TYPE, ALLOW_EXPLOSION) VALUES ( SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID, wip_interface_s.nextval, wip_interface_s.nextval, 15299241, 85, 2, --Validation 1, --Pending 3, --Update std/non-std discrete job 'Y' ) RETURNING GROUP_ID, HEADER_ID INTO l_group_id, l_header_id; INSERT INTO wip_job_dtls_interface( GROUP_ID, LOAD_TYPE, OPERATION_SEQ_NUM, PARENT_HEADER_ID, PROCESS_PHASE, PROCESS_STATUS, SUBSTITUTION_TYPE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, FIRST_UNIT_START_DATE VALUES ( l_group_id, 3, -- Operation 190, l_header_id, 2, --2 = Validation 1, --1 = Pending 3, --3 = Change SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID, TRUNC(SYSDATE + 4) );