Dcc Does Not Apply The Filter Criteria For Any Custom Sql-Based Saved Queries (Doc ID 1157104.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.1.0 to 6.2.0 - Release: 6.1 to 6.2
Information in this document applies to any platform.

Symptoms

Custom sql queries where the "use in finder" is not checked do not work as expected on the Dispatch screen. Instead of bringing back the expected results, all shipments are shown.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into OTM.
2. Go to Fleet Management --> Dispatch Board.
3. In the Query Pulldown for the Buy Shipment Section, Select a custom sql query and click the arrow.
4. Note all the shipments are returned and not the number expected.



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