Transportation Management
Discussion List
-
Outbound Transmissions is not available for 30 daysSummary: currently in our data base(OTM) we are able to see outbound transmission only for 20 days. could you please confirm what is the policy for Transmission visibili… -
How to insert details into report_log table from Oracle cloud analytics publisherSummary: Project was on on-prem earlier, now it is moving to OTM cloud. BIP reports were implemented in on-prem version as well. Users will run and schedule the reports … -
Unable to stop transmission using Agent (Raise Error) in OTMSummary: We have a requirement to prevent transmission from being sent when required data is missing. Currently, we are trying to achieve this using Agent action (Raise …
-
Fuel Calculation on Chargeable WeightHi, Is there a way to calculate the fuel as an accessorial cost based on the chargeable weight instead of the actual weight? We tried using different cost bases, for exa…
-
Feasibility of config: in case of On-prem to Cloud transformation of BI reportsContext: Migration of BI reports from on-prem OTM solution to OTM Cloud SR already raised: 4-0002467829 In on-prem BI reports, we used PL-SQL packages in oracle database…Reva_Newalkar 13 views 6 comments 0 points Most recent by Reva_Newalkar BI Publisher Learning Center
-
Is there any possibility to track failures caused by Process Create Consolidated Invoice job?Hi Team, Is there any possibility to track failures caused by Process Create Consolidated Invoice job? This is scheduled to run every month, but we don't see an option t…Kotha Phaneendra 24 views 2 comments 0 points Most recent by Kotha Phaneendra Transportation Management
-
Mismatch between Shipment Cost Remark and Voucher RemarkWe observed an inconsistency between Shipment Cost and Voucher data. Shipment Cost ID: 99142264 Issue: The Remark Text value in Shipment Cost differs from the correspond…OTM Puninar 43 views 11 comments 0 points Most recent by Ashok Kalidindi-Oracle Transportation Management
-
Assign Driver on Relay ShipmentWhen I do Relay in-transit action and type the assigned driver it shows up the following error I try to fix this manually by not assigning driver to create relay shipmen…Tag Ahmed Elsharkawy 32 views 7 comments 0 points Most recent by AkshayThakur Transportation Management
-
"Could not get data source connection for :otmoltp" errors on accessing reportsHello All, We are facing errors on accessing reports in OTM starting today morning. The error message says 'Could not get data source connection for :otmoltp'. I have ra…Minu MJ 47 views 10 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
SHIP_UNIT_XID BN rule generates duplicate IDs when adding new Ship Units to integrated ordersSummary: SHIP_UNIT_XID BN rule generates duplicate IDs when adding new Ship Units to integrated orders Content (please ensure you mask any confidential information): I a…Stefano Di Nolfo 26 views 1 comment 0 points Most recent by Mike Eastwick-Oracle Transportation Management -
OTM Parcel External Rating Engine Using REST API Without OBN and SOAP/WSDL.Hi Team, We are trying to configure an External Rating Engine in Oracle Transportation Management (OTM) for Parcel rating using REST APIs, without using Oracle Business …
-
Orders failed in first bulk plan but successfully planned in second bulk planSummary: We’re encountering an issue during bulk planning where some orders fail to plan in the first bulk plan. However, when we attempt to plan the same failed orders …Ayush Gupta-Oracle 57 views 9 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Oracle analytics publisher global functions cannot be viewed or editedHi Team, In on-prem BIP and in cloud Oracle analytics publisher, it is not possible to view or edit the global functions, For cloud BIP, I tried providing full control p…Reva_Newalkar 45 views 8 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Order base invoice workbenchSummary: I tried to create a workbench that contains order base and invoices Content (please ensure you mask any confidential information): I tried to create a workbench… -
Is it possible to have a different sender email ID for inbound integration errors in OTM?Summary: Is it possible to have a different sender email ID for integration errors? From Address Contact set at domain level seems to work only for agent notification an…Kruthika Nataraj 24 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
How to attach two different logos from OTM for tender emails based on certain plant/warehouseSummary: Need to send two different org logos while sending tendering email from otm Version (include the version you are using, if applicable): 24CAnindita - 123 47 views 7 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
OTM Shipment Enroute Status Stuck at ENROUTE_ENROUTE Even After Tracking Events and Invoice GenerateSummary: Shipments in OTM remain stuck at ENROUTE_ENROUTE instead of progressing to ENROUTE_COMPLETED, even though tracking events have been received, actual arrival dat…
-
Is it possible to change the Calendars to 24-Hour Time Format?Summary: Client wants to enter the calendars time in 24 hours format as in the user preferences. Content (please ensure you mask any confidential information): This form…Marie Cazal 12 views 2 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
Multi Pickup Accessorial Cost Configuration in OTMHi All, How can I configure an accessorial cost named MULTI_PICKUP in OTM? I need to add a flat charge of 80€ to the entire shipment only when there are more than 2 pick…
-
DSU ON ALLOCATION_ORDER_RELEASE_D IS NOT WORKINGSummary: I tried to update fee details on ALLOCATION_ORDER_RELEASE_D using the followong query but nothing is getting updated and no query exception UPDATE ALLOCATION_OR…Narayana Rangollu 22 views 9 comments 0 points Most recent by AkshayThakur Transportation Management
-
How to do multi ship unit lines from order base?Summary: Hi team, I am trying to release an order base having one ship unit and two ship unit lines by action→order mgmt→change order→release OB/SU but getting below err… -
Please let us know whether we can add more attribute columns via SR request for SH/IN/OR?Summary: We already utilized all the available attribute fields in the SH/IN/OR table, Please let us know whether we can add more attribute columns via SR request for SH…Harish Venkataraman 13 views 4 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
SS_STATUS_HISTORY using OIC adapter LogisticsSummary: In an integration between an Oracle APEX database and OTM, I'm using the native OIC Logistics adapter to create tracking events, specifically with the SShipUnit…Ángel Uriel Velasco Mejía 13 views 1 comment 0 points Most recent by AkshayThakur Transportation Management
-
There is minor difference of cost of .01 euro with shipment cost and the shipment cost lines addedWe are seeing a issue wherein the shipment cost is lets say 5764.27 EUR but when we try to sum the individual shipment line cost its always 5764.26 EUR. Attaching the sc…Mrugen Sunil Munshi 41 views 7 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Accessorial Cost Calculation on Base Cost + Fuel ChargeHi All, I have a costing issue that I’m unable to solve. For this shipment, I would like the accessorial costs to be calculated not only on the base cost of 580.00 EUR, …
-
How to Configure BN rule for those Tables which doesn't have BN CONTEXTSummary: We need to define BN Rule for Device table as per different contact ID but BN Context doesn't exist for Device table, which is limiting to generate the ID autom…Mukesh Verma 22 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
How to find global SQL on bi publisherSummary: Following an issue with report execution in BI Publisher, I recall that one of your consultants (Ahmed) showed us how to retrieve the query built by the Oracle …Aboutaleb Boutiyarzist 11 views 1 comment 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
GTM_TRANSACTION_GID must be uniqueWhen we are trying to generate the GTM transaction using OTM automation agent with OTM classical function Build trade transaction we are getting the below error [SQL_STA…Chandan R M 11 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
How Oracle cloud Purchasing Integrates with Oracle cloud Transportation Management (OTM)?Summary: How Oracle cloud Purchasing Integrates with Oracle cloud Transportation Management (OTM)? Content (required): How Oracle cloud Purchasing Integrates with Oracle…arunkumar pemmanaboiyana-Oracle 71 views 9 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
How to use decline reason code in agent action decline/withdraw tenderSummary: Currently there is no way in OTM to specify the decline tender reason code while using agent action decline tender or withdraw tender. The decline reason code f…OTM_ideas 53 views 5 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management