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

MOSC Banner

12.1.3: Invalid FA_MASSADD_CREATE_PKG

edited Mar 15, 2013 3:51AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 commentsAnswered
Hi :Welcome to the new EBS Patching community.

This thread will address your following question -

After applying set of patches (14273383, 14208483 & 14284509)  in non-production, we noticed that one of the objects were became invalid and details are below.

APPS   FA_MASSADD_CREATE_PKG     PACKAGE BODY

We tried to compile manually and we got following error.

Errors for PACKAGE BODY APPS.FA_MASSADD_CREATE_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
602/7    PL/SQL: SQL Statement ignored
608/13   PL/SQL: ORA-00904:
         "FA_CACHE_PKG"."FAZCBC_RECORD"."ALLOW_UNALLOCATED_LINES_FLAG":
         invalid identifier

608/40   PLS-00302: component 'ALLOW_UNALLOCATED_LINES_FLAG' must be
         declared

Please let us know how to validate the object.
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