Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Users Preferred Timezone report
Summary
Listing timezones set up in User's preferences by UserContent
Hello Everyone,
I found this script in one Oracle Support documents but I can't run it as it is showing the tables do not exist.
SELECT FUSER.USER_NAME,
VAL.PROFILE_OPTION_VALUE
FROM
APPLSYS.FND_PROFILE_OPTION_VALUES VAL,
APPLSYS.FND_PROFILE_OPTIONS OPT,
APPLSYS.FND_USER FUSER
WHERE
VAL.PROFILE_OPTION_ID = OPT.PROFILE_OPTION_ID
AND VAL.LEVEL_VALUE = FUSER.USER_ID
AND OPT.PROFILE_OPTION_NAME = 'CLIENT_TIMEZONE_ID'
-- AND VAL.LEVEL_ID = 10004 -- USER LEVEL
-- AND FUSER.USER_NAME = 'XXXXXX';
Do you guys have any idea of why? Or, do you guys know how to generate a list of users and their User's preference -> Regional -> Timezone?
Tagged:
0