FNDSCPRG Purge Signon Audit Data Program Fails With ORA-01578, ORA-01110

(Doc ID 1459317.1)

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