CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Discussions

In 9.2 User login history table F9312 do not show login status.

edited Oct 27, 2019 5:04AM in CNC, DB and Operating System - JDE1 (MOSC) 4 commentsAnswered

JDE 9.2

Tools Release: 9.2.3.4. (recently done T.L update.)

Normally the system table F9312 records login/logoff statuses for all users. 01 status is for login and 02 for logoff.

When logging into a fat client with the "JDE" ID there is no 01 (login) recorded in the table. Just 02 (logoff).  Also, when logging in via a web client in 9.2 the connection does show up, but the login origination is the enterprise server rather than the web server.

Security kernel log show as below.

23698 Wed Oct  2 13:03:00.736856 dbperfrq.c358

OCI0000178 - Unable to execute - INSERT INTO SY920PD.F9312 (SHUSER, SHEVTYP, SHEVSTAT, SHMKEY, SHUSR0, SHPID, SHJOBN, SHUPMJ, SHUPMT, SHDTOFF, SHTMOFF, SHCHGF, SHSECF1, SHSECF2, SHSECV3, SHSECV4) VALUES (:BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center