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:

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.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms