Invalid value on valueset — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Invalid value on valueset

edited Aug 21, 2025 1:55PM in Performance Management

Summary:

Invalid value on valueset

Content (please ensure you mask any confidential information):

This is my valueset:


The code is:

FROM:

(SELECT to_number(ID) ID, VALUE NAME, REGEXP_SUBSTR(DESCRIPTION, '(([^)]+))', 1, 1, NULL, 1) DESCRIPTION, 2 SORT FROM PER_PERSON_LIST_V UNION SELECT -1, 'N/A' NAME, 'N/A', 1 SORT FROM DUAL) A

WHERE:
1=1 AND (A.ID = -1 OR EXISTS (SELECT 1 FROM PER_PERIODS_OF_SERVICE POS WHERE to_char(POS.PERSON_ID) = A.ID AND POS.ACTUAL_TERMINATION_DATE IS NULL))

Why do I have this error?

Note: somehow it seems related to different people having the same name, anyway the Person Number should be enough to distinguish

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!