Applying Patch 6678700 or Patch 3500000 Pechktsk.Sql Errors with: ORA-00979: Not A Group By Expression
(Doc ID 1083981.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Human Resources - Version 126.96.36.199 to 12.1.1 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
On : 12.1.1 version, Install / Upgrade Issues
When attempting to apply <Patch 6678700> 12.1.1 : Upgrade Patch
when attempting to apply <Patch 3500000> Patch 11i.HR_PF.K
the following error occurs:
ERROR at line 1:
ORA-00979: not a GROUP BY expression
ORA-06512: at line 38
The issue can be reproduced at will with the following steps:
1. Apply <Patch 6678700> or <Patch 3500000> using adpatch.
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