关闭

INV&WMS Picking Rule

标签: datemanagercontainersparametersreferencesystem
4705人阅读 评论(2) 收藏 举报
分类:

Inventory Picking Rule(Oracle Apps R12)

用于在非WMS组织下,给Sales Order, WIP, OPM Manufacturing设置挑库规则

路径:Inventory > Setup > Rules > Picking

  • Lot: You can sort by lot based on the following criteria:

    • Lot Number Asc: Sorts the lot by number in ascending order.

    • Lot Number Desc: Sorts the lot by number in descending order.

    • FIFO: Sorts the lot by first in first out.

    • FEFO: Sorts the lot by first expired first out.

  • Revision: You can sort by revision based on the following criteria:

    • Revision Asc: Sorts by revision in ascending order.

    • Revision Asc: Sorts by revision in descending order.

    • Effective Date Asc: Sorts by revision effective date in ascending order.

    • Effect Date Desc: Sorts by revision effective date in descending order.

  • Subinventory: You can sort by subinventory based on the following criteria:

    • Subinventory Asc: Sorts by subinventory in ascending order.

    • Subinventory: Desc: Sorts by subinventory in descending order.

    • Receipt Date Asc: Sorts by receipt date in ascending order.

    • Receipt Date: Desc: Sorts by receipt date in descending order.

  • Locator: You can choose to sort by locator based on the following criteria:

    • Locator Asc: Sorts by locator in ascending order.

    • Locator Desc: Sort by locator in descending order.

    • Receipt Date Asc: Sorts by receipt date in ascending order.

    • Receipt Date: Desc: Sorts by receipt date in descending order.

创建完一个Picking rule之后,你可以使用Rules Workbench来把Picking Rule规则分配给具体的Item项。Seq的数字越小,优先级越高。


Organization Parameter下边关于Picking Rule的设置

Picking Default里的Rule是用于选择一个默认的rule规则,这个默认的Picking rules用于Order Management来挑选货物。根据NOTE1327488.1,If it will assign seeded picking rule at Org Paramerts and user define Picking rules in Rules Bench.. Which one is effective?

The Rules workbench has a high priority over the Organization Parameters Picking Rule。

特别注意:This rule will not be employed in a WMS enabled organization. (WMS 的Org不用默认的Org Picking Rule)

Item下Picking Rule的设置

用于设置这个Item默认选取的rule规则。所以Picking Rule可以在Org级设置也可以在Item级制定。


WMS Picking Rule

路径:Warehouse Manager > Setup > Warehouse Configuration > Rules > Warehouse Execution > Rules

INV Rule和WMS Rule的关系:

对于非WMS组织,应该使用Inv的Picking Rule,只有WMS才用上边这个路径来设置Picking Rule。下图为非WMS组织打开WMS Rule form的提示,"WMS Rules / Strategies are not supported in INV org. Use Picking Rules : Inventory -> Setup -> Rule -> picking"

如果是在WMS下,打开WMS Rules form,界面如下:

很明显WMS的Picking Rule能定义更负责的挑库规则。下边为http://www.oracleug.com/user-guide/warehouse-management/overview-picking的一段解释

picking rule in inventory determine the order in which revisions, lots, subinventories, and locators are picked for sales orders.

Picking rule in WMS is used for directed picking creates material allocations and directs operators to pick material from specific locations.

They(INV rule and WMS Rule) workin conjunction with the different pick methodologies. Pick methodologies refer to the different method an operator performs picking tasks. For example, an operator may select to pick an order by itself, or to pick multiple orders at the same time.

The system generates picking tasks and dispatches them to qualified operators based on rules. After picking is complete, the system provides operators with the appropriate number and size of containers the order requires for shipping.


WMS Rule定义的流程

In a WMS Organization,you need to create your rule with following nav path:

Warehouse Manager > Setup > Warehouse Configuration > Warehouse Execution > Rules

After doing that and enabling the rule you should be able to assign rule to Rules Workbench.

Nav Path: Warehouse Manager > Setup > Warehouse Configuration > Warehouse Execution > Rules Workbench

Then you should run Generate All Rules concurrent program

Warehouse Manager > Others > Others > Requests > Requests > Run > Generate All Rules


另外关于Pick Release Rules

路径:Order Management > Shipping > setup > Define Release Rules Forms

Pick Release Rule和Picking Rule 是两个不同的东西,Pick Release rule是一个在做SO Pick Release时的模板,做SO Pick Release的时候,你可以选择不同的模板,这样可以会自动带出Pick Release的预定义选项。(感觉应该改名字叫Release Template,会更清楚些)


INV Picking Rule的后台逻辑

从R12开始,对于非WMS Org,在做Pick Release的时候,WMS Rules Engine会被调用,就是说,对于non WMS organizations,Rule Engine将不会看WMS strategies,它只会看Inventory Picking Rules。

每创建一个新的Rule,在MTL_PICKING_RULES表会插入一条记录,Sample Query:
SELECT * FROM mtl_inv_picking_rules WHERE wms_rule_id = 10533;

几个MTL_PICKING_RULES表中的字段
LOT_SORT:                 0 - NONE, no sort; 1 - Lot number Asc; 2 - Lot number Desc; 3 - FIFO , first in first out; 4 - FEFO, first expire first out
LOT_SORT_RANK:     Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
REVISION_SORT:        0 - NONE; 1 - Revision Asc; 2 - Revision Desc; 3 - Effective date Asc; 4 - Effective date Desc
REVISION_SORT_RANK:Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
SUBINVENTORY_SORT:0 - NONE; 1 - Subinventory Asc; 2 - Subinventory Desc; 3 - Receipt date Asc; 4 - Receipt date Desc
SUBINVENTORY_SORT_RANK:Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number
LOCATOR_SORT:        0 - NONE; 1 - Locator Asc; 2 - Locator Desc; 3 - Receipt date Asc; 4 - Receipt date Desc
LOCATOR_SORT_RANK:Order by rank regarding to other sort criteria, saved as wms_sort_criteria.sequence_number


当Enable这个Rule之后,在wms_rules_b表也会有对应的记录产生,Sample Query:
SELECT tl.name,tl.description,b.*
FROM wms_rules_b b,wms_rules_tl tl
WHERE b.rule_id = tl.rule_id
AND b.rule_id=10533
AND LANGUAGE = 'US';


Rule Workbench对应的Table是wms_selection_criteria_txn(picking rule assignments),可以使用下边的Query查询Rule Workbench的信息,Sample Query:
Select * from wms_selection_criteria_txn where return_type_id=&rule_id;

并且会动态生成一个新的Package:WMS_RULE_<rule_id>,你可以通过下边的SQL查看WMS_RULE_<Rule_ID>的内容
select text from dba_source where name='WMS_RULE_XXXX';

可以从INV Log中找到,挑库的时候到底使用了那个Rule Id,比如,可以在日志中找到下边的信息
[01-AUG-11 05:57:43] wms.plsql.WMS_Rule_PVT.Apply.l_rule_id: 10533
如果Pick的过程报错,可以在日志中看到下边类似的信息:

wms.plsql.WMS_Engine_PVT.Create_Suggestions.end G_SUGG_FAILURE_MESSAGE: WMS_PICK_NO_ROWS


Reference:

http://www.scribd.com/doc/60058250/WMS-RULE

http://www.oracleug.com/user-guide/warehouse-management/overview-picking


转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7708578

======EOF======

3
0
查看评论

wms接口开发说明

1   概述 zdb平台与第三方平台对接的一个范例。 基于sealink wms定义的接口实现。 接口技术要求简述如下: l  http协议 l  消息body采用json格式 l  通过url传递系统参数   zdb端实现上行部分的接口(...
  • wherwh
  • wherwh
  • 2017-03-09 17:24
  • 1010

论文阅读(2)--Picking Deep Filter Responses for Fine-grained Image Recognition

这次阅读的文章是Picking Deep Filter Responses for Fine-grained Image Recognition,这篇文章是来自上海交通大学Xiaopeng Zhang等人的工作,该文章提出了一种对深度网络中的filter进行挑选的方法,基于挑选的filter的结果构...
  • lc013
  • lc013
  • 2016-10-08 22:56
  • 1467

3D bin picking

  • clipp_Huang
  • clipp_Huang
  • 2016-12-05 18:04
  • 1544

Picking Deep Filter Responses for Fine-Grained Image Recognition

作为一个新兴的研究课题,细粒度识别旨在区分属于同一基本类别的数百个子类别。它位于基本类别分类(例如,在Pascal VOC [8]中分类自行车,船,汽车等等)和个体实例的识别(例如人脸识别)之间。没有经验的人可以立即识别自行车或马匹等基本类别,因为它们在视觉上非常不相似,而在没有具体专家指导的情况下...
  • xiaofei0801
  • xiaofei0801
  • 2017-08-16 17:19
  • 182

罗大柚OpenGL ES教程系列LessonX——Object Picking

iOS版本的Object Picking, 使用了两种方法: 一种是Ray Casting, 另一种是 Color Picking 提供了两种方法实现的两个Demo,目前国内网上并没有该类资料
  • luozhonglan
  • luozhonglan
  • 2014-04-02 12:09
  • 2710

使用bootstrap框架日期组件

一、首先,bootstrap是支持日期组件的。在网上找了很多方法尝试,失败了很多次。最终一个问题一个问题的解决,总结如下。 1.      注意bootstrap.datetimepicker.js等文件的版本,版本不同,使用方式也不同。 ...
  • womeng2009
  • womeng2009
  • 2016-11-29 22:51
  • 327

Picking Strawberries

FJNU.1754DescriptionThere are N hills distributing near Jesse’s home and they are numbered as 1,2,…,N from west to east. Now Jesse has H hours’ leisur...
  • yahreso
  • yahreso
  • 2008-03-15 23:11
  • 387

基于RULE的优化器(学习笔记)

1.1 基于RULE的优化器 (1) CBO (2)RBO 和CBO相比,RBO是有其明显权限的。在使用RBO的情况下,执行计划一旦出了问题,很难对其做调整。另外,如果使用了RBO则目标SQL的写法,甚至是目标SQL中所涉及的各个对象在该SQL文本中出现的先后顺序都可能影响RBO执行计划的选择我,...
  • lovedieya
  • lovedieya
  • 2015-02-03 00:10
  • 1483

Picking Tutorial

 http://www.lighthouse3d.com/opengl/picking/
  • embededvc
  • embededvc
  • 2008-07-30 10:47
  • 397

C++的Rule of Three

Rule of Three是国外的人提出来的一条法则,可运用于很多行业,在他们看来,数字3代表稳定,也让人觉得舒服。可以把它理解为三者法则,国内也有人翻译为三强鼎立法则。 C++中的Rule of Three指的是析构函数、拷贝构造函数和重载赋值函数三者之间的关系,具体指的是在一个类当中当你需要显式...
  • hmalloc
  • hmalloc
  • 2014-02-19 21:18
  • 1176
    个人资料
    • 访问:4808921次
    • 积分:51472
    • 等级:
    • 排名:第66名
    • 原创:907篇
    • 转载:54篇
    • 译文:5篇
    • 评论:348条