Invalids after 12.1.3 patches 12831835 and 14229705
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 $
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:
0