Issue In Purging Data

(Doc ID 2175882.1)

Last updated on APRIL 29, 2017

Applies to:

Oracle Adaptive Access Manager - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

We are facing issue in Purging data.
We are following doc https://docs.oracle.com/cd/E52734_01/oaam/AAMAD/archpurg.htm#AAMAD4224 and getting below error like below:

-----------------------------------------------------------------------------------------------
BEGIN SP_V_FPRINTS_PROC('Y'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object DEV_OAAM_PARTN.SP_V_FPRINTS_PROC is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

DEV_OAAM_PARTN.SP_V_FP_MAP_PROC
DEV_OAAM_PARTN.SP_VT_TRX_DATA_PROC
DEV_OAAM_PARTN.SP_VT_ENT_TRX_MAP_PROC
DEV_OAAM_PARTN.SP_V_FPRINTS_PROC
DEV_OAAM_PARTN.SP_V_FP_MAP_PROC
-----------------------------------------------------------------------------------------------
DROP INDEX V_ACTION_LOG_SESS_IDX2

ERROR at line 1:
ORA-01418: specified index does not exist

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

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

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

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SP_V_CASE_PROC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

getting above error for:-
SP_V_CASE_HIST_PROC
SP_V_CASE_MAP_HIST_PROC
SP_V_CASE_MAP_PROC
SP_V_ACTION_LOG_SESS_PROC
SP_V_ACTION_LOG_SESS_MAP_PROC
SP_VT_USER_PRF_PROC
SP_USER_NODE_PROC
SP_NODE_PROC
SP_NODE_HISTORY_PROC
SP_USER_DVC_PROC
SP_SESS_ACT_MAP_PROC
SP_VT_DY_ACT_EX_LOG_PROC
SP_ARCHIVE_PURGE_VCRYPT_ALERT
SP_ARCH_PURGE_V_USER_QA_HIST
SP_ARCHPURGE_VCRYPTUSERSHIST
-----------------------------------------------------------------------------------------------

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