FNDSCPRG Purge Signon Audit Data Program Fails With ORA-01578, ORA-01110 (Doc ID 1459317.1)

Last updated on DECEMBER 20, 2016

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.

Symptoms

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.

ERROR
-----------------------
FND_LOGIN_RESP_FORMS
FND_LOGIN_RESPONSIBILITIES
FND_LOGINS
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'

Cause

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