Setting default value for Profile Item DFF attribute

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.