When Running Audit Cleanup in the FNDSCMON (Monitor Application Users) Form It Generates 'Unable to locate Record on Block' Error
(Doc ID 3050320.1)
Last updated on OCTOBER 07, 2024
Applies to:
Oracle Application Object Library - Version 12.2 to 12.2 [Release 12.2]Information in this document applies to any platform.
Symptoms
On : 12.2.11 version, Basic SysAdmin functions, maintenance
When navigating through the FNDSCMON form to run Audit Cleanup an error 'Unable to locate record on block' is generated.
Patch 33412336: FNDSCPRG: PURGE SIGNON AUDIT DATA PROGRAM FAILS WITH ORA-04030 ERROR has been applied.
The database has been bounced.
The program executables have been relinked.
Invalids objects have been compiled.
The "Purge Signon Audit Data" program is run daily.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in as Sysadmin user.
2. Navigate to Security -> Users -> Monitor
3. Blind Query, CTRL F11 to populate the form.
4. Click button Audit Cleanup.
5. Click OK in response to pop up message.
6. Click OK again for Request ID.
7. See Error returned on the screen.
Changes
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 |