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

MOSC Banner

10182098 : 11.5.10.2 : GL_PERIOD_STATUSES_PKG invalid after Patch

edited Jan 26, 2013 5:48AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
Hi Sekisui : Welcome to the new EBS Patching community.

This thread will address your following issue

This patch brought a new version of package body 'GL_PERIOD_STATUSES_PKG', but made it invalid.
I did not find any related article in metalink.

Compilation Errors:

SQL> alter package GL_PERIOD_STATUSES_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> sho errors
Errors for PACKAGE BODY GL_PERIOD_STATUSES_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
363/25 PL/SQL: Item ignored
363/44 PLS-00302: component 'TRACK_BC_YTD_FLAG' must be declared
366/33 PL/SQL: SQL Statement ignored
366/40 PL/SQL: ORA-00904: "TRACK_BC_YTD_FLAG": 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