FNDSCPRG Purge Signon Audit Data Program Fails With ORA-01578, ORA-01110
Last updated on MARCH 13, 2018
Applies to:Oracle Application Object Library - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
When attempting to submit Purge Signon Audit Data concurrent request, it completes with error shown in the request log:
Concurrent Manager encountered an error while running SQL*Plus for your concurrent request <request_id>
When attempting to view the output file by selcting the View Ouptut Button, the following error also occurs.
delete from fnd_logins
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 487, block # 178788)
ORA-01110: data file 487: '+DATA/prd/datafile/apps_ts_archive.304.720876655'
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