After The Application Of Patch 22868288 Apps Invalid Will Not Recompile
Last updated on APRIL 16, 2018
Applies to:
Oracle Applications DBA - Version 12.2.3 and laterInformation in this document applies to any platform.
Required Code Levels
12.2.3
R12.AD.C.delta.7
R12.TXK.C.delta.7
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
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms