'Firstname Lastname' Not Appears In Message As Documented By Bug 10640792 (Doc ID 1367400.1)

Last updated on OCTOBER 24, 2011

Applies to:

Oracle Thesaurus Management System - Version: 4.5.2 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Goal



Testing the ipatch TMS 4.5.2.22 per <>

Fix for <>
 
According to Oracle Documentation and README above, the fix will report the first and last name of the user holding the lock but at customer site, it displayed only the user ID e.g.

<>

Before
When multiple users work in same activation group, a user may get the message, "ORA-20000: 245700-Record is locked by another session. Click OK."

After
The message now gives the first name, last name, and user ID of the person who has locked the record; for example, "ORA-20000: 1218100-Record is locked by user FIRSTNAME LASTNAME (ops$USERID).
Click OK.



Testing results in the following message syntax:

ORA-20000: 1218100-Record is locked by user  (ops$USERID)




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