Key Flex Field & Descriptive Flex Field - Value Set's Options.

 

I) How to Setup - Default Value for a Segment?

Example : 

We have Created EIT with Segment as Employee Name. & In Which Employee Name has to be defaulted automatically based on the FND_Profile Employee Name.

Steps: 

    1.    Create Segment Name Called - Employee Name.

    2.    Click Open

    3.    Click Default Type as SQL Statement.

    4.    Enter the Default Value as 

select FULL_NAME
from per_people_x where 1 = 1
and CURRENT_EMPLOYEE_FLAG = 'Y'
and person_id = FND_PROFILE.value('PERSON_ID')

    5.    Click Save. 

-----------------------------------------------------------------------------------------------------------

 II) How to Setup List of Value - Value Set for a Validation Type Table.

 Example : 

We have created EIT with Segments, In which Values should be Populated from the Table Source.

Family Member Name should be come in LOV against One Segment.

Steps: 

    1.    Create Segment Name Called - Family Member Name.

    2.    Click Value Set

    3.    Value Set Name - XX_PER_DEPENDANTS

    4.    List Type  - List of Values

    5.    Validation Type - Table

    6.    Table Name - per_all_people_f a, PER_CONTACT_RELATIONSHIPS b ,  per_all_people_f c

    7.    Value - C.FULL_NAME

    8.    ID - a.PERSON_ID

    9.    Where/ Order By - a.person_id = b.person_id
and b.CONTACT_PERSON_ID = c.person_id
and sysdate between a.effective_start_date and a.EFFECTIVE_END_DATE
and a.person_id = FND_PROFILE.value('PERSON_ID')

    10.    Click Test & Save.

-----------------------------------------------------------------------------------------------------

 III) How to Input the Previous Segments Value into New Segments.

 Example : 

Planned End Date = 01-JAN-2021

Extension Period = 2 Months

Based on the Selection of the Extension period, New Planned End Date to be Calculated automatically.

Steps :

    1.    Create Segments Names as Planned End Date , Extension Period, New Planned End Date.

    2.    Against New Planned End Date - Click Open

    3.    Click Default Type as SQL Statement.

    4.    Enter the Default Value as 

SELECT add_months(fnd_date.canonical_to_date(:$FLEX$.Probation_End_Date),

to_number(:$FLEX$.Extension_Period)) FROM dual

    5.    Click Save. 

------------------------------------------------------------------------------------------------