My Oracle Support Banner

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 later
Information in this document applies to any platform.


When trying to access an approval (clicking on approve or trying to add comments) and error is received.

Error in Application:

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.




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

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