Agent Direct Sql Triggers A Cascade Of Select Statements
(Doc ID 429833.1)
Last updated on MARCH 08, 2017
Applies to:Oracle Transportation Management - Version 5.5 and later
Information in this document applies to any platform.
Checked for relevance on 30-Jun-2010
-- Problem Statement:
On V5.5, Find that a direct SQL update with an Update, delete statement triggers a cascade of Select shipments while the insert statement does not.
Expect that the update, delete statements in a direct SQL update statement does not trigger extra select statements
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Set up an agent listening for an external status change on a shipment with two Direct SQL
update actions 1 with an Update statement and 1 with an insert statement
2.Change the external status on a shipment and verify the logs
3. find that the update direct sql update triggers extra select statements and the insert one does not
-- Business Impact:
The issue has the following business impact:
Due to this issue, direct sql updates take quite a long time to complete
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|