Have :$FLEX$.Value_Set_Name choose between its dependent segment
Hello all,
I have created 3 valuesets. Projects, Project_Number, and Task
I am trying to make the Task valueset dependent on either Projects or Project Number , but receiving an error:
APP-FND-01564: ORACLE error 1722 in fdlget
Cause: fdlget failed due to ORA-01722 invalid number
it works if I remove one of the valuesets. Would appreciate help re-writing this.
WHERE CHARGEABLE = 'Y' AND (PROJECT_ID = :$FLEX$.XXPA_PROJECTS OR PROJECT_ID = :$FLEX$.XXPA_PROJECT_NUMBER)
ORDER BY TASK_NUMBER