My Oracle Support Banner

E-SEC: PSACCESSLOG Shows LOGIPADDRESS As "UNKNOWN" or "JavaClient" (Doc ID 1334041.1)

Last updated on AUGUST 11, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.57 [Release 8.4]
Information in this document applies to any platform.


Still have questions after reading this document? Please post a question to our community: PeopleTools Community

When does the LOGIPADDRESS in the PSACCESSLOG table show an entry of "Unknown" or "JavaClient? What causes this?

Also is there an enhancement request to resize the LOGIPADDRESS field of the PSACCESSLOG. This field contains the reverse DNS entry when available instead of the actual IP address. In a sample of the last 30 days of data approximately 27% of the values in that field are exactly 40 characters long which implies that a large number of those were truncated to fit in the field. Having the reverse DNS entry is nice but is subject to change and may not have a matching forward DNS entry.

Recommended enhancement

1. Create a second field for the Reverse DNS value when available. This field can be VARCHAR2(255) to accommodate most host names.
2. Store only the raw IP address in the LOGIPADDRESS field. 40 characters is sufficient to hold IPv4 and IPv6 addresses.


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.