Not able to login EBS Application || ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"

    Not able to login EBS application after applying Oct CPU patch 

SYMPTOMS

After apply Oct 2022 CPU patch, user not able to change user password through FNDCPASS  

 APP-FND-01564: ORACLE error 4063 in check_apps_parm

ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"

The SQL statement being executed at the time of the error was: begin :r := nvl(fnd_web_sec.get_op_value(:u,:p),'**##_NuLl_##**'); end; and was executed from the file &ERRFILE.

CHANGES

Applying patch OCT 2022 CPU to Release 12.2.4

CAUSE

FND_WEB_SEC package body is invalid

OWNER                          OBJECT_NAME                    OBJECT_TYPE                    STATUS
------------------------------ ------------------------------ ------------------------------ -------

APPS                           FND_WEB_SEC                    PACKAGE BODY                   INVALID
                          

Package body compiled with below error:

QL> alter package FND_WEB_SEC compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY FND_WEB_SEC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
27/15 PL/SQL: Item ignored
27/30 PLS-00201: identifier 'DBMS_CRYPTO' must be declared
214/2 PL/SQL: Statement ignored
214/31 PLS-00201: identifier 'DBMS_CRYPTO' must be declared
216/2 PL/SQL: Statement ignored
216/31 PLS-00201: identifier 'DBMS_CRYPTO' must be declared
SQL>

Execute privilege on DBMS_CRYPTO to apps is missing due to which package body is invalid.

SOLUTION

1. grant execute on DBMS_CRYPTO to apps;

2. Compile the package body

alter package APPS.FND_WEB_SEC compile body;