Location Address Line Is Truncating Values Preceding ' " ' Special Character
Last updated on MARCH 12, 2014
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.
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