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

MOSC Banner

16876740:R12.IBY.B 12.1.3 Invalid IBY Views after patch

edited Aug 8, 2013 3:21AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 8 commentsAnswered ✓

Linda says:
I noticed that after applying the patch 16876740:R12.IBY.B  I have invalid objects I can not compile this objects with tool adadmin or manually.
These are the errors when I try to compiled:
Files versions? what files do you referred?

SQL>  alter VIEW IBY_XML_FNDCPT_DOC_HEADERS_V compile;
Warning: View altered with compilation errors.
SQL> select line,text from user_errors where name='IBY_XML_FNDCPT_DOC_HEADERS_V';

     LINE
----------
TEXT
--------------------------------------------------------------------------------
        0
ORA-04063: view "APPS.IBY_XML_FNDCPT_DOC_HEADER_V" has errors


SQL> alter VIEW IBY_XML_FNDCPT_DOC_HEADER_V compile;
Warning: View altered with compilation errors.

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