work order oracle,Oracle EBS WIP-Example Work Order Interface - Resource add

1. Both are correct.

2. The difference is as follows:

- WIP Mass Load is used to process the records from the WIP_JOB_SCHEDULE_INTERFACE table for applications using GUI mode.

- WIP Mass Interface is the program that performs the same process for applications using character mode.

When loading into this table the following must be verified as well: The values for parent_header_id and group_id in the table WIP_JOB_DTLS_INTERFACE for detail records MUST MATCH the group_id and header_id columns in the table WIP_JOB_SCHEDULE_INTERFACE. The detail records in the table WIP_JOB_DTLS_INTERFACE are linked to the Header record in the table wip_job_schedule_interface by the columns parent_header_id and group_id.

Example Work Order Interface - Resource add

Can anyone give me an example load script for wip_job_schedule_interface and wip_job_dtls_interface tables? The documentation has a couple of errors and if I could just see one example that works I think I could figure it out. I have an existing work order and just want to be able to add a resource using the work order interface.

p.s. I am getting invalid value for load type when I use the following:

insert into wip_job_schedule_interface(

allow_explosion

,created_by

,created_by_name

,creation_date

,group_id

,header_id

,last_update_date

,last_updated_by

,last_updated_by_name

,load_type

,process_phase

,process_status

,wip_entity_id

--,wip_entity_name

--,line_code