Automatically populate a Descriptive FlexField with Default Value

Here is one of senariors:
Lets say you have 2 Descriptive flexfield segments defined,

one is "Start Date" using value set "LS_START_DATE" and the other segment is "End Date" using value set "LS_END_DATE".

Now when you enter the "Start Date", requirement is to "End Date" to be populated automatically with the value of "Start Date + 365 days".


Use this in end_date field
Select to_char(to_date(:$FLEX$.LS_START_DATE.value,'DD-MON-YYYY')+365) from dual

You will able to achieve

0 comments:

Post a Comment