IBM Sterling Commerce Interview Question And Answer

Talk to EasyAssistant

IBM Sterling Commerce interview question and answer related to OMS implementation. . .

This page lists down the common interview question and answers on OMS implementation by IBM Sterling Commerce. It has question related to basic customization and advanced business requirment implementation.
Main objective of this page is to guide you to answer interview questions and provide detail usnderstanding on IBM Sterling OMS implementation. Here I documented question and answer from my OMS implementation experience. Many question asked from the project where you have worked on. So go-through your project implementation documents and try to give a thought why those design and implementation decision were taken. You need to read the api documentation and IBM Knowledge centre documentation.

Support Whatsapp No. 7439236696 for any question / suggestion

Previous Page	Next Page

Questions and Answers:

151). What is defaulting? What's the use of it?

152). Have you used Reservation API ?

153). What are the use of triggerAgent.sh vs agentServer.sh

154). Have you worked on inventory feed? what is full sync and delta feed ? How its implemented in OMS

155). Have you used adjustInventory api what is the use of it. Can you do absolute adjustment

156). What is Passthrough?


157). How would you implement or support Gift Packing feature in store for Ship From Store orders?

158). What are the key difference between following 3 apis

• get ATP
• find Inventory
• get Store Availability

getATP: ATP is about making the most efficient use of inventory so that items are not set aside when they could be used to fulfill more immediate demands.

• It gives the inventory picture of an item.
• contains current and future inventory information

getATP does not check inventory out side network (inventory maintained externally). In technical terms it does not call getExternallyInventoryUE.
Sterling recalculate available item quantity at every inventoyr decision point.

• Adhoc quantity enquirey
• Schedule
• Release
• Reservation

findInventory:
TBD
getStoreAvailability:
TBD
159). Have you used OMOC (Order management on the cloud) veriosn? What are the feature added on the OMOC 2.0 version.?
One customer reported that it's taking long time to loging to OMS console? How would be your approach to triage this issue?
160). How to implement Full Sync and Delta inventory feed?

Lets understand what is full sync and delta feed
* Full Sync is Inventory load and Synchronization in Sterling DOM
* Delta Feed is Stock Adjustments in Sterling DOM
Normally SAP (or some other system) sends inventory feed to OMS. Full sync happens once in a day - mainly in the night time. Deltafeed comes near about once in every hour.

For performance reasons, the adjustments is batched into a single XML message, the batch size is configurable, so that it can be tuned for maximum throughput during the performance testing phase. A batch size of 100 is the ideal one.
Mainly this batching is done at IIB Layer(Middleware)
Inventory Synchronization from Full Sync

• An integration server (JVM) reads and processes the messages and loads the data into a temporary table( INVENTORY SUPPLY TEMP)
• There are as many messages sent to the JMS queues as there are <Items> nodes. In order to control the number of those messages, make use of the number of <Item> nodes within each<Items> node appropriately. recommendation is including 100 <Item> nodes within each <Items> node.
• The load Inventory Mismatch API is called to insert the data into the INVENTORY SUPPLY_TEMP table for each <Item> ... </Item> node in the input XML. This data will be processed by the syncLoadedInventory API once the EOF message has been received.
• The sync Loaded Inventory API is used for comparing and applying differences between the inventory supply information in the INVENTORY SUPPLY TEMP table (loaded by the load Inventory Mismatch API) and the inventory supply kept within the system, which is stored in the INVENTORY SUPPLY table.
• Inventory differences will be automatically applied, and inventory supplies in the INVENTORY SUPPLY table will be adjusted based upon the differences.

Inventory Synchronization -Delta Feed
SAP/WMS provides intra-day updates for DOM with delta value for Item-Node combination. SAP will publish the inventory updates to IIB(midedlewire) and DOM will consume the message and update the Item-Node quantity as supply type onhand quantity. It uses adjustInventory api with the Adjustment type = ABSOLUTE. Inventory provided to Sterling will be used as ATP (Available to Promise) for customer orders.
Key APIs:

• load Inventory MismatchThe load Inventory Mismatch api is used for inserting records to the INVENTORY SUPPLY TEMP table and this records are processed by processed by the sync Loaded Inventory api at the time of the inventory synchronization process. If the same inventory supply already exists for the same Yantra Message Group ID in the INVENTORY SUPPLY TEMP table, record will not be inserted.
  input to this API:
  <Items> <Item> <Supplies> <Supply> </Supply> </Supplies> </Item> </Items>
• sync Loaded Inventory:The sync Loaded Inventory api does compare and apply differences between the inventory supply information in the INVENTORY SUPPLY TEMP table (loaded by the load Inventory Mismatch api) and the inventory supply on the oms system, which stores in the INVENTORY SUPPLY table
  Input: <Inventory> <SupplyTypes> <SupplyType/> </SupplyTypes> </Inventory> .
• adjust Inventory - updates inventory data for a SupplyType. The inventory data changes are specified for a ShipNode.Delta feed uses this api. .

161). What is the difference between Primary Enterprise and Parent Organization? Rather what's the use of Primary Enterprise and Parent Organization?

In Sterling Commerce every entity who participate in supply chain is an orgnization and each organization plays a specific role. Enterprise is one such organization in the participant setup who own the business and define the business rule. One business unit is represnted by one enterprise. All other organizations(e.g. DS / Store) who are part of that business unit will follow the business rules defined by the enterprise. When we define a organization(e.g. Store) in participant setup, we need to mention which organization is the Primary Enterprise for the Store(organization of type Node). Along with primry enterprise, also need to define which organizaton is the Parent organization. It inherit the configuration and property for the parent organization.
One sample participant setup has been shown below. In this diagram point to note is that:
For store 71 and DC parent organization is US whereas Primary Enterprise is ABC1 as they follow the business rules of ABC1.
**Parent organization is the organization who won the shipnode.
**All the rules defined in the primary enterprise(if not overrideen) are used during processing.

162). What is the difference between Rebate and Promotion?
Rebates are treated as award and it is stored in PROMOTION AWARD db table.
Promotions are stored in PROMITION db table. Single promotion can result into multiple award. PromotionId needs to be passed woth Awards.
163). Can you tell me the used of the following Transction and in what senario they are used?

• changeRelease
• closeOrder
• ShipShipment
• ShipOrder

164). What is Order Hold. How do you place hold and resolve hold?.
Hold is a feature in Sterling Commerce. Normally we put an order on hold when we want to stop order from further processing and moving towards statuses
Placing an order on HOLD: when we configure hold (order line level hold or order header level hold) , we can mention that at what condition and at what point(event) hold needs to be applied.
If order meet that condition on that point/event, hold is automatically.
Example: We can confgiure in application manager. to have VERIFICATION_HOLD on order create (event) when order total is more than 100$ (condition).
Another way of putting order on hold is through changeOrder API. In the input XML of change order we need to pass Hold status=1100

Resolving an order on HOLD:

• Through custom agent,. We can create an custom agent derived from ProcessOrderHoldTye base transaction and implementing the PROCESS ORDER HOLD UE.
• Applying changeOrder api. Just need to pass hold type and hold status="1300"

. Note: There is a OOB agent(ProcessFraudCheckHold) to process FRUAD hold. This OOB agent also derived from ProcessOrderHoldTye
165). Is business rules are defined at DocumentType or ProcessType?.
Business rules are defined at DocumentType level (e.g. sales order 0001) for an enterprise.
166). Can I change the defualt document types (e.g. 0001 for sales order)?.
Yes.
167). What is chained order and what is derived order?. what is tired order?
168). What are the differences between ExceptionType, ExceptionTypeRole and OrganizationExceptionType?
169). What is process monitor and order aging?

170). What is inventory synchronization?
It's the realtime co-ordination between supply and demand.

171). What is ATP rule?
its tells us which supplies can be consider which demands. Chase board like configuration in configurator. One side all supplies and other side all demads. Then check the checkboxes which are applicable.

172). Have you created any custom transaction? Can we add event on the custom transact? How proudct will know when to raise the event for your custom transaction?
Yes. I have created custom transaction.

I can add event in the custom transaction. It' fully supported by product. But product will not raise the event for my custom transaction. Programaticlly in can invoke raiseEvent api to raise the event of my custom transaction. What ever action I put in the event will be triggered if I invoke raiseEven api with transactionId and eventId.

173). Can I add condition in pipeline?
Yes we can have condition in pipeline. And condition is executed(evaluated) as part of the transaction. If condition throws exception, transaction will also be rolebacked.


174). Customer Requirement: One US retailer told that very frequent their customer place collect in store (store pickup) order in their e-commerce site and next day they call the customer care center and request the customer care representative to deliver their items to their home address as they will not be able to go to the store to pickup/collect their order without cancelling the order.
How would you address this customer problem?

175). What are the differences between notes and instructions?


176). What are the differences between notes and instructions?


177). What is line relationship type? What is the use of it
Two line relationship for accessory and service line.

178). Have you used split line and change release api. is there any thing common in this two apis.

179). What are the differences between sourcing rule and scheduling rule.

180). What is fulfillment rule?

181). What is financial rule?

182). If you run an agent with 5 threads, will bioth the method getJobs and executeJobs will be run by 5 threads or only executeJobs??

183). In a task based custom agent can you override the getJobs method?

184). In a task based custom agent can you override the getJobs method?

185). One customer wants their sterling user to be authenticated using their Active Director (LDAP Server). How do you implemented it?

186). What is shipment Consolidation and release consolidation
187). What is Physical Kit and what is dynamic kit?
188). Difference between bundle and Kit? How inventory is maintained for kit and bundled
189). Difference between bundle and Kit? How inventory is maintained for kit and bundled

190). One furniture retalier wants to sell chair as an independent item as well as a dining set with a dining table. How do you maintain inventory and do you show availabilty to ATG?

191). One furniture retalier wants to sell chair as an independent item as well as a dining set with a dining table. How do you maintain inventory and do you show availabilty to ATG?


192). What is transaction and how many type of transactions are there?


193). Difference between getOrderList and getOrderDetails api?

194). What are the organization available in Sterling?

• Hub
• Enterprise
• Buyer
• Seller
• Carrier
• Node

195). What are the difference between transction and api?
196). What are the difference between Exception and Alert?

197). What is chargeConsolidation??

198). What is processOrderCollection??

199). What is recordCollection??

200). How do you record external charges?

---

---

Support Whatsapp No. 7439236696 for any question / suggestion

Previous Page	Next Page

Post Your Comment: