Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Mapping of shipment substatus in FTI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Mapping of shipment substatus in FTI

Received Response
8
Views
1
Comments
edited Apr 1, 2020 12:09PM in Transportation Management 1 comment

Summary

Oracles offers standard statuswise shipmment report, but need to create sub-status wise shipment report.

Content

Oracles offers standard status-wise shipment report for Transportation Intelligence, but need to create sub-status wise shipment report via using adhoc query.

For example: Shipment Status : Enroute; Sub-Status : ENROUTE_NOT_STARTED Or, ENROUTE_PICKUP_CHECK_IN

Can anyone please guide, in which table sub-status detail is stored in OTM database? or suggest any best practice to create such report?  .

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!