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.
at

15 comments:

  1. Anonymous6: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!

    ReplyDelete
  2. Anil Passi6:53 AM

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

    Thanks
    Anil

    ReplyDelete
  3. Anonymous7: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??

    ReplyDelete
  4. Anil Passi7: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

    ReplyDelete
  5. Anonymous12: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

    ReplyDelete
  6. Anil Passi11: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

    ReplyDelete
  7. Unknown8:56 AM

    Hi Anil
    Thanx for this information

    ReplyDelete
  8. Unknown12: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

    ReplyDelete
  9. Anonymous12: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

    ReplyDelete
  10. Anonymous12: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

    ReplyDelete
  11. Anonymous12: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

    ReplyDelete
  12. Unknown12: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

    ReplyDelete
  13. Mahalakshmi4:53 AM

    hi anil,



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

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

    ReplyDelete
  14. Anonymous12: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

    ReplyDelete
  15. Anonymous4:27 AM

    previous post is really good and helped me!

    ReplyDelete