R12 E-Business Suite Steps For The System Administrator To Populate Columns SESSION_NUMBER, SPID and PID In Table FND_LOGINS For Auditing Users And Indetifying The E-Business Suite Username Associated With A Database Session PID / SPID (Doc ID 2288005.1)

Last updated on JULY 25, 2017

Applies to:

Goal

E-Business Suite R12 Application Object Library, Basic System Administration Functions Auditing issues

Provide a set of steps to populate the columns SESSION_NUMBER, SPID and PID in table FND_LOGINS.

When attempting to determine an E-Business Suite application username associated with a database session, the columns SPID and PID are empty for all rows on APPS.FND_LOGINS table.

The lack of values in these columns prevents the administrator from determining the usernames associated with database sessions.
 

Solution

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