Agent SQL Causes SQL Error When WHERE Gets Changed To HERE (Doc ID 749040.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5 to 5.5
This problem can occur on any platform.

Symptoms

-- Problem Statement:
When an Agent issues a Direct SQL Update with the following SQL

DELETE FROM SHIPMENT_REFNUM WHERE SHIPMENT_REFNUM_QUAL_GID = 'SYS REF_NOTIFY COVERING OFFICE' AND SHIPMENT_GID = $GID

2008-11-05 15:45:28.065 56387 Debug Sql DBUpdate: From the given SQL statement, couldn't decide on the entity for performing cache refresh.

Reason: Problems in executing the sub-query

ORA-00933: SQL command not properly ended

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