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
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
Million Knowledge Articles and hundreds of Community platforms