f Get Oracle Apps Traning Here: Case insensitive query in Oracle Apps
Main Menu
Techie or Funcy ?
Prerequisites
Training Index   

Interview Qns
Apps Interview Qns
HRMS Interview Qns

COPYRIGHT
This work is licensed under a Creative Commons -NonCommercial 2.5 License.



About Me

Name:
Location: United Kingdom

The desire to be extraordinary is a very ordinary desire. To relax and to be ordinary is really extraordinary

  • Subscribe for Emails

    • Previous Posts

    Wednesday, November 15, 2006

    Case insensitive query in Oracle Apps

    This is response to a question posted by a comment in Article..Why Is it Called Apps
    Click on the field in question, and click on Help/Diagnostic/Properties/Item



    In the property field, select case insensitive query


    If the value is TRUE, then you will know that Case Insensitive Query is possible on this field.

    posted by Anil Passi at 2:29 AM

    Comments on "Case insensitive query in Oracle Apps"

     

    Anonymous Anonymous said ... (6:25 AM) : 

    hi Anil,

    I after 10 years of Oracle development, now trying to get into apps for that your site is really helping me.

    Now back to the post- When I try to Help/Diagnostic/Properties/Item
    I get an alert asking for Oracle password?

    Thanks!

     

    Blogger Anil Passi said ... (6:53 AM) : 

    Please set profile option "Utilities:Diagnostics" to Yes against your user name

    Thanks
    Anil

     

    Anonymous Anonymous said ... (7:31 AM) : 

    Hi Anil..

    I am now confused as we can make "Case Insensitive query" in two ways..through Object properties and Forms Personalization..
    Whats the difference I will get by implementing these two methods??

     

    Blogger Anil Passi said ... (7:33 AM) : 

    you should use forms personalization to achieve this only when you are modifying an existing Oracle apps form.

    You the forms builder when you are building the screen from scratch

    thanks
    anil passi

     

    Anonymous Anonymous said ... (12:22 PM) : 

    Hi Anil,

    I am new to oracle Apps. You told to set profile option "utilities:diagnostics" to yes against user name. but i could not find this option. can you please tell the steps how to set up this option.

    Thanks

     

    Blogger Anil Passi said ... (11:32 PM) : 

    hi anonymous

    Name of the profile option is "Utilities:Diagnostics"

    do this
    1. go to system administrator
    2. click on profile
    3. search for this profile against your username
    4. set to Yes

    thaks
    anil

     

    Blogger Unknown said ... (8:56 AM) : 

    Hi Anil
    Thanx for this information

     

    Blogger Unknown said ... (12:03 PM) : 

    Hi Anil
    Thanks for the tip..Its a good one.
    I have another clarification. I need to do Forms Personalization in a form where records are displayed only if Ctrl+F11 is used. I need to trap this status of the form and also add a condition.
    This is in AR,
    Receipts-->Remittances, Enter bank details and click Manual Create. No rows are displayed. But if press Ctrl+F11, all the receipts for the bank are displayed. I need to restrict this to the reciepts of the user.
    Pl help.

    Regards
    Anita

     

    Anonymous Anonymous said ... (12:05 PM) : 

    Hi Anil
    Thanks for the tip..Its a good one.
    I have another clarification. I need to do Forms Personalization in a form where records are displayed only if Ctrl+F11 is used. I need to trap this status of the form and also add a condition.
    This is in AR,
    Receipts-->Remittances, Enter bank details and click Manual Create. No rows are displayed. But if press Ctrl+F11, all the receipts for the bank are displayed. I need to restrict this to the reciepts of the user.
    Pl help.

    Regards
    Anita

     

    Anonymous Anonymous said ... (12:05 PM) : 

    Hi Anil
    Thanks for the tip..Its a good one.
    I have another clarification. I need to do Forms Personalization in a form where records are displayed only if Ctrl+F11 is used. I need to trap this status of the form and also add a condition.
    This is in AR,
    Receipts-->Remittances, Enter bank details and click Manual Create. No rows are displayed. But if press Ctrl+F11, all the receipts for the bank are displayed. I need to restrict this to the reciepts of the user.
    Pl help.

    Thanks

     

    Anonymous Anonymous said ... (12:06 PM) : 

    Hi Anil
    Thanks for the tip..Its a good one.
    I have another clarification. I need to do Forms Personalization in a form where records are displayed only if Ctrl+F11 is used. I need to trap this status of the form and also add a condition.
    This is in AR,
    Receipts-->Remittances, Enter bank details and click Manual Create. No rows are displayed. But if press Ctrl+F11, all the receipts for the bank are displayed. I need to restrict this to the reciepts of the user.
    Pl help.

    Thanks in advance

     

    Blogger Unknown said ... (12:59 AM) : 

    Hi Anil,

    Will you please tell me how to attach the AP Remittance Advice workflow to the Oralce Payment.

    Thanks,

    Durai S E

     

    Blogger Mahalakshmi said ... (4:53 AM) : 

    hi anil,



    i want to become good functional+technical consultant....

    but how can u reach this position....give me best suggition?

     

    Anonymous Anonymous said ... (12:31 AM) : 

    Hi Anil,
    I read in one article that customers name should be in uppercase to facilitate easy inquiry of customers, when in fact based on this article, we can set to query case insensitive forms. any comment on this.

    thanks,
    adrian

     

    Anonymous Anonymous said ... (4:27 AM) : 

    previous post is really good and helped me!

     

    post a comment