API to update wip_discrete_jobs : How to Update WIP discreate Jobs From Backend in Oracle Apps

API to update wip_discrete_jobs : How to Update WIP discrete Jobs From Backend in Oracle Apps

In this post , We will be discuss about API to update wip_discrete_jobs. If we have an Requirment to mass update the WIP discrete jobs in oracle apps then going through from application is not feasible , We need to have some api to mass update the information's in WIP jobs from backend. In this post, We will be more discuss on that feasibility. One More important thing in this , Oracle has not provided any API to update the wip_discrete_jobs  so this does not means that we cannot update the wip_discrete_jobs. Oracle has provided some other ways , by which we can update the WIP discrete jobs. Here in this post , I will discuss about API to update wip_discrete_jobs through some other way.

 

 

API to update wip_discrete_jobs through Work Order Interface

Oracle  has provided the Work Order Interface to update the update wip_discrete_jobs from back end.

 

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

 

 

Example Of API to update wip_discrete_jobs Using Work Order Interface

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