Discrete Manufacturing - EBS (MOSC)

MOSC Banner

Is there an API to Reschedule Operations in Discrete Job

edited May 26, 2019 2:24AM in Discrete Manufacturing - EBS (MOSC) 7 commentsAnswered

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)    );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center