My Oracle Support Banner

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.


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


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

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