Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, September 12, 2007

Query to get current session timezone from FND views

I got this query from Vasu. This query gives you the current session timezone from Oracle Apps FND views:

SELECT TIMEZONE_CODE
FROM FND_TIMEZONES_VL WHERE UPGRADE_TZ_ID = (SELECT fnd_profile.VALUE('SERVER_TIMEZONE_ID') FROM DUAL)
/

TIMEZONE_CODE
--------------------------------------------------
America/New_York

No comments: