Agreement – Non Printable Character Issue
(Doc ID 545629.1)
Last updated on JANUARY 13, 2020
Applies to:Siebel CRM - Version 7.8.2  and later
z*OBSOLETE: Microsoft Windows Server 2003
Version: 7.8.2 
Database: Oracle 184.108.40.206
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: HP-UX 11i
This document was previously published as Siebel SR 38-3137765351.
We recently upgraded our Siebel SIA environment from 782 to 7823. Our production users have now identified an issue in Agreements generated in the system.
The crux of the issue is that we have an Agreement table which has a column which maps to an Address field which happens to be calculated field. The calculation is not very complex. The field simply concatenates some separate address fields to make a full address – here is the Calculated Value definition for the field XYZ Full Street Address:
[XYZ Street #] + " " + [XYZ Street Name] + " "+ [XYZ Street Suffix] + " " + [XYZ Building] + " " + [XYZ L4 City] + " " + [XYZ L4 State] + " " + [XYZ L4 Country] + " " + [XYZ L4 Postal Code]
For some reason, since the upgrade, the space concatenated with this logic:
+ " " +
Appears in the Agreement word document generated – not as a space, but as a non-printable character. When we look at the formatting codes behind the word document, it tells us this character is not a space, it is something that looks like a degree sign.
The problem with this non-printable character is that now Word does not know where to break the line as it is not a space it is a character, and the result is that our Address text which should span multiple lines is now all one line which carries off the page and is unreadable.
We have tested this issue in all patched environments and the issue exists; however, when we un-patch an environment and try, the issue disappears.
Any support in this matter would be greatly appreciated as this is a Production issue spanning many of our Agreements.
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