This discussion is archived
5 Replies Latest reply: Sep 17, 2013 9:11 PM by Lygine RSS

How to restrict customer records being displayed using 'sales_channel_type' criteria in customer search form at 11g?

Lygine Newbie
Currently Being Moderated

OS: Linux

DB: 11.2.0.3

ERP: 11g

 

Hi There,

 

     I would like to create a new custom responsibility, which the responsibility is having access to Standard Customer Form (ARXCUDCI.fmb) , but I would like to make a restriction in the customer search form is that, everytime the responsibility user search by customer number, customer name, party name or what ever search field, I would like to limit to restrict further of searching criteria where SALES_CHANNEL_TYPE = 'RTL' is allowed to populate the customer records, there rest of customer records are not allowed to search out.

 

    This SALES_CHANNEL_TYPE column is from HZ_CUST_ACCOUNTS table.

 

    I have tried the Form Personalization already, but the customer searching form has too many fields for user to search, therefore form personalization will be putting all over the places in the form. Therefore I saw others recommended of doing "Custom DLL"...may I know for my scenario, how to I go about Customer DLL? or any other more effective solution?

 

   Appreciate if anyone can share your experience related to matter above.

 

Regards,

Lygine

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points