Restrict Change Item Description

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
wenjie
Posts: 30
Joined: Mon Jul 07, 2008 5:42 am
Location: Indonesia

Restrict Change Item Description

Post by wenjie »

I want to restrict changing item description , only someone which have privilage can change the item description in Inventory,

can someone tell me how,

thx
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.

You can use Forms Personalization to do that. As the personalization can be assigned to Users or Responsibilities you can easily allow or disallow the item description changing.

Octavio
wenjie
Posts: 30
Joined: Mon Jul 07, 2008 5:42 am
Location: Indonesia

Post by wenjie »

can u guide me,

thx
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.

This is to be done on the Master Item form (INVIDITM):

-Open the form.
-From the menu, choose Help/Disgnostics/Custom Code/Personalize.
-On the Form Personalization window enter a Seq nr and a description for the personalization.
-On the Condition tab:
Trigger Event-> WHEN-NEW-ITEM-INSTANCE
Trigger Object->MTL_SYSTEM_ITEMS.DESCRIPTION_MIR
On the Context area, enter the users and/or resposibilities to be affected by this personalization.
-On the Actions tab:
Seq->
Type->Property
Language-All

Object Type->Item
Target Object->MTL_SYSTEM_ITEMS.DESCRIPTION_MIR
Property NAme->ALTERABLE (APPLICATIONS COVER)
Value->FALSE

Save your work and close all forms. Then reopen the Master Items window, query an item and see if the description can be changed.

Let me know if it worked.
Octavio
wenjie
Posts: 30
Joined: Mon Jul 07, 2008 5:42 am
Location: Indonesia

Post by wenjie »

THANKS BRO FOR REPLY,
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests