My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

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

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.