My Oracle Support Banner

Getting Error: "ORA-00979: not a GROUP BY expression" When Attempting To Reset Password For Contact (Doc ID 2785382.1)

Last updated on JUNE 17, 2021

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version and later
Information in this document applies to any platform.


When a user attempts to reset their password via the "Forgot Password" function of Supplier portal, the following error occurs:

Exception: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Xeno.Data.DataAccessException: ORA-00979: not a GROUP BY expression


Steps to reproduce:

  1. Try to reset password via the "Forgot Password" function of Supplier portal.
  2. Notice the problem.


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.