1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Data should be displayed on user specific time zone and not on the time zone saved in tables

Discussion in 'Oracle Apps Technical' started by Reddy1082017, Feb 15, 2018.

  1. Reddy1082017

    Reddy1082017 Active Member

    Likes Received:
    Trophy Points:
    Hi Gurus,

    We have a requirement to pull the data from the OAF tables and display on the OAF custom page. But currently, it's displaying what ever the date/time stamp saved in the database but we want the data to be displayed based on the user specific time zone.
    RDBMS :
    Oracle Applications : 12.2.5
    The Profile Option 'Client Timezone' is already Null at Site Level but changed at user level to different timezone other than the DB server timezone, but no change. Still showing the data from DB server timezone.