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