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