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








Thursday, November 16, 2006

Make a field case insensitive using Forms Personalization

In response to query on Article , how to make Field Case Insensitive for Query.
This can be done via forms personalization.


Comments on "Make a field case insensitive using Forms Personalization"

 

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

Anil,

I am getting a really nice information form your blog.
If you can help me with one problem. I am trying to make the query case insensitive using forms personalization for one field in the navigation Concurrent->Program-> Executable.
I am tryiong to make user_executable_name field case insensitive using forms personalization. I had given the trigger event as When-New-Form-Instance and the in the action tab , they type is property and target object is FND_EXECUTABLES.USER_EXECUTABLE_NAME and property_name CASE_INSENSITIVE_QUERY is given. I have saved the changesa. And i have closed the form and again opened up but it doesnt work. It is still case sensitive. Can you tell me why this is happening??

Regards,
Chirag.

 

Blogger Anil Passi said ... (10:50 PM) : 

Using the help menu check the current property of item? Does it reflect your changes.

also, try doing this in when-new-item-instance of that item too. Althought WNFI should be just fine too

 

Anonymous Anonymous said ... (1:30 PM) : 

Hi Anil,

It worked. I forgot to assign the value to the property.

Thanks a lot.
One more question. Can you provide some information about the srw packages used in Oracle reports. Or from where i can get some information on this?
Generally i have come across thoise kind of sentences in many of the oracle reports.
SRW.USER_EXIT('FND SRWINIT');
SRW.MESSAGE (1000,'Failed in BEFORE REPORT trigger - SRWINIT USER EXIT');
SRW.REFERENCE(:p_profile_name);

And one more,
srw.user_exit (
'FND FORMAT_CURRENCY
CODE=":currency1"
DISPLAY_WIDTH="13"
AMOUNT=":c_extended_price" DISPLAY=":c_extended_price_dsp"
');

Here the currency1 is one column in my select query, and c_extended_price is the formula column, but what does this sentence actually do??

Regards,
Chirag

 

post a comment