You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to get data in HCM group value sets when passing username of user by using fnd_global

Summary:

I am not getting any data when adding the following line to the query but I can get the data when I hard code the username.

U.username=FND_GLOBAL.USER_NAME

Content (please ensure you mask any confidential information):

I am using a value set for setting up an HCM group.

In the value set, I need to query by the user who has logged in.

I have tried several ways to get the username or user id as follows in the valueset but in vain

  1. (SELECT u.person_id FROM PER_USERS U WHERE
    U.USER_GUID=FND_GLOBAL.USER_GUID)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!