计划员时常在excel调整工单排程,为了达到与系统日期一致,进行批量更新工单开工日期
1.把数据插入接口,其对应sql:
insert into wip_job_schedule_interface
(group_id,
job_name,
organization_id,
process_phase,
process_status,
load_type,
first_unit_start_date,
last_update_date,
creation_date,
last_updated_by,
created_by)
select
282698,
we.wip_entity_name,
we.organization_id,
2,--process_phase,
1,--process_status,
3,--load_type,
to_date('2010-09-28 12:35:35', 'yyyy-mm-dd hh24:mi:ss'),
sysdate,
sysdate,
1091,
1091
from wip_entities we
where we.wip_entity_name='1002171-A'
(group_id,
job_name,
organization_id,
process_phase,
process_status,
load_type,
first_unit_start_date,
last_update_date,
creation_date,
last_updated_by,
created_by)
select
282698,
we.wip_entity_name,
we.organization_id,
2,--process_phase,
1,--process_status,
3,--load_type,
to_date('2010-09-28 12:35:35', 'yyyy-mm-dd hh24:mi:ss'),
sysdate,
sysdate,
1091,
1091
from wip_entities we
where we.wip_entity_name='1002171-A'
2.查看接口数据 “Pending Jobs and schedules”
3.提交请求“WIP Mass Load”,更新实体表
4.对应栏位说明:
group_id :组ID,理论上可随便给;比如曾做过客户化的全部用987654321;
也可以取自wip_job_schedule_interface_s.NEXTVAL
load_type: 新建标准离散工单给1
1 Create Standard Discrete Job
2 Create Pending Repetitive Schedule
3 Update Standard or Non-Standard Discrete Job
4 Create Non-Standard Discrete Job
allow_explosion
给Y
N 需要自定义组件需求和工序,写入wip_job_dtls_interface
Y 自动用标准BOM和Routing展开
process_phase
给2
2 Validation
3 Explosion
4 Completion
5 Creation
process_status
给1
1 Pending
2 Running
3 Error
4 Complete
5 Warning
status_type: 工单状态1 UnReleased 3 Released 需要开会计期
wip_supply_type: 供应类型,不给的话默认是Based on Bill
1 Push 2 Assembly Pull 3 Operation Pull 4 Bulk 5 Supplier 6 Phantom 7 Based on Bill
job_name 任务号,不给的话系统自动生成
organization_id 库存组织ID
class_code 工单类型
primary_item_id 装配件ID
start_quantity 计划生产量;非标可以=0,标准必须>0;只能是主单位数量
scheduling_method 排产方法1 Routing-based 2 Item Lead Time 3 Mannual
first_unit_start_date 计划开始时间
source_code 来源代码,随便给,一般是来源系统名
5个who字段 习惯上都要给
也可以取自wip_job_schedule_interface_s.NEXTVAL
load_type: 新建标准离散工单给1
1 Create Standard Discrete Job
2 Create Pending Repetitive Schedule
3 Update Standard or Non-Standard Discrete Job
4 Create Non-Standard Discrete Job
allow_explosion
给Y
N 需要自定义组件需求和工序,写入wip_job_dtls_interface
Y 自动用标准BOM和Routing展开
process_phase
给2
2 Validation
3 Explosion
4 Completion
5 Creation
process_status
给1
1 Pending
2 Running
3 Error
4 Complete
5 Warning
status_type: 工单状态1 UnReleased 3 Released 需要开会计期
wip_supply_type: 供应类型,不给的话默认是Based on Bill
1 Push 2 Assembly Pull 3 Operation Pull 4 Bulk 5 Supplier 6 Phantom 7 Based on Bill
job_name 任务号,不给的话系统自动生成
organization_id 库存组织ID
class_code 工单类型
primary_item_id 装配件ID
start_quantity 计划生产量;非标可以=0,标准必须>0;只能是主单位数量
scheduling_method 排产方法1 Routing-based 2 Item Lead Time 3 Mannual
first_unit_start_date 计划开始时间
source_code 来源代码,随便给,一般是来源系统名
5个who字段 习惯上都要给
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/41594/viewspace-675080/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/41594/viewspace-675080/