My Oracle Support Banner

Purging Mechanism for Audit, Mailbox and User Session Related Tables Missing in Scheduler Job (Doc ID 2654221.1)

Last updated on OCTOBER 21, 2021

Applies to:

Oracle Banking Digital Experience - Version 18.3.0.0.0 to 18.3.0.0.0 [Release 18]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Some of the below tables are not getting purged . As a result, volume of these tables keeps on increasing.

DIGX_AL_API_AUDIT_LOGGING

DIGX_CO_MAILBOX_MESSAGE

DIGX_AL_AUDIT_LOGGING_DETAILS

DIGX_FW_USERSESSION

DIGX_CO_MAILBOX_MESSAGE_USER

EXPECTED BEHAVIOR
-----------------------
The above tables should be purged on regular basis to avoid increase in volume in database space.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Check the database for space consumed by respective tables using the below query (the schema name has to be input in place of &owner) -

Changes

 No changes to environment causes this issue. It is a general housekeeping activity that needs to be carried out on regular basis.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.