Unable to Add Criteria For VC_AWARD_STATUS
(Doc ID 2427333.1)
Last updated on AUGUST 13, 2018
Applies to:PeopleSoft Enterprise HCM eCompensation - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Unable to Add Criteria for VC_AWARD_STATUS, receive error:
'There are no constant values available for this field or expression (139,171)
A list of constants is only available for fields that have translate values or has a prompt table assigned to it.'
The issue can be reproduced at will with the following steps:
1. Navigation: Reporting Tools > Query > Query Manager
2. Create New Query
4. Select EMPLID and VC_AWARD_STATUS
5. Try to add criteria for VC_AWARD_STATUS and select the magnifying glass
6. Receive Error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!