Oracle EBS WIP-Example Work Order Interface - Resource add

1. Both are correct.

Header.column Child.column wip_job_schedule_interface.groupwip_job_dtls_interface.group_id _id wip_job_schedule_interface.headewip_job_dtls_interface.parent_header_id r_id 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

--,line_id

,organization_id --,organization_code ,start_quantity )

values(

'Y' --allow explosion ,'1008119' --created_by

,'JCOLLINS' -- created by name ,sysdate -- creation date

,'104747' -- GROUP ID USE WIP_JOB_SCHEDULE_INTERFACE_S ,'2' --HEADER_ID

,sysdate -- last_update_date ,'1008119' --last updated by

,'JCOLLINS' --last updated by name ,'3' --load_type ,'2' --process_phase ,'1' --process_status ,'136715' --wip_entity_id ,'3159' --,organization_id ,'1' );

insert into wip_job_dtls_interface( --parent_header_id, group_id,

assigned_units, autocharge_type, basis_type,

completion_date,

load_type, -- 1 for loading a resource operation_seq_num, process_phase, process_status, resource_id_old, resource_id_new, resource_seq_num, scheduled_flag, standard_rate_flag, start_date,

usage_rate_or_amount, uom_code,

wip_entity_id, --wip_entity_name,

organization_id, substitution_type, last_update_date, last_updated_by, creation_date, created_by,

schedule_seq_num )

values( --'2'

'104747' -- group_id ,'1' --assigned_units, ,'1' --autocharge_type, ,'1' --basis_type,

,sysdate + 360 --completion_date,

,'1' --load_type, -- 1 for loading a resource ,'10' --operation_seq_num, ,'2' --process_phase, , '1' --process_status, ,'4267' --resource_id_old ,'4267' --rsource_id_new ,'50' --resource_seq_num, , '1' --scheduled_flag, ,'1' --standard_rate_flag, ,sysdate -- start_date, ,'1' --usage_rate_or_amount ,'HR' -- uom_code,

,'136715' -- wip_entity_id ,'3159' -- organization_id ,'3' -- substitiution_type ,sysdate -- last_update_date ,'1068' --last_updated_by ,sysdate -- creation_date ,'1068' -- created by

,'40' --schedule_seq_number );

Please find an example : we replace a group of resources by another group of resources: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE (group_id ,header_id ,wip_entity_id ,organization_id

,first_unit_start_date ,firm_planned_flag ,status_type ,load_type ,process_phase ,process_status ,description ,created_by ,creation_date ,last_update_date ,last_update_login ,last_updated_by) VALUES (i_group_id ,i_job_id ,i_job_id

,i_organization_id

,i_first_unit_start_date ,i_firm_planned_flag

,1 -- STATUS_TYPE: Unreleased

,3 -- LOAD_TYPE: Update standard or non-standard Discrete Job ,2 -- PROCESS_PHASE: Validation ,1 -- PROCESS_STATUS: Pending ,i_description ,g_created_by ,g_creation_date ,g_last_update_date ,g_ast_update_login ,g_last_updated_by);

INSERT INTO WIP_JOB_DTLS_INTERFACE (group_id ,wip_entity_id ,organization_id ,parent_header_id ,operation_seq_num ,department_id ,resource_id_old

,replacement_group_num ,resource_seq_num ,resource_id_new

,usage_rate_or_amount ,uom_code ,load_type

,substitution_type ,process_phase ,process_status ,description ,created_by ,creation_date ,last_update_date ,last_update_login ,last_updated_by) VALUES (i_group_id ,i_job_id

,i_organization_id ,i_job_id

,r_operations.operation_seq_num ,r_operations.department_id ,r_operations.resource_id

,r_operations.replacement_group_num ,r_operations.resource_seq_num ,r_operations.new_resource_id

,r_operations.usage_rate_or_amount ,r_operations.uom_code ,1 -- resource ,3 -- change ,2 -- validation ,1 -- pending ,i_description ,g_created_by ,g_creation_date ,g_last_update_date ,g_last_update_login ,g_last_updated_by);

Our requirement is to create a new resource and we dont have any job order as of now. Is there any interface table / API for creating new resources. We were looking in to the wip_cost_txn_interface table but where in we are getting error with WIP_ENTITY_NAME column.

Please let us know if wip_cost_txn_interface is the correct table to be used for resource creation, if so what is the value that needs to be passed to the WIP_ENTITY_NAME as because we don't have any job order to which this resource will be assigned.

There is no open interface to create Resources (please check in Oracle Manufacturing APIs and Open Interfaces Manual ). You have to simulate form transactions (insert data into

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle EBS WIP-Example Work Order Interface - Resource add在线全文阅读。