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.

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

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