My Oracle Support Banner

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.

Symptoms

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.'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigation: Reporting Tools > Query > Query Manager
2. Create New Query
3. VC_AWARD
4. Select EMPLID and VC_AWARD_STATUS
5. Try to add criteria for VC_AWARD_STATUS and select the magnifying glass
6. Receive Error


Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.