MSS: FLEX-VALUE DOES NOT EXIST WHEN USING $PROFILE$ REFERENCES IN DFF VALUESETS
(Doc ID 2637872.1)
Last updated on JULY 08, 2024
Applies to:
Oracle Self-Service Human Resources - Version 12.1 HRMS RUP12 and laterInformation in this document applies to any platform.
Symptoms
On R12.1.3 R12.HR_PF.B.Delta.12 version, Manager Self Service -Transfer
When using $PROFILE$ and $FLEX$ references in the where clause of the table validated valueset assigned to a DFF segment,
Performing a Transfer action and changing the valueset dependent field is causing following error:
ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, <VALUE>, N, SEGMENT, <SEGMENT NAME>, N, VALUESET, <VALUESET NAME>
STEPS
The issue can be reproduced at will with the following steps:
1. Define a table validated valueset using $PROFILE$ and/or $FLEX$ in the
where clause and assign it to a People Group segment
2. Using Manager Self Service
3. Click on 'Manager Actions', select the employee
4. Select 'Transfer' function.
5. Change the department and job title and click on next button.
6. Above error Occurs
Note: User is getting error only when changing it using self service form/ not in PUI form
Changes
None
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |