IBM Sterling WMS/OMS Interview Questions

IBM Sterling WMS Interview Questions?

1. COMPANY NAME: XXXXXX Interview Questions

Interview Date: Dec 2018

• ROUND #1 

1. Tell about yourself
2. What are the challenging part you faced during Upgrade in Sterling WMS
3. How to do Pick FIFO items during Picking.  (Either OOB or custom logic)
4. Purpose of Polymorphism
5. Purpose of Inheritance
6. Different types of JOIN queries taken for Picking, Packing for a particular order
1. Note: Order have 1 shipment but shipment has multiple shipment lines.
7. Which all Standard API's used during Picking and Packing
8. Anything which you did, so exciting?

• ROUND #2
1. Splitter API usage type question
2. Purpose of Wave
3. Purpose of Batching
4. Requirements to add additional columns in OOB table.. How many ways we can achieve this.  Which is efficient way
5. Write SQL query to get total number of shipments processed today?
6. How same user can login into multiple NODEs
7. How many Projects you have worked and how was the learning with one different from other projects?

2. COMPANY NAME: XXXXXX Interview Questions

Interview Date: April 2019

• ROUND #1, ROUND #2 

1. Tell about yourself
2. Explain different ways to do template customization
3. There is a service created under Order Fulfillment process type.  This service needs to configure for BeforeCreateOrder User Exit.  However, while trying to search for this service while configuring the UE (as a service), the service is not listed as part of the result.  What might be the possible reason for this?
4. Explain the usage of Defaulting component with an example.
5. Explain with example how TaskQ based transaction work.
6. How to implement a Dynamic Condition?
7. There is a Time-Sensitive item configured in Sterling.  However, while adjusting inventory for the item via the Sterling's Adjust Location Inventory console screen, Sterling throws an error saying, "Mandatory Parameters missing".  What might be the possible attributes missed during the adjustment operation?
8. There is an API (Extended API)  component in a service named "TestService".  This service has 5 arguments defined.  List the steps for reading these arguments in the Java code.
9. What are the names of the mandatory columns that needs to be present for new custom table?
10. Explain the receipt pipeline (PO-RECEIPT-9)
11. How do we avoid mixing of items belonging to different receipts into same location while completing the putaway from docks to storage locations?
12. While creating an item in catalog Management, can we configure the item as a container? if yes, what is another name for these items?  What are the additional configurations required for these items?
13. There is an order for 300 lines.  Write a code to find the Unique node name and the sum of the ordered quantity using Java.  What Data Structure can be used for better efficiency?

Example: 

<Order>

    <OrderLine Node="node3" Quantity="10" />

    <OrderLine Node="node3" Quantity="20" />

    <OrderLine Node="node4" Quantity="10" />

    <OrderLine Node="node4" Quantity="50" />

</Order>

Expected output: 

node3=30

node4=60

3. COMPANY NAME: XXXXXX Interview Questions

1. How to create agent server in Weblogic ?

2. Draw a rough wave pipeline and explain the statuses involved?

3. Explain the types of location in warehouse layout, mention the usage of these locations in Warehouse?

4. What is Inbound Process?

5. What is type of Inbound order, explain the statuses of an Inbound Shipment?

6. Explain Receipt pipeline statuses?

7. What is Putaway.  What configuration needs to be done to get target location for Putaway?

8. What are the ways we can implement a user exit? Explain the steps involved.

9. What is a Transaction? In context of transaction, explain

• Pickup statuses
• Drop statuses
• Events

10. Write XML to extend table (YFS_ITEM), where this XML should be saved?

11. Write the entity deployer command, why this command is used.  What happens internally when this command is executed and what are the next steps for the changes to get reflected?

12. Can an Outbound Shipment be created without creating order? What is the configuration for that?

13. What is PLA, What are the strategies of PLA?

14. What is ESP? What are the 3 parameters of ESP?

4. COMPANY NAME: XXXXXX Interview Questions

1. What are the various Coding Standard followed in your Sterling projects?
2. What would be your recommendations on Config release?
3. What and all you will validate before give the QA release? Checklist?
4. How would you plan Dev releases and how would you maintain your Dev Environment?
5. Validate the Serials/Tags while performing receiving for Return orders.  What are the Customization that can be done to fullfill this?