R12 E-Business Suite Concurrent Request "Purge Signon Audit Data" Script FNDSCPRG.sql Not Purging All Records For Concurrent Programs Which Have NULL PID, SPID Or LOGIN_NAME

(Doc ID 2328129.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Oracle Application Object Library - Version 12.1.3 and later
Oracle Concurrent Processing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Concurrent Processing,

 

 

 

 

When running the 'Purge Signon Audit Data' ($FND_TOP/admin/sql/FNDSCPRG.sql) request, it is not purging records if PID, SPID or LOGIN_NAME are NULL in fnd_logins.


Also, it is not purging any records from FND_APPL_SESSIONS, as

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