Transportation Management
Discussion List
-
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 21 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 17 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 11 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 42 views 7 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
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 21 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 12 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 18 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 72 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 55 views 5 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
Is there a supported way to achieve Tool Tip in OTM Cloud ?Hello, We have a requirement to display tooltips for certain calculated columns on the results and edit screens, so that a specific text message appears when a user mous…Mukesh Verma 21 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
HOW TO SETUP AUDIT TRAIL FOR RATE RECORD?IS THERE Anyone knows about setup audit trail for rate record? thanks in advance.. -
generate document send integrationhello, could we send integration the document content? using agent and send integration. the information also we should attach : voucher_gid, voucher_number (if owner ob… -
Why do "Spot Bid Withdrawal" Notifications sent to Awarded CarriersSummary: We have a scenario where shipment is spot bid tendered to 3 carriers and they have bid their respective amounts. After the bid is awarded, all the carriers are … -
Constraint Order to pick specific Ground Schedule shipmentSummary: We have configured Ground Schedules in OTM, and in our scenario a single order can be eligible for multiple ground schedule shipments. Our requirement is to con…RajamaniSuresh-Oracle 21 views 5 comments 0 points Most recent by MarcD-Oracle Transportation Management -
Does Fedex Webservices support Rate inquiry?Summary: We are currently evaluating the setup of FedEx Web Services directly within OTM. While reviewing the documentation, I came across a note stating: “Rate Inquiry …Jigerdeep Dhillon 11 views 1 comment 0 points Most recent by Ashok Kalidindi-Oracle Transportation Management -
External integration or Tool that helps identify similar or duplicate locations.Summary: Is it possible to either within OTM or via external integration—that helps identify similar or duplicate locations. Specifically, the locations may have the sam… -
How to post Document via REST including binarySummary: Does anyone know how to post a binary part (Base64) for a document via REST? In an XML for a Dcoument you can add base64 in DocContentBinary node, however I can… -
Manual Planning allows Inactive ServprovSummary: Hi We’ve observed that while planning an Order Release using the Manual Planning option, OTM is still allowing selection of deactivated carriers, and the shipme… -
How to Convert a 3-Leg International Shipment to 2 Legs in OTM Without un/reassigning Shipments?Summary: Requirement in OTM to convert an already planned 3-leg international shipment (Drayage → Intermodal → Ocean) into a 2-leg shipment (Drayage → Ocean) due to prod… -
User execute rate_inquiry and encountered error "You do not have rights to query Inco_Term."Summary: I would like to know if anyone has encountered this issue before and were you able to resolve the issue. We have setup a custom menu for "Rate Inquiry" with URL… -
In OTM not able to fetch the Line Items in Parent Invoice from Child InvoicesSummary: In Oracle Transportation Management, we are working with a 3-leg shipment scenario as outlined below: Truckload: Location A → Location B (Service Provider: CPKC…ASHWINI_9876543678 11 views 1 comment 0 points Most recent by Ashok Kalidindi-Oracle Transportation Management -
How to control shipment cost line value upto 2 precision onlySummary: Below cost value is type of accessorial which is result from Rate factor. Its fuel surcharge. Now, there is ask to control this value by 2 decimal Content (plea…VarnitJain 31 views 5 comments 0 points Most recent by Ashok Kalidindi-Oracle Transportation Management -
Why OTM Is allowing to Re Approving Invoice&Generating a Voucher For Full Invoice Amount AgainSummary: Why OTM Is allowing to Re Approving Invoice&Generating for Voucher For Full Invoice Amount Again Content (please ensure you mask any confidential information): …Narayana Rangollu 31 views 7 comments 0 points Most recent by Ashok Kalidindi-Oracle Transportation Management -
Bulk Plan Struck in Open Process even thow its completedSummary: Bulk Plan holds the order movement at Open Process even after its completed status reflecting at font end & back end (DB) Due to this agent getting triggered up…Basroor Ramakrishna Aditya Udupa-Oracle 11 views 1 comment 0 points Most recent by Bilas-Sarkar-Oracle Transportation Management -
Bulk Plan Failure if Orders count exceeds 100Summary: During bulk planning runs involving more than 100 orders, several orders are failing to get planned. However, when the same failing orders are planned individua…Basroor Ramakrishna Aditya Udupa-Oracle 13 views 2 comments 0 points Most recent by Bilas-Sarkar-Oracle Transportation Management -
Order movements not released upon completion of bulk planWe are facing an issue where Bulk plan is completed and Shipments are created but when the Order movements are called from an agent, the process got stuck because still …Ayush Gupta-Oracle 22 views 1 comment 0 points Most recent by AkshayThakur Transportation Management -
OTM Integration Rest API export request issue--Limited no. of recordsSummary: Dear All, We are trying to export the data from OTM database to for building the report.We need help with setting up the asynchronous approach to pull the data.… -
How to control the access for objects deletion in OTM using view ACL assigned to user role.Summary: We are trying to achieve the customer requirement to give complete read access to the OTM application by creating new user role assigned with custom VIEW ACL's.…Vinay Kumar Bandaru 51 views 9 comments 0 points Most recent by AkshayThakur Transportation Management -
Tracking EventsSummary: I'm trying to use OTM API's to update tracking event errors. But when I try to update certain parts of the tracking event like stop info I can't find a way to u…robleySchneider25 21 views 3 comments 0 points Most recent by AkshayThakur Transportation Management