"A SQL error occurred" in Fluid Self Service When Accessing the Addresses Page on DB2 Database.

(Doc ID 2408507.1)

Last updated on JUNE 07, 2018

Applies to:

PeopleSoft Enterprise CS Student Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Campus Solutions - All

In PeopleSoft Enterprise Campus Solutions Release 9.2, development environment, when a user attempts to open Addresses page in Self Service an SQL error message is showing - String data right truncation.


ERROR
-----------------------
A SQL error occurred. Please consult your system log for more details. 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as Student
2. Click on Profile Tile > Addresses


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users not able to view address details.

Changes

 

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