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

MOSC Banner

GL_BALANCE_FIX is invalid after 12.1.1 migration

edited Aug 20, 2021 9:56AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓
Hi,

After 12.1.1 upgrade completed, GL_BALANCE_FIX is invalid.

Please suggest a solution.

Thanks,

Lakmal

SQL> alter package GL_BALANCE_FIX compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY GL_BALANCE_FIX:

LINE/COL ERROR
-------- -----------------------------------------------------------------
146/7    PL/SQL: SQL Statement ignored
148/44   PL/SQL: ORA-00904: "ENABLE_SECONDARY_TRACK_FLAG": invalid
         identifier

510/7    PL/SQL: SQL Statement ignored
510/14   PL/SQL: ORA-00904: "TRACK_ENTERED_FUNC_CURR_FLAG": invalid
         identifier

526/7    PL/SQL: SQL Statement ignored
532/16   PL/SQL: ORA-00904: "SET_OF_BOOKS_ID": invalid identifier
553/7    PL/SQL: SQL Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
559/16   PL/SQL: ORA-00904: "SET_OF_BOOKS_ID": invalid identifier

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