EBS 11i : Invalid IGW Objects After Database Upgrade From 10gR2 to 11gR2 (Doc ID 1358088.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle Applications DBA - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Grants Proposal - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 14-Feb-2013***

Symptoms

On R11.5.10.2, after having upgraded database from 10gR2 to 11gR2, the following objects were invalid:

IGW_REPORT_PROCESSING
IGW_PRPO_ROLES_DETAILS_V
IGW_PRPO_PERSON_DETAILS_V

Compilation errors were as follows:
For IGW_REPORT_PROCESSING:

PL/SQL: ORA-04045: errors during recompilation/revalidation of APPS.IGW_BUDGET_CATEGORY_V
ORA-00979: not a GROUP BY expression


For IGW_PRPO_ROLES_DETAILS_V:

ORA-00979: not a GROUP BY expression
ORA-04045: errors during recompilation/revalidation of APPS.IGW_BUDGET_CATEGORY_V


For IGW_PRPO_PERSON_DETAILS_V:

ORA-00979: not a GROUP BY expression
ORA-04045: errors during recompilation/revalidation of APPS.IGW_BUDGET_CATEGORY_V

Changes

Upgrade of the database from 10gR2 to 11gR2.

Cause

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 hundreds of Community platforms