October 31, 2024

12 thoughts on “User Preferences in Oracle E-Business Suite

  1. Hi.,
    Thanks for the SQL to identify these preferences set at User level.,

    My PL/SQL written returns different value depending upon the TERRITORY settings at User Level.,

    For example TO_CHAR(’20/09/2012′,’D’) returns different value 6 and 7, for user territory settings United Arab Emirates and United States.,

    Are you aware of this.,

    By the way, irrespective, how do I globally set these values to “United States” and hide these through Personalization (Territory)

    any help would be appreciated.,

    Regards,
    Ram
    n_ram@hotmail.com

    1. Hi Ram,

      As an addition on my earlier reply I did some golddigging in my old project files and found a codepart where I probably had the same issue also with deriving the day of the week based on an incoming date.

      I fixed that by using the mod function together with a dummy date. This works independent of the nls_territoty and timezone settings being applied on the session.

      See below:

      SELECT mod(date ‘2012-10-24’ – date ‘1000-01-01’,7)+1 FROM DUAL;

      This will return 1 for a monday, 2 for a tuesday, 3 for a wednesday etc.

      Hope it helps.

      Regards,

      Cyriel

      1. Hi Cyriel,

        thanks for your reply.,

        I do not prefer the previous note of using “Alter Session”, as we need to reset back the time zone carefully and if not lead to other complications within the application., don’t wanna disturb these., as it is doing some job!!

        Let me try SELECT mod(date ‘2012-10-24’ – date ‘1000-01-01’,7)+1 FROM DUAL, within my Function level (Safe game!)

        I will update with the result.,

        thanks again.,

        Best,
        n_ram@hotmail.com

        1. Hi Ram,

          Totally agree with you regarding the ALTER SESSION call…..:-)

          All the best,

          Cyriel

  2. I am not able to set the Client Time Zone for the users. It’s not allowing me to assign any value. I am using system administrator responsibility. Can some one help with this.

  3. Hi,

    I am trying to use TO_CHAR(ael.accounted_dr,’FM999G999G999G999G999G990D00′) but it does not fetch the user preference when the query is executed from host program.
    DO let m know if you have any idea about this issue

    Regards
    Ramesh

  4. Hi,

    Is there any way I can hide the “Preferences” link at site level ?
    We do not want users to play around with these preferences.

    Thanks

  5. Oracle Home Page on the “Preferences” how to automatically clear the value in the Default Start Page, when the attached responsibility access for the user is inactivated. For Example, user has setup his preference start page responsibility as Self services time and page as Time entry, and this responsibility access to the user is enddated, so the same time the value from user preference also need to be remove.

Leave a Reply

Your email address will not be published. Required fields are marked *