My Oracle Support Banner

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 OCTOBER 09, 2019

Applies to:

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


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.


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.