My Oracle Support Banner

VALIDATE ID Optional Feature Is Turned ON But Location XID Gets Created With "/" Character (Doc ID 2755015.1)

Last updated on MARCH 09, 2021

Applies to:

Oracle Transportation Management Cloud Service - Version 21.1 and later
Information in this document applies to any platform.

Symptoms



ACTUAL BEHAVIOR
----------------------


Restrict External ID (XID) Creation to Valid Characters

The Validate ID feature, when enabled, will validate newly created records in OTM to insure that the external IDs (XIDs) entered do not contain restricted characters. The goal is to restrict the creation of XIDs to containing only numbers, upper-case letters, spaces, underscores and dashes.

The set of restricted characters is: , x > < = / & ? ; # $ ' " \r \n ( )

If a potential XID for a new record contains a restricted character, the transaction will fail. The validation for the XID will be handled for records entered via the XML and/or REST based APIs as well as records entered using the managers.

When the feature is enabled, you will receive a warning message in the managers listed below, if your proposed XID contains a restricted character.

Buy Shipments
Sell Shipments
Location Manager
Order Release
Order Base
Order Movement
Item
Packaged Item
Driver Manager
Itinerary Manager
Rate Offering
Rate Record

This feature is delivered with Opt In set to FALSE/not enabled. The Opt In/Opt Out option will expire with the 22A update.

This feature will eliminate problems caused when invalid characters are used to generate object XIDs.



Steps:


1. Create location xml with Location XID containing "/"
2. Send in the transmission into OTM
3. Location will get created with character "/"

Transmission should have failed as Location XID contains '/' restricted character.

Cause

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
Symptoms
Cause
Solution
References


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