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

MOSC Banner

After patch 12794032:R12.AP.B package APPS.AP_ACCTG_DATA_FIX_PKG is invalid and cannot be compiled.

edited Jul 6, 2012 11:49PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 comments
Hi,

package APPS.AP_ACCTG_DATA_FIX_PKG is invalid and cannot be compiled.


12794032:
Patch goes through but APPS.AP_ACCTG_DATA_FIX_PKG is invalid and cannot be compiled.

SQL> alter PACKAGE APPS.AP_ACCTG_DATA_FIX_PKG compile BODY ;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY APPS.AP_ACCTG_DATA_FIX_PKG:

3863/3   PL/SQL: SQL Statement ignored
3863/3   PLS-00394: wrong number of values in the INTO list of a FETCH
        statement

The part that makes the package invalid is:
 OPEN xla_evnt_dtls(l_max_event_id);
 FETCH xla_evnt_dtls INTO l_xla_event_rec;
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