After The Application Of Patch 22868288 Apps Invalid Will Not Recompile

Last updated on APRIL 16, 2018

Applies to:

Symptoms

E-Business Suite 12.2 Applications DBA, AD Utilities related issues

Attempting to change password with FNDCPASS results in error.

Error:
FNDCPASS apps/******** 0 Y system******  USER sysadmin ******
Log filename : L9874553.log


Report filename : O9874553.out
$ cat L9874553.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS:
+---------------------------------------------------------------------------+

Current system time is 12-APR-2018 05:41:46

+---------------------------------------------------------------------------+

Arguments

FNDCPASS system/***** USER sysadmin *****
+----------------------------------------------------------------------------+
Working...
APP-FND-01564: ORACLE error 4063 in check_apps_parm

Cause: check_apps_parm failed due to ORA-04063: package body "APPS.FND_WEB_SEC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_WEB_SEC"
ORA-06512: at line 1.

On further investigation:

OWNER OBJECT_NAME OBJECT_TYPE STATUS LAST_DDL_TIME
---------- ------------------------------ -------------------- ------- ---------------
SYS FND_WEB_SEC CONTEXT VALID 18-FEB-17
APPS FND_WEB_SEC PACKAGE VALID 21-MAY-17
APPS FND_WEB_SEC PACKAGE BODY INVALID 12-APR-18

6 rows selected.

SQL>
SQL> alter PACKAGE FND_WEB_SEC compile BODY;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY FND_WEB_SEC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2704/1 PL/SQL: Item ignored
2704/54 PLS-00302: component 'C_MG_SHA512' must be declared
2723/1 PL/SQL: Item ignored
2723/68 PLS-00302: component 'C_MG_CURSESSION' must be declared
SQL> alter PACKAGE FND_WEB_SEC compile;

Warning: Package altered with compilation errors.

SQL>

Additional information:

DDIIAI
========
create or replace PACKAGE BODY
/* $Header: AFSCJAV8.pls 120.18.12020000.44 2016/12/08 21:02:37 fskinner ship $
  Generated from AFSCJAVX.pls 115.58
 
 
  create or replace PACKAGE fnd_web_sec AUTHID CURRENT_USER AS
  /* $Header: AFSCJAVS.pls 120.12.12020000.11 2016/02/04 04:21:52 emiranda ship $ */
  /*#
* Security Related Function and APIs.
"

Changes

 Applied patch 22868288

Cause