My Oracle Support Banner

ZRG2611R Script Reports ORA-00979 and ORA-06512 Messages (Doc ID 1947370.1)

Last updated on SEPTEMBER 28, 2017

Applies to:

Oracle Health Insurance Policy Administration - Version 10.14.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 10.14.1.2 version, Usage (Policy)

When Attempting to run script ZRG2611R, the following error occurs:

ERROR
-----------------------
ORA-00979: not a GROUP BY expression
ORA-06512: at "OZG_OWNER.ZRG2611R_CUST_PCK", line 246
ORA-06512: at "OZG_OWNER.ZRG2611R_PCK", line 146


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute ZRG2611R Script.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create overviews of policies for which the premium calculation failed.

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!


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