ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 部分工单组件需求量没有考虑损耗率

部分工单组件需求量没有考虑损耗率

原创 Linux操作系统 作者:jarli 时间:2019-06-18 12:18:06 0 删除 编辑

1.oracle ERP 版本:12.0.6

2.现状:发现部分工单组件需求量没有考虑损耗率问题,
      即使同一个生产料件,有的考虑,也有不考虑的。

3.出现问题的工单为:组件设置损耗的工单

4.产生问题的时机:是计划人员把工单状态从“已发放”-->“未发放”状态,其组件需求量不考虑损耗, 其他操作,目前发现都是正常考虑工单损耗。

5.临时解决方式: 就是把工单再次发放时,要把清单版本日期清空保存。

6. 我已经提交tar并进行跟踪,让oracle提出最终的解决方案。

7.自己临时跟踪sql:
select
  we.wip_entity_name,
   item.segment1,
   ITEM.ITEM_TYPE,
   item.description,
   item.creation_date,
   wdj.creation_date   ,
    WDJ.SCHEDULED_START_DATE,
   WDJ.SCHEDULED_COMPLETION_DATE,
   WE.PRIMARY_ITEM_ID,
   wdj.*
   /*,   wro.inventory_item_id,WRO.QUANTITY_PER_ASSEMBLY,WRO.COMPONENT_YIELD_FACTOR, wro.required_quantity, wro.quantity_issued
*/from  --wip_requirement_operations wro,
      wip_entities we,
      wip_discrete_jobs wdj,
      mtl_system_items_b item
where 1=1 --ceil(wro.required_quantity)=wro.required_quantity
-- and we.wip_entity_id=wro.wip_entity_id
 and we.wip_entity_id=wdj.wip_entity_id
 --and (we.wip_entity_name  like '%-S' OR we.wip_entity_name  like '%-W')
--and item.segment1 like '13%'
--and we.primary_item_id=15517
--and item.segment1='1301800U10090'
 --and we.wip_entity_name like '0907%-S%'
 and item.organization_id=we.organization_id
 and item.inventory_item_id=we.primary_item_id
 --AND TO_CHAR(ITEM.CREATION_DATE,'YYYYMMDD')>='20090601'
 --AND WDJ.STATUS_TYPE IN (1,3)
  and exists (select 1
              from wip_requirement_operations wro
              where wro.wip_entity_id=we.wip_entity_id
               and wro.organization_id=we.organization_id
               AND WRO.COMPONENT_YIELD_FACTOR<1
               and ceil(wro.required_quantity)=wro.required_quantity
               and wro.wip_supply_type not in (4,5,6)
               having count(wro.inventory_item_id)>15)
ORDER BY WDJ.Creation_Date desc

8.Oracle 提供方案2009.10.22

CAUSE DETERMINATION
====================
This is a code issue.
when job status is changed back to unreleased from released, yield is not considered for the c
omponents required quantity.


CAUSE JUSTIFICATION
====================
This issue has been fixed in the file wipocmpb.pls in version 120.1.12000000.2.

This is explained in the following bug:
BUG 8838245 - REQUIRED QUANTILY DOES NOT CONSIDER THE YIELD IN DISCRETE JOBS


.
PROPOSED SOLUTION(S)
======================
Apply Patch.8838245

PROPOSED SOLUTION JUSTIFICATION(S)
====================================
The issue is resolved by upgrading to file wipocmpb.pls and version 120.1.12000000.2 or higher.
The following bug outlines this solution:
BUG 8838245 - REQUIRED QUANTILY DOES NOT CONSIDER THE YIELD IN DISCRETE JOBS


.
SOLUTION / ACTION PLAN
=======================
To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch.8838245

2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
wipocmpb.pls 120.1.12000000.'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.


 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/41594/viewspace-613202/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 宝宝入园准备
下一篇: 物料保留
请登录后发表评论 登录
全部评论

注册时间:2003-03-27

  • 博文量
    227
  • 访问量
    160599