11.5.10.2 : Invalid package CS_WF_ACTIVITIES_PKG applying Patch No. 6241631 (ATG RUP 7)
Hi,
Invalid package CS_WF_ACTIVITIES_PKG applying Patch No. 6241631 (ATG RUP 7)
SQL> alter package apps.CS_WF_ACTIVITIES_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.CS_WF_ACTIVITIES_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
611/9 PL/SQL: SQL Statement ignored
624/35 PL/SQL: ORA-00918: column ambiguously defined
version :
SQL> select text from user_source where name='CS_WF_ACTIVITIES_PKG' and line=2;
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------
/* $Header: cswfacts.pls 115.4.11510.1 2004/08/26 16:34:14 appldev ship $ */
/* $Header: cswfactb.pls 115.27.11510.2 2005/02/22 21:59:03 aneemuch ship $ */
Code creating the error :
SQL> select a.line,a.text
from user_source a , user_errors b
Invalid package CS_WF_ACTIVITIES_PKG applying Patch No. 6241631 (ATG RUP 7)
SQL> alter package apps.CS_WF_ACTIVITIES_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.CS_WF_ACTIVITIES_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
611/9 PL/SQL: SQL Statement ignored
624/35 PL/SQL: ORA-00918: column ambiguously defined
version :
SQL> select text from user_source where name='CS_WF_ACTIVITIES_PKG' and line=2;
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------
/* $Header: cswfacts.pls 115.4.11510.1 2004/08/26 16:34:14 appldev ship $ */
/* $Header: cswfactb.pls 115.27.11510.2 2005/02/22 21:59:03 aneemuch ship $ */
Code creating the error :
SQL> select a.line,a.text
from user_source a , user_errors b
Tagged:
0