SQL Statement can Not Contain any of the Following Characters: .,"X'><=/&?;#$. (Doc ID 1061866.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.1.0 and later   [Release: 6.1 and later ]
Information in this document applies to any platform.
***Checked for relevance on 21-Dec-2011***

Symptoms

On OTM 6.1 when the following SQL statement is added to an agent an error is displayed:

update order_release set must_ship_direct = 'Y' where order_release_gid = $gid


ERROR
-----------------------
SQL Statement can not contain any of the following characters: .,"x'><=/&?;#$. It also can not end with the following character: )



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to: Business Process Automation > Agents and Milestones > Automation Agent.

2. Click NEW and enter the following:
    ID: Enter as needed.
    Agent Type: ORDER RELEASE
    Event: ORDER - MODIFIED
    Restrictions: USER
    Actions:
    DIRECT SQL UPDATE
SQL Statement: update order_release set must_ship_direct = 'Y' where order_release_gid = $gid

3. Click Save and the error is shown.


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