Can the Job Title dropdown be based on Department selected??
We have a requirement to restrict the job titles dropdown value based on the sub-department and sub-department values to be based on department and department dropdown values to be based on a parent department. We need to implement this is in the new position request workflow so that users are present only with accepted combinations of the 4 field values.
In effect we need to implement a hierarchical relationship between four fields within the position structure in Oracle Fusion.
Parent Department (DFF)
Department (Delivered)
Sub-Department (DFF)
Job Title (Delivered)
The goal is to ensure that when a value is selected in the Parent Department field, it limits the available options in the subsequent child fields, following a cascading effect all the way to the Job Title field. Each child field should only display valid values based on the selection made in its parent field.