Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to set a default value for a descriptive flexfield
Summary:
How to set a default value for a descriptive flexfield
Content (please ensure you mask any confidential information):
Hi,
we would like to set a default value for a descriptive flexfield (Flexfield Code PER_ASG_DF; Data Type: Date). We would like that this field was automatically filled in with the Hire date of the employee (SELECT min(effective_start_date) from per_assignment_secured_list_v; furthermore we have to introduce a person_id filter, so that if a person had different work relationships, the field is automatically filled in with the hire date of the first/oldest work relationship).
Tagged:
0