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 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.

Symptoms

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

Changes

 

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
References


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