My Oracle Support Banner

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

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Application Object Library - Version 12.0.4 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.
Reviewed for Relevance 29 Jul 18.

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 selecting the View Output 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'

Changes

 NA

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.