Comments under Termination History and Historic Terminations In HR Views Shows 'oracle.sql.CLOB@' Instead Of Actual Comments. (Doc ID 2152008.1)

Last updated on JUNE 22, 2016

Applies to:

Oracle Self-Service Human Resources - Version 12.2 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.


This note provides a brief overview of

Symptoms

Problem Statement:

 

Comments under Termination Details and Historic Terminations are shown as 'oracle.sql.CLOB@34c7d2c' instead of the actual comments.

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Navigate to 'HR Professional V4.0' responsibility
  2. Select 'HR Views' function.
  3. Under the simple search, search based on Employee Number click Go button.
  4. Select the person, then click View Selected button.
  5. Click 'Termination History' link.
  6. Termination Details shows:
    Comments: oracle.sql.CLOB@34c7d2c
  7. Historic Terminations shows:
    Comments: oracle.sql.CLOB@392a698

Cause

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