E-PC: Prompt Table Override Ignored When Validating Field Value
(Doc ID 2827194.1)
Last updated on DECEMBER 09, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.
When entering a value in a field with a prompt table, if the value is not returned by the prompt record as defined on the record field definition, then an error is (correctly) shown.
However, when a Prompt Table Override has been used, if the value is not returned by the override record but is returned by the original prompt record, the value will pass validation and be allowed to be entered.
The issue can be reproduced at will with the following steps:
1. In a PeopleSoft HCM environment, sign in as user "PS"
2. Create new dynamic view.
3. Add SQL Text
4. Go to PeopleTools > Security > Security Objects > Prompt Table Overrides and add a new Prompt Table override for the record
5. Go to Global Payroll & Absence Mgmt > Payee Data > Assign Earnings and Deductions > One Time (Positive Input)
6. Click "Add a New Value" and enter the values.
7. Click on the "Calendar ID" lookup and search for a value.
NOTE: The Calendar ID value is not found which is correct due to the Prompt Table Override
8. Click "Cancel" and type the same value as before into the Calendar ID field
9. Click the "Add" button and note that the Calendar ID value validates and the page opens
10. Don't save and repeat Step 6
11. Enter the "Calendar ID" as random value.
12. Click the "Add" button and note that the Calendar ID value fails validation
Note that the random value isn't returned by the original prompt table.
However, whilst the value used in steps 7 and 8 is returned by the original prompt table it isn't returned by the Prompt Table Override record. If a value is not returned in the lookup prompt, then an error message should be triggered.
This does appear to be the case when the value isn't returned by the underlying prompt table , but not with the Prompt Table Override record.
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