注册 登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

Memory extender

Beautiful Day..

 
 
 

日志

 
 

Item Import问题二 —— 物料属性相关性  

2011-09-29 14:11:39|  分类: EBS |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
通过Interface施行物料导入遇到的问题总结(2)
物料描述的多语言问题参考:
http://hgdzhuanyong.blog.163.com/blog/static/11719138320117553711408/
物料属性中有一部分相互关联的属性,如:
Inventory页签:Inventory Item——>Stockable——>Transactable——>Check Material Shortage
Purchasing页签:Purchased——>Purchasable
Order Management页签:Customer Ordered——>Customer Order Enabled
                                          Internal Ordered——>Internal Order Enabled
等。。
如上面所列,必须启用了前面的属性,后面的属性才可启用。

我们设计的流程是:初次导入时,状态为某个自定义状态,其中的“Under status control”的属性都是unchecked,相当于Inactive。之后在建立成本后,再通过后台运行的Item Import的并发程序将状态更新为Active,以允许进行相关异动等操作。

而如上红色标记的属性,都是“Under status control”的,以就是说,在状态改为Active的时候会自动check上这些属性。
而如果这些属性的关联父属性没有check的话,那么即使状态改为Active,它也不会被check。——这就是要注意的地方。
另外,“Under status control”的那些属性,会根据你导入的状态去决定是否check,不会使用你所塞入中间表的值——即按优先级相互覆盖后的属性值去进行校验(同样,template所带的属性也会被你手动塞入的值覆盖)。

且重要的一点,如果状态是Active,即“Under status control”的属性为checked,但其关联父属性为N,也可以通过,结果为父子全为unchecked(就像在界面更改状态时一样,基础父属性不勾,不会报错,仅不勾相关“Under status control”的属性而已)。
例:Inventory Item——'N'
       Transactable —— 'Y'
       状态               ——'Active'
这样导入的结果,不报错,只是为全'N'————————————出乎意料

只有一种情况会报错,就是:导入时,父属性为“Under status control”的属性,其值为N(状态控制为N)如Transactable,但此时塞入了Check Material ShortageY,会报错,就像在界面上操作将状态由Active改为Inactive时,如下图:
Item Import问题二 —— 物料属性相关性 - Gabriel - Gabriel
 
概括一下,可以这样理解,把操作的切入点、入手点看为更改状态
如果父属性为“否”,则不能带出为“是”的自身属性。
如果子属性(自身的下一层)已经为“是”,则不能不经过它同意就把自身及子属性改为“否“。

就像FORM中Master-Detail的Block一样,在Detail记录存在的情况下,是不能直接删除Master记录的,要先删Detail。


---------------------------------------------------------------分隔线--------------------------------------------------------------------------

附:Item Status Code的Online Help

Status Attributes and Item Status Control

Status attributes enable and disable the functionality of an item over time. Each status attribute allows you to enable the item for a particular use. For example, if you set the status attribute Purchasable to Yes, you can put the item on a purchase order.

The status attributes are related to the item defining attributes. You cannot enable a status attribute if you do not set the corresponding item defining attribute to Yes.

The following table presents status attributes:

Status Attributes

Status Attribute Item Defining Attribute Functional Area / Oracle Product Functionality
Stockable Inventory Item Inventory Allows you to store the item in an asset subinventory.
Transactable Inventory Item Inventory, Order Management, Purchasing, Work in Process Allows you to transact the item in Oracle Inventory, Oracle Order Management, Oracle Purchasing and Oracle Work in Process.
Purchasable Purchased Purchasing Allows you to place the item on a purchase order.
Build in WIP - Work in Process Allows you to build the item on a discrete job, and/or repetitive schedule.
Customer Orders Enabled Customer Ordered Item Order Management Allows you to place the item on a sales order.
Internal Orders Enabled Internal Ordered Item Inventory, Order Management, Purchasing Allows you to create an internal sales order for the item
BOM Allowed Inventory Item Bills of Material Allows you to create a bill of material for the item
Invoice enabled Invoiceable Item Receivables Allows you to create an invoice for the item

You set status control for a status attribute with the Item Attributes Control window.

Interdependences for Status Attributes

Each status attribute is dependent on the value of at least one other attribute. For example, you cannot set Stockable to Yes if you set Inventory Item to No. The following table presents interdependences for the status attributes:

Interdependences for Status Attributes

Attribute Must be set to If
Stockable No Inventory Item is set to No
Transactable No Stockable is set to No
Purchasable No Purchased is set to No
Build in WIP No Inventory Item is set to No OR BOM Item Type is NOT set to Standard
Customer Orders Enabled No Customer Ordered Item is set to No
Internal Orders Enabled No Internal Ordered Item is set to No
BOM Allowed No Inventory Item is set to No
Invoice Enabled No Invoiceable Item is set to No

Item Status Control

When defining an item, you can use the item attribute Item Status to control status attribute values. You determine the list of values for the Item Status attribute by defining Item Status Codes. An Item Status Code has a user-defined set of Yes/No values for the status attributes. The values are applied to the status attributes when you choose an Item Status Code when defining an item. For example, assume you define an Item Status named Prototype with all status attributes set to Yes except for Customer Orders Enabled. Next, you define another Item Status, Active, with all status attributes set to Yes. In the beginning of a product development cycle, assign the status code Prototype to an item so that you cannot place the item on a sales order. Later, assign the status code Active to allow all functions for the item. See: Defining Item Status Codes.

  评论这张
 
阅读(645)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018