1 person found this helpful
You can use Forms Personalization:
On the Condition enter (pay attention to colon)
Condition->:CUST.SALES_CHANNEL_MEANING_MIR <> 'RTL'
On the Action enter:
Builtin Type-> DO_KEY
Let me know if it worked.
Thanks for your sharing...
I tested the steps above it worked for Customer Name that has been filtered with the condition. But I have concern is that, this form has got 17 searching columns which allow user to search, e.g. country, site, postal code.. Even it has Advance Search Page...I am afraight that Form Personalization for each of the field is not an effective idea to get this done.
Any other ideas ?
The personalization i sent you works in this way:
-It does not matter which field you choose to enter the query.
-If a record is found, when the form opens and the cursor hits the Customer Name field, the personalization looks for the content of the Sales Channel field.
-If the content of this field is different from the 'RTL' string, the form Customers form (ARXCUDCI) is cleared.
Independently from the field you fill to perform the query, is a record is found, the Customer Name field is the first the cursor hits when the form is opened.
Thanks for the tips and clarification. It worked as per expected.
Thanks you very much.
Can this being done by using VPD (Virtual Private Database)? I read certain blog is that, this VPD is controlled over the database level...but when user login to R12 is using APPS schema, I would like only particular responsibility doing the customer restriction.. Any ideas?