EGL 9.2: When Trying to Access an Approval Get this Error Message on DB2: "Return: 8601 - [IBM][CLI Driver][DB2] SQL0122N A SELECT statement with no GROUP BY clause contains a column name or expression and a column function in the SELECT clause"
(Doc ID 2801568.1)
Last updated on SEPTEMBER 26, 2022
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When trying to access an approval (clicking on approve or trying to add comments) and error is received.
Error in Application:
Steps
1) Have an approver or a reviewer try to access the approval.
2) Clicking on approve or adding comments results in the errors noted above.
Note: if you ignore the errors and try to add comments, the comments are not saved.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |