To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Get Started with Redwood for Oracle Cloud SCM
Transportation Management
Discussion List
-
How to release one order base line to one order release automatically?Summary: We want to automatically release an Order base once it is created in OTM. The Order base can have multiple lines and each order base line should create one orde… -
Event triggering with DSU updatesSummary: We have Agent 1 that updates the EARLY_PICKUP_DATE order dates via DSU. We've also created Agent 2, which has an event that triggers when order dates are change…
-
Rate Maintenance download ratesI created rate load definition with rate record structure and it contain single rate cost when I try to download it with rates, it is disabled and it count rate record =…
-
Get Latitude and Longitude automatically from AddressSummary: Can we get the Latitude and Longitude automatically by just providing the address for the locations? Content (please ensure you mask any confidential informatio… -
Need a list of all Oracle SR's Open and ClosedHello All, Is it possible to get a list of all Oracle SR's (Open and Closed) against a specific CSI (Customer Support Identifier)? I can get the list of all SR's from th…
-
How we can get Rate Inquiry (RIQ) results by using XMLHi, Could you please help me to understand how we can achieve Rate Inquiry results through XML for the following scenarios? Rates that are configured to use Order Releas…
-
OTM - How to bundle orders with bigger heights in the same truck to priorize high height trucks useWe have the following 4 orders: - Order 1 -> 280 cm / 3.35 MTON - Order 2 -> 233 cm / 25.08 MTON - Order 3 -> 280 cm / 23.44 MTON - Order 4 -> 233 cm / 2.79 MTON When pl… -
Is there any way to connect OTM db to Power BI?Summary: Hello team, I was exploring the capability of integrating the OTM database with Power BI for visualization, is there any way to do it without any middleware or … -
How to Connect Oracle Transportation Management (OTM) Database to Power BIHi, We need to connect our Oracle Transportation Management (OTM) database to Power BI for reporting purposes. Can anyone guide us through the process or share best prac…
-
Is there any way to merge shipments using agentsSummary: We have requirement to automate the shipment merging ? Is there any way to achieve this using workflow/agents or any other setups ? If you have know how to achi… -
Is there any way re-sequence Shipment stops using agentsSummary: We have requirement where we want to automate the stop re-sequencing using agents. I did check at the shipment agent actions but I didn't see any options to per…
-
How to consolidate two different legs Shipment using bulk planSummary: We have business requirement to consolidate the two different legs shipments into 1 Shipment to make them as Round trip shipment. Highlighted below in the Green…
-
Unable to plan multiple order movements with different Original Leg Positions into a single shipmentWe are trying to plan shipments from order movements, but since, the order movements created from different order release have different Original Leg Positions, while tr…
-
JSON format via Carrier notificationWe are currently trying to migrate our On prem system 6.5.3 to OTM Saas. In one of our solution we are connecting an external System to a carrier by updating the Externa…
-
Why "Respond by" filed is blank even after having tender response time of 2 hrs on tender contact?Summary: "Respond by" filed is not getting updated when we have communication method as "Email" and response time is given as 2 hours on tender contact Content (please e… -
OTM early pickup and early delivery date are not sync with start and end time on shipmentSuppose early pickup date in otm is 10 sep 23:59 and early delivery date is 11 sep 23:59 , when planned into shipment the start time is 10 sep 23:59 and end time changed…
-
where we can get Customer Support Identifier? for OTM and ERPSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unable to create an order movement bundle for order movementUnable to create an order movement bundle for order movement PL/PSR.12837532, order release PL/PSR.ORPSR20250908-0176. Unable to create an order movement bundle for orde…
-
Blocking tunnels and bridgesWe have a requirement to block specific tunnels and bridges in OTM. As per HERE, the tunnel category parameter can be used to block tunnels. However, in OTM this paramet…
-
Suggestion on Integration from OTM CloudSummary: In recent OTM SIG Conference in North America we heard that Oracle is not going to provide new updates to the XML structure and the new updates will only be com…
-
Custom Tender Out XML Profile is not working at Stylesheet ProfileI'm trying to add an additional shipment attribute(attribute5) information into the spot bid email notification(custom Stylesheet) sent to carriers from OTM. Since there…
-
OTM Order release DSU IssueScenario In Order Release, I have two different types of orders: Order1 (arrives first): Fields → Container No, Liner Name, Container Type Order2 (arrives later): Fields…
-
integrate create order release early pickup date early delivery dateintegrate create order release early pickup date early delivery date, i set 09/09/2025, but when entry to otm, it become 11/09/2025, any solution?
-
Getting error when trying to withdraw tender as he shipment or the tender collaboration not correctGetting error when trying to withdraw tender as below. "The shipment or the tender collaboration is not in a correct state for the action to be performed. Status value f…
-
Purging LocationSummary: Does anyone has done purging of the locations in OTM, We have around 52M locations and needs to be deleted from OTM. what would be the best approach to Delete l…
-
Rate Inquiry (RIQ) not returning results for Order Release Refnum-based rates in OTMHi , We are facing an issue where RIQ results are not being returned for rates that are configured to use Order Release Reference Number (Refnum) as the Rate Basis (cond…
-
Can we connect OTM with FDI/FAWSummary: We are trying to build a dashboard with Fusion, WMS & OTM. We were able to create connectors with Fusion and WMS, we are not able to create connection with OTM.…
-
What is "Package Count is Determined By" in rate offering used for?Summary: In Rate Offering, We have a field called "Package Count determined by" - What/where is this field used for and when? Content (please ensure you mask any confide…
-
How to remove/disable edit option from any screen set/manager layout?Summary: Hi team, I want to disable the edit option for rate offering/rate records/service provider. Idea is whenever any user opens a shipment, he should not be able to…
-
How to create a transmission of Consolidate Invoice with related childSummary: Example of invoice consoldated transmission with related child invoices Content (please ensure you mask any confidential information): Hi Oracle, we read a note…