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

MOSC Banner

R12.1.1 After patching 2 invalid objects 1) XLA_CMP_CREATE_PKG 2) FA_XLA_CMP_CREATE_PKG

edited Sep 14, 2012 1:38AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered
Hi,
R12.1.1 After patching 2 invalid objects 1) XLA_CMP_CREATE_PKG 2) FA_XLA_CMP_CREATE_PKG

Details of the packages versions and errors :


SQL> select text from user_source where name='FA_XLA_CMP_CREATE_PKG' and line=2;

TEXT
--------------------------------------------------------------------------------
/* $Header: faxlaccs.pls 120.0 2006/03/06 22:17:16 bridgway noship $   */
/* $Header: faxlaccb.pls 120.0 2006/03/06 22:14:18 bridgway noship $   */

SQL>
alter package FA_XLA_CMP_CREATE_PKG compileSQL> ;

Warning: Package altered with compilation errors.

SQL> select line, text from user_errors where name='FA_XLA_CMP_CREATE_PKG';

      LINE  TEXT
---------- --------------------------------------------------------------------------------
       303
PLS-00382: expression is of wrong type

       303
PL/SQL: Statement ignored

       728
PLS-00382: expression is of wrong type

       728
PL/SQL: Statement ignored
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