Mapping of shipment substatus in FTI
SummaryOracles offers standard statuswise shipmment report, but need to create sub-status wise shipment report.
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? .