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