Skip to content
Order dates are not in the pastIncoterms are providedSource location includes a postal code
If any validation fails, the order should be placed on hold and the UI must display a specific reason for the failure. What is the best way to configure this validation and hold logic in OTM?
OTM Interview QNA (Almost all topics covered)by Tushar Kukreja
Oracle Transportation Interview Questions for absolute beginner.
Last edited 44 seconds ago by Tushar Jairam Kukreja.
Add new question
Category
Interview Question
Answer
Asked In
MFA
Answered
Basics & Direct
Can you run us through the end to end Process in OTM starting from Order Management to Settlement of the invoice?
Open
Industry Standard
Basics & Direct
What is 3PL & 4PL?
Open
TCS
Infosys
Basics & Direct
How will you explain the capability of OTM to a person who doesn’t understand it at all?
Open
For Practice
Basics & Direct
What is the importance of involved party contacts and involved party locations in OTM?
Open
For Practice
Basics & Direct
How to tell OTM not to pick an order for bulk planning?
Open
TCS
Infosys
Tietoevry
Hitachi
PwC
Basics & Direct
How do you ensure you filter records returned by finder set?
Open
For Practice
Basics & Direct
Can you explain how would you assign a fully functional but customized ‘Shipment Management’ menu to an user?
Open
For Practice
Basics & Direct
How do you ensure an Invoice handler can only see invoices and not shipment in OTM?
Open
For Practice
Basics & Direct
What is Business Monitor?
Open
Infosys
Basics & Direct
What actions are to be done if a message is stuck in FRESH or STAGED status?
Open
Birlasoft
Infosys
Hitachi
Basics & Direct
What is object lock?
Open
Deloitte
Basics & Direct
How objects can be locked in OTM? r
Open
Deloitte
Basics & Direct
How object lock works in OTM?
Open
Deloitte
Basics & Direct
How to tackle performance based issues in OTM?
Open
TCS
Infosys
Birlasoft
Basics & Direct
What is the purpose of Accessorial Cost? Why is there two places to define accessorial cost on the shipment?
Open
For Practice
Basics & Direct
What is Item & Packaged Item, Difference Between Item & Packaged Item
Open
Industry Standard
Oracle
Basics & Direct
What is significance of Location Role in OTM
Open
Industry Standard
Oracle
Order Management
In how many ways you can build a shipment
Open
Industry Standard
Order Management
What are the different ways to release an Order Release from an Order Base in OTM?
Open
Wipro
Tietoevry
Dell Technologies
Order Management
What is Palletization in OTM?
Open
Dell Technologies
TCS
Oracle
Order Management
What is Order Release? & Difference Between Order Release & Order Base
Open
Industry Standard
Order Management
What is Order Movement?
Open
TCS
Infosys
Wipro
Order Management
What is Date Emphasis?
Open
Industry Standard
Order Management
What is Ship With Group in OTM?
Is Ship With Group a soft constraint or a hard constraint?
Open
Wipro
Order Management
What is order bundling? Types of Bundling
Open
For Practice
Order Management
Difference between source location and plan from location
Open
For Practice
Order Management
What is the use of order split functionality
Open
For Practice
Order Management
Explain Order Configuration
Open
Industry Standard
Order Management
What is line item & Ship Unit
Open
Oracle
Wipro
Order Management
What is the difference between the Early Pickup/Delivery date v/s late Pickup/Delivery date?
Open
For Practice
Order Management
What is equipment, equipment group & equipment group profile?
Open
For Practice
Order Management
We have orders with multiple lines but no Ship Unit details. We need to automatically build Ship Units (pallets) based on pallet capacity. How do you generate the Ship Unit and what is the setup?
Open
Birlasoft
Deloitte
Wipro
Shipment Management
What are the definition of Itinerary, its various types, the advantages of using an Itinerary, and the process for creating one?
Open
Industry Standard
Shipment Management
1. How do you setup an itinerary for multi stop?
Open
Industry Standard
Shipment Management
What is Shipment?
Open
Industry Standard
Shipment Management
Buy Shipment V/s Sell Shipment
Open
Industry Standard
Shipment Management
In OTM, what is the purpose of the Primary Leg in an itinerary, and how is it used during planning?
Open
Wipro
Shipment Management
In OTM, how do event dates get reflected on a shipment, and what controls when and how these events update the shipment timeline?
Open
For Practice
Shipment Management
How can we modify event dates from shipment level?
Open
Deloitte
Shipment Management
What is Tendering in OTM?
Open
Industry Standard
Contract & Rate Management
Rate upload tables in order in OTM , and in which table we set up the sequence
Open
Industry Standard
Contract & Rate Management
What is RATE_GEO, RATE_OFFERING table, What is X_LANE, What is RATE_GEO_COST and RATE_GEO_COST_GROUP
Open
Oracle
Deloitte
Hitachi
PwC
Contract & Rate Management
What is Rate Inquiry?
Open
Industry Standard
Contract & Rate Management
What is RateOffering?
Open
Industry Standard
Contract & Rate Management
What is Rate Record?
Open
For Practice
Infosys
Contract & Rate Management
What is Rate Costs in Rate Record?
Open
Birlasoft
Tietoevry
Infosys
Contract & Rate Management
What is Rate Service?
Open
Deloitte
Wipro
Oracle
Contract & Rate Management
What is Rate Preference?
Open
TCS
Deloitte
Dell Technologies
Contract & Rate Management
What types of Rate offerings are there?
Open
Deloitte
Infosys
Contract & Rate Management
How can we define rate cost for different limits of weight?
Open
TCS
Infosys
Birlasoft
Wipro
Contract & Rate Management
Can we build shipment(s) without Rates defined?
Open
Birlasoft
Deloitte
Oracle
Hitachi
PwC
Contract & Rate Management
What is a Commitment Allocation and Why Should You Use It?
Open
Birlasoft
For Practice
TCS
Contract & Rate Management
What is Rate Factor & Rate Quality
Open
Tietoevry
Infosys
Dell Technologies
Contract & Rate Management
How does OTM determine which rate to pick when multiple rate offerings exist?
Open
Tietoevry
Dell Technologies
Contract & Rate Management
How can I configure freight charges in OTM based on the shipment’s actual transit time? Which rate basis configuration should I use, and where in OTM do I set this up?
Open
Wipro
OTM Technical
Difference between For & For Each in Agent
Open
Oracle
Wipro
Dell Technologies
OTM Technical
Could you elaborate on whether it's possible to include multiple Saved Queries within one Saved Condition, or vice versa?
Open
Oracle
Hitachi
OTM Technical
In a scenario where a single saved condition encompasses two saved queries, with one producing a true output and the other a false output, what would be the resulting final output, and what are the underlying reasons for this specific outcome?
Open
Infosys
Oracle
Hitachi
OTM Technical
What is needed to define a VPD?
Open
TCS
Infosys
Oracle
Hitachi
OTM Technical
What are the different options available in the IF clause within an agent in Oracle Transport Management (OTM)?
Open
Deloitte
Oracle
Hitachi
PwC
OTM Technical
How can you manage clauses AND/OR in Oracle Transport Management (OTM) for better condition handling?
Open
Oracle
Hitachi
PwC
Tetra Pak
OTM Technical
How would you configure OTM to automatically tender shipments only for specific carriers or modes?
Open
Infosys
TCS
Deloitte
Wipro
OTM Technical
What is the significance of the OR relationship between saved queries in a saved condition in OTM?
Open
Oracle
Hitachi
PwC
OTM Technical
How can you achieve multiple criteria within a single saved query in OTM?
Open
Infosys
Deloitte
PwC
Hitachi
Oracle
OTM Technical
What is the role of Complex Expressions in handling complex conditions in OTM?
Open
Birlasoft
OTM Technical
What is threshold?
Open
Deloitte
OTM Technical
Agents - Frequently Used Actions R
Open
Industry Standard
OTM Technical
What is the use of VPD predicate?
Open
Dell Technologies
Hitachi
OTM Technical
What is Transmissions & Transactions? What are the statuses of Transmission?
Open
Industry Standard
OTM Technical
What are workflow parameters and how are they configured?
Open
Industry Standard
OTM Technical
Difference between adhoc log and user log
Open
Industry Standard
OTM Technical
What is XML Schema Validation (OLD Version question)
Open
Infosys
For Practice
OTM Technical
How to tackle performance based issues in OTM? (B)
Open
Industry Standard
OTM Technical
If same bulk plan is taking more time than before, how can we check and fix?
Open
Deloitte
PwC
OTM Technical
What are Domain Grants?
Open
Dell Technologies
Oracle
Hitachi
OTM Technical
How do you configure glog properties for the Audit Trail
Open
For Practice
Oracle
OTM Technical
How does OTM integrate with external systems using REST and SOAP APIs?
Open
Tietoevry
Deloitte
Wipro
Oracle
Tetra Pak
OTM Technical
What is external System?
Open
Industry Standard
OTM Technical
What is Out XML Profile in OTM?
Open
Industry Standard
OTM Technical
In saved condition how saved queries will work? what happen if my first query won't give any result.
Open
Infosys
OTM Technical
What is data query?
Open
Tietoevry
OTM Technical
Explain end-to-end how you set up an inbound order integration in OTM.
Open
Tietoevry
Deloitte
Wipro
Birlasoft
Infosys
PwC
OTM Technical
How do you send reports from agents ? need step by step setup how do you trigger report from agent?
Open
TCS
Birlasoft
Infosys
Hitachi
Wipro
OTM Technical
How do you create and schedule an Automation Agent? Give an example of a custom one.
Open
For Practice
OTM Technical
We have three users from three different regions, and each user should only be able to view shipments from their own region. They must not see shipment data belonging to the other regions. How many VPD profiles are required in OTM to enforce this region-based data visibility?
Open
Trinamix
OTM Technical
Most Commonly used Automation Agent Actions used in OTM
Open
Industry Standard
Financials
diff between accessorial and secondary charge
Open
Infosys
Financials
What is Match Rule?
Open
Tietoevry
Birlasoft
Financials
What is Match Rule Profile?
Open
Wipro
Financials
What are Types of Invoices in OTM?
Open
Industry Standard
Financials
What is the purpose of allocation rule?
Open
Dell Technologies
Oracle
Hitachi
Financials
Can I create a voucher in OTM without approving the invoice?
Open
Industry Standard
Configuration & Adminstration
Explain Domains in OTM & Why it is needed?
Open
Industry Standard
Configuration & Adminstration
What are flex fields and what are their advantages?
Open
TCS
Tietoevry
Deloitte
Tetra Pak
PwC
Configuration & Adminstration
Can you create a manager layout without a screenset?
Open
Industry Standard
Configuration & Adminstration
What are the definitions of Screensets, Manager layout, Action Manager, Menu Manager, Manage user access, User Manager, User Role, flex fields, VPD, VPD Profile & Power Data in OTM?
Open
Industry Standard
Configuration & Adminstration
What one thing we can add in workbenches to get the issue type?
Open
Industry Standard
Deloitte
Configuration & Adminstration
If we want only some users to perform actions from workbench, how can we restrict that?
Open
Industry Standard
Configuration & Adminstration
How do you configure screen sets and user roles in OTM?
Open
Infosys
TCS
Deloitte
Configuration & Adminstration
In OTM, when using the “Change Service Provider” standard action on the Shipment screen, how can you restrict or hide the cost-related fields so that the user does not see them?
Open
Oracle
For Practice
Configuration & Adminstration
In OTM, if a user does not want to see all the saved queries on the Order, Shipment, or Invoice screens, and instead wants to view only a few selected saved queries (for example, 3–4 specific ones), how can this be configured?
Open
Wipro
Deloitte
Tietoevry
Scenario Based Questions
A shipment is stuck in 'Planned' status but not tendering — how do you investigate?
Open
Industry Standard
Scenario Based Questions
How do you troubleshoot an order failing to plan?
Open
Industry Standard
Scenario Based Questions
For particular service provider order i want dummy rates to be picked up, how you will do that R
Open
Industry Standard
Scenario Based Questions
A user in India wants to access region-related data that user resides in the parent domain. However, the user's roles are configured in the child domain, while the menus are available in the parent domain. How should the setup be configured to enable access in this scenario?
Open
Industry Standard
Scenario Based Questions
In OTM, a shipment currently has Service Provider X, but the associated Rate Offering is linked to Carrier Y. The system is not allowing the carrier to be changed from X to Y, and Carrier Y is not appearing in the selection list. What could be the reason for this, and how can it be resolved?
Open
Tetra Pak
Scenario Based Questions
If I have a requirement to allow creation of a shipment only if the pick-up or drop locations are limited to a certain number and on exceeding this limits allow the shipment to be created with an additional cost to the base cost, how can I model this?
Open
Industry Standard
Scenario Based Questions
We have 5 orders with ShipWithGroup 'A' and 5 orders with ShipWithGroup 'B'. All 10 fit into one truck. Will OTM consolidate them into a single Full Truckload? What is the setup?
Open
Wipro
Scenario Based Questions
When an order is created in OTM, I want to validate that:
Open
Wipro
Scenario Based Questions
We are rolling out OTM for a client with operations in the US, Europe, and APAC. How would you design the Domain structure? Would you go with a single domain or multiple domains, and why?
Open
Industry Standard
Scenario Based Questions
How do you handle Multi-leg and Multi-mode shipments? For example, a move involving a Truck -> Ocean -> Truck?
Open
Industry Standard
Brain Teasers
Explain the end-to-end flow of an Order from an ERP (like EBS or SAP) into OTM and back. Where are the failure points?
Open
Industry Standard
Brain Teasers
How can I find what my expected cost on shipment would be even before I plan the shipment assuming I have valid master data, configurations available with me?
Open
For Practice
Brain Teasers
Does OTM have the capability to read PDF content and store it in the system?
Open
Wipro
Brain Teasers
What is your approach to Order Consolidation? How do you configure OTM to build the most cost-effective full truckloads?
Open
Industry Standard
SQL Query
SQL Interview Question asked in interviews
Open
Oracle
SQL Query
SQL Interview Question asked in interviews
Open
Tietoevry
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.