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

Symptoms

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

Facts:

Steps to reproduce:

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

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
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.