Invalid Value Error (13504,91) or (14200,557) When Using a Prompt Table Lookup in PeopleTools 8.55.06 (Doc ID 2154680.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise CS Academic Advisement - Version 9 and later
PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 and later
PeopleSoft Enterprise CS Campus Community - Version 9 and later
PeopleSoft Enterprise CS Student Records - Version 9 and later
PeopleSoft Enterprise CS Student Financials - Version 9 and later
Information in this document applies to any platform.

Symptoms

Scenario 1:

In PeopleTools 8.55.06, when a user attempts to select a value from a prompt lookup table, the following error is returned:

“Field xxx in row # holds an invalid value of xxx. (13504,91)

The current value is an invalid selection for this field. Correct the value or remove the row.

If your system is configured to allow you to save your time for later without validation, you may choose to do so and come back and correct the invalid entry later."

Scenario 2:

In PeopleTools 8.55.06, when a user attempts to run the transaction management process, or CTM, a staging record may result in an Error status with an error similar to the following examples:

(14200,557) Prospect Career - Last School Attended(SAD_PRS_CAR_STG.LAST_SCH_ATTEND)  Invalid value - Check and try again

(14200,557) Constituent - BIRTHCOUNTRY(SCC_STG_CONSTIT.BIRTHCOUNTRY) Invalid value - Check and try again

 

Cause

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 hundreds of Community platforms