After APR2016 ebs psu 22614473 FND_WEB_SEC is invalid
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