EBS Customizations (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center