Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Invalids after 12.1.3 patches 12831835 and 14229705

edited Jun 10, 2013 11:29PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓
Hi,


After the application of the patches 12831835 and 14229705 in (En, Fr and Ar), I have got a list of invalid objects as below:

Object_type                      Owner  Object_name
VIEW                                 APPS     IGW_BUDGET_CATEGORY_V
PACKAGE BODY                APPS     IGW_REPORT_PROCESSING

SQL> alter view IGW_BUDGET_CATEGORY_V compile;

Warning: View altered with compilation errors.

SQL> show errors view IGW_BUDGET_CATEGORY_V;
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      ORA-00979: not a GROUP BY expression
SQL> select text from user_source where name='IGW_BUDGET_CATEGORY_V' and line=2 ;

TEXT
--------------------------------------------------------------------------------
-- $Header: igwburps.pls 115.22 2002/11/15 00:28:39 ashkumar ship $
-- $Header: igwburpb.pls 115.41 2002/11/15 00:47:57 ashkumar ship $
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center