My Oracle Support Banner

Location Address Line Is Truncating Values Preceding ' " ' Special Character (Doc ID 1634793.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.2.1 to 6.3.0 [Release 6.2 to 6.3]
Information in this document applies to any platform.


When creating Location having Address Lines filled with special character " and saving the data into the database, OTM is ignoring all the other characters that are preceding " by saving only the ones that are following this special character. It seems that when using " it is in fact truncating the data when saving.

It is expected when using the special character " at the address line and saving the data to have the entire data in the database not only what is following the special character.

The issue can be reproduced at will with the following steps:
1. Click Shipment Management/ Location Manager/ New
2. Give a Location Name like BEFORE"AFTER
3. Enter at the address lines the following BEFORE"AFTER
4. Give a Country Code
5. Click on Roles
6. Select a role of ShipFrom/ShipTo
7. Click Save
8. Click Finished
9. Click view

Now you can see the following: at address line AFTER, at location name BEFORE"AFTER. Once we clicked on finished the data that was saved at the address lines was only the one following the special character " while at the Location Name we can see the entire data entries BEFORE"AFTER.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.