Trusted Contributor.. ScottW1 Trusted Contributor..
Trusted Contributor..

Portlet and User Profile Region

I have created a few demand management based portlets with custom datasources  and they work great for my US users.  All of our resources reference the region of "US".  What I have found is some of my international users have used the "Update My Profile" to change thier profile region.  For the users that have done this, the portlets fail due to either date or currency fields (SQL error).

Are there any tips for dealing with this type of data and various regions in SQL queries and datasources?  There are currently about 8 different regions in use.



1 Reply
Outstanding Contributor.. Amishra Outstanding Contributor..
Outstanding Contributor..

Re: Portlet and User Profile Region

hi There,

Try to alter session and keep date format to American.

alter session set NLS_DATE_LANGUAGE='AMERICAN';

see if this helps. 


Ajay Mishra
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.