Interview Questions in IBM Sterling WMS - XXXXX Solution

IBM Sterling WMS Interview Questions?

1. COMPANY NAME: XXXXXX Interview Questions

Interview Date: Dec 2018

ROUND #1 

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

ROUND #2

Splitter API usage type question
Purpose of Wave
Purpose of Batching
Requirements to add additional columns in OOB table.. How many ways we can achieve this.  Which is efficient way
Write SQL query to get total number of shipments processed today?
How same user can login into multiple NODEs
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 

Tell about yourself
Explain different ways to do template customization
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?
Explain the usage of Defaulting component with an example.
Explain with example how TaskQ based transaction work.
How to implement a Dynamic Condition?
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?
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.
What are the names of the mandatory columns that needs to be present for new custom table?
Explain the receipt pipeline (PO-RECEIPT-9)
How do we avoid mixing of items belonging to different receipts into same location while completing the putaway from docks to storage locations?
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?
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?