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

MOSC Banner

13806804 11.5.10.2 Invalid FA_INS_ADJUST_PKG after patch 13806804

edited May 15, 2013 9:36PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Lous says:Invalid FA_INS_ADJUST_PKG after patch 13806804:
SQL> alter PACKAGE FA_INS_ADJUST_PKG compile BODY    ;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY FA_INS_ADJUST_PKG:

LINE/COL ERROR
-------- ----------------------------------------------------------------
320/4    PL/SQL: Statement ignored
320/35   PLS-00302: component 'INSERTION_ORDER' must be declared

Invalid FA_INS_ADJUST_PKG after patch 13806804:
SQL> alter PACKAGE FA_INS_ADJUST_PKG compile BODY    ;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY FA_INS_ADJUST_PKG:

LINE/COL ERROR
-------- ----------------------------------------------------------------
320/4    PL/SQL: Statement ignored
320/35   PLS-00302: component 'INSERTION_ORDER' must be declared

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