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 |