f Get Oracle Apps Traning Here: Case insensitive query in Oracle Apps

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



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.

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