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

Setting default value for Profile Item DFF attribute

Accepted answer
32
Views
2
Comments
edited Aug 29, 2020 8:58AM in Career and Succession 2 comments

Summary

Setting default value for Profile Item DFF attribute

Content

Hi Team,

We have created a custom content type with some DFF attributes. In one of the DFF attribute, I am trying to default First Name as default value.

I selected default type as SQL and below SQL statement used to default.

SELECT DISTINCT FIRST_NAME FROM PER_PERSON_NAMES_F WHERE NAME_TYPE ='GLOBAL' AND PERSON_ID =:{PARAMETER.PERSON_ID}

I am getting below error..

The bind variable :{PARAMETER.PERSON_ID} is not valid. (FND-2580)
In application 10022, descriptive flexfield HRT_PROFILE_ITEMS, context SKILL_300000665675332, and segment PersonName, the bind variable :{PARAMETER.PERSON_ID} in SQL default value SELECT DISTINCT FIRST_NAME FROM PER_PERSON_NAMES_F WHERE NAME_TYPE ='GLOBAL' AND PERSON_ID =:{PARAMETER.PERSON_ID} is not valid.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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