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 JANUARY 26, 2023
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, Request Processing related issues
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