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

MOSC Banner

After APR2016 ebs psu 22614473 FND_WEB_SEC is invalid

edited Aug 16, 2016 4:23AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓

There were no errors in the patch logs.  After the patch applied successfully i checked invalid objects. There were 56. I compiled using utlrp.sql and all compiled but 1 -- FND_WEB_SEC package body.  I tried to manually compile and I see the following error:

ALTER PACKAGE APPS.FND_WEB_SEC COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show err

Errors for PACKAGE BODY APPS.FND_WEB_SEC:

LINE/COL ERROR

-------- -----------------------------------------------------------------

284/5    PL/SQL: Statement ignored

284/15   PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared

286/5    PL/SQL: Statement ignored

286/5    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' 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