Tuesday, January 6, 2009

Managing Oracle PLM's User Defined Attributes

In the Oracle Product life-cycle management (PLM), the Operational attributes really are really the attributes that are in the inventory modules which falls under the Inventory>Items>Master Items form and they can neither be created nor destroyed because they are internally created by Oracle.

But any Oracle PLM has the power to go some steps further. A user can define his items by making a user-defined attribute group. The ego_mtl_system_items_b table contains a single record which holds the user defined attributes which are defined within groups in the said table. The user can have a choice from a distinct amount of character, numerical or data columns so he can define the attributes in one user defined attribute group. The attribute groups are tied to the items using the item_id, organization_id, and the attribute_group_id within that table. The user can then have a choice whether to have only one row or record of the attribute group per item or enable multiple row option during the definition of the attribute group. After having defined the attribute group, the user can then create a database view of the attribute group so that it would be a lot easier to find the data.

As to the difference between a single row user defined attribute or multi-row user defined attribute, it is often difficult to state the reason for choosing one over the other but in many cases there are many business reasons that can be cited for creating a single row attribute group. For example, in a single row user define attribute group, a user might create three groups “Certification group”, “Label Group”, and “Legacy Data Group”. The “Certification group” is defined so that it shows what certifications a certain item has. The “Label Group” contains the values of the attribute to be printed on a particular item and “Legacy Data Group” is for bringing oven the item information from the system that Oracles is replacing because they don’t map to the operational attributes.

Using the multi-row user defined attribute allows the user to possess more than one row, record or instance of the attribute group per item record. The user can have the choice of storing additional types of definitions which would depend on the item, organization, attribute group as well as a unique value within the attribute group. Although there is no need for defining an attribute within the multi-row attribute group, it can help doing such in cases when the user tries to mass update the attribute group through Oracle “Web ADI”. One of the circumstances when there is a need for using a multi-row user-defined attribute group is when there is a conditional need for label and the user wants to select from multiple rows of the same attribute group based on the label type. The unique key attribute of the group would be the Labels type so that no items will have multiple rows of the group for the same label type.

But whether single or multi row user defined group is used, both can be controlled at the view or edit by assigning or creating a role that gives access privileges.

39 comments:

小小 said...

心中有愛,才會人見人愛。 ..................................................

3天3頁 said...

你的部落格很棒,我期待更新喔 ........................................

開心唷 said...

pleasure to find such a good artical! please keep update!! ........................................

彬彬 said...

裸體寫真全裸美女圖片色情訊息黃色圖片自拍裸體圖片sex裸露圖片18限85cc a片台灣色情網站免費色情圖一夜激情聊天情色聊天室限制級爆乳女優作愛巨乳學院性愛情慾陰脣一夜情下體網愛聊天鹹濕做愛自拍成人圖庫成人影城性關係視訊情人性影片觀賞裸照淫美成人論壇av寫真自拍裸女貼圖av圖情色性愛貼圖成人vcdsexy辣妹視訊聊天色情視訊淫婦台灣情色論壇丁字褲貼圖免費a片影片淫蕩女人live show男女做愛火辣妹妹激情網愛聊天美女裸照免費色情網站

v奎峰奎峰 said...

haha~ funny! thank you for your share~ ........................................

林守全 said...

Actions speak louder than words. ........................................

彭志文 said...

人不可以求其備,必捨其所短,取其所長......................................................

鍾FeR_Quade0426 said...

good~ keep sharing with us, please....I will waiting your up date everyday!! Have a nice day........................................

志源 said...

I love readding, and thanks for your artical.........................................

誠侑 said...

thank u........................................

佳穎盛卿 said...

It's great!!..........................................

韋于倫成 said...

快下班囉~來幫你加油~~........................................

淑君 said...

讓人流連忘返,真期待新文章發表!........................................

清民 said...

Poverty is stranger to industry.......................................................

家谷 said...

這一生中有多少人擦肩而過?而朋友是多麼可貴啊! ............................................................

walsha said...

Necessity is the mother of invention.............................................................

vickiekurt said...

Beauty, unaccompanied by virtue, is as a flower without perfume...................................................

雅馨 said...

If the quantity is not a lot, I will hand carry..................................................

喜妤 said...

感謝您費心的分享您的生活!讓我也感同身受!

陳隆 said...

Poverty is stranger to industry..................................................................                           

蕙春蕙春 said...

一個人的價值,應該看他貢獻了什麼,而不是他取得了什麼....................................................................

芸茂芸茂 said...

成功多屬於那些很快做出決定,卻又不輕易變更的人。而失敗也經常屬於那些很難做出決定,卻又經常變更的人.................................................................

PearleY建佑 said...

睇完之後覺得有d頓悟..感謝分享...................................................................

吳婷婷 said...

After a storm comes a calm...................................................................

吳婷婷 said...

生活總是起起伏伏,心情要保持快樂才好哦!!.......................................................

宥妃宥妃 said...

此時此刻~祝福您越來越好~健康開心..................................................................

黃威宇 said...

Riches serve a wise man but command a fool.............................................................

林彥以林彥以 said...

實在是太完美了!非常感谢!给心心!(〃ω〃)............................................................

蕙春蕙春 said...

讚啦~~多謝分享!!>ˍ<............................................................

許惠吟許惠吟 said...

所有的東西經分享後,就更為壯大。.......................................................

家許迪 said...

Joy shared with others are more enjoyed.............................................................

惠宛佳桂 said...

It is easier to get than to keep it.......................................................................

凱v胡倫 said...

Pay somebody back in his own coin...................................................................

沈貞李添睿儀 said...

在莫非定律中有項笨蛋定律:「一個組織中的笨蛋,恆大於等於三分之二。」. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

智黃黃黃元 said...

人因夢想而偉大,要堅持自己的理想哦!............................................................

靜錢錢錢怡錢錢錢錢 said...

天生我材必有用,千金散盡還復來。.. .. ............................................................

至馬馬馬馬玄馬馬馬馬 said...

生命的意義,是在於活的充實;而不是在於活得長久。............................. ...................................

孟湖聿軒 said...

你不能左右天氣,但你可以改變心情.................................................................

惠NorrisBradwell041花 said...

Subtlety is better than force. ......................................................................