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 AUGUST 24, 2021

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information 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


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