Note 1451312.1

We have an identical problem (Customer Inquiry) to that on the above note. The issue (the note states) is down to a db upgrade to 11.5.3. However, users  reported the issue some time ago, but the upgrade went live Nov 2011. They have been using a workround apparently instead of contacting support.
If this is the wrong community, apologies in advance.
In the note there are 2 options, apply the patch 12834800 or alter session <code class="km">_replace_virtual_columns=false<br/>and In the view AR_CUSTOMER_ACCOUNTS_CA, replace:

SUBSTRB(PARTY.PARTY_NAME,1,50)

with:

<font face="Arial">use</font><font face="Arial"> UPPER(SUBSTRB(PARTY.PARTY_NAME,1,50))<br/><br/>I would prefer to apply the latter -less disruption. <br/>Does anyone in this community have an opinion as to the best approach</font><br/>