Prompt Table in PeopleSoft
Why Prompt Table Edit does not get triggered when a value is changed through PeopleCode?
Why Prompt Table Edit does not get triggered when a value is changed through PeopleCode?
This happens because a
FieldDefault event on a new row of data does not trigger FieldEdit and FieldChange events due to Performance reasons
. So, the Invalid Value message from the prompt table edit check will not happen when an invalid value is entered through peoplecode however, when the user types an invalid value the FieldEdit and FieldChange events get triggered and the Invalid Value message gets displayed.
So it is left to the programmer to assign right values to the prompt field in FieldDefault. One better approach is to make use of the ExecuteEdits() method and the IsEditError property to make sure only right values are assigned to the record field with Prompt Edit.
Sample Code:
&RECORD.ExecuteEdits(%Edit_PromptTable);
If &RECORD.IsEditError Then
Error "Prompt Table Edit failure";
End-If;
How to find online navigation of a PeopleSoft Component/Page? After opening each PeopleSoft page in Application designer, we find the Peo...
Disclaimer
The PeopleSoft tips and tricks, code samples, examples, solutions, workarounds mentioned in this blog are only the author's views and not that of Oracle or any other products or tools provider. Likewise, opinions or comments expressed by visitors are not endorsed or recommended by the author.
This PeopleSoft blog is a repository of tips and suggestions which are not necessarily Oracle suggested nor the author's employer suggested. Please ensure you follow your organization standards and procedures while implementing the suggestions provided in this blog or any references from/to this blog.
How to find online navigation of a PeopleSoft Component/Page? After opening each PeopleSoft page in Application designer, we find the Peo...