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 MAY 06, 2022

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.


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.

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.