My Oracle Support Banner

After Database and Applications Upgrade, Purge Sign-On Audit Data (FNDSCPRG) Program Fails with 'Concurrent Manager encountered an error while running SQL*Plus for your concurrent request <request id>' and ORA-04030 Errors (Doc ID 2880100.1)

Last updated on JULY 24, 2023

Applies to:

Oracle Application Object Library - Version 12.2.6 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.

Symptoms


Upgraded database from 19.6 (Jan 2020 PSU) to 19.11 (Apr 2021 PSU) and E-Business from 12.2.6 to 12.2.10.
After upgrading, when submitting the Purge Sign-On Audit Data (FNDSCPRG) concurrent program, it fails with following error in the request log:

ERROR
---------




Steps to Replicate
----------------------
1.  Login to System Administrator Responsibility -> Request -> Run.
2.  Select the Purge Sign-On Audit Data program.
3.  Click Submit.
4.  When program completes it shows status of Error.
5.  Select View Log button in Request Run form.
6.  Error message is displayed.

Changes

Upgraded database from 19.6 (Jan 2020 PSU) to 19.11 (Apr 2021 PSU) and E-Business from 12.2.6 to 12.2.10.

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.