Pack Order error
We should add client configurations in Omni Magic by providing ClientId created in OMS.
AM2 URLs:
ASIM: https://staging-asim.increff.com/assuremagic2/ui
Staging Oltp:https://staging-oltp.increff.com/assure-magic2/ui
Staging Common: https://staging-common-assure.increff.com/assure-magic2
2. Ack order error
If we get an error as “Request does not match any route” then the URL provided is wrong. Provide the correct URL and verify.
3. Get Shipment Details errors
For the above error Value should be provided as integer (1) but not as double (1.0000). In the above case issue with the field “Quantity” in request.
Date field should be provided in ZonedDateTime format - For Ex: “2022-03-22T10:15:30+01:00Z” or "2022-08-25T08:26:55+00:00"
4. Process to disable Ack call
Go to CIMS --> Client channel --> Turn off Sync orders toggle switch
5. Ack call not triggering
If Ack call is not triggering then Turn ON Inventory sync in CIMS.
6. Inventory sync call functionality
If the Inventory sync call fails to hit the client system for some reason then it will retry for 2 more times and stop syncing for that article. If there is any change in inventory again, then it will try for 3 more times.
7. Ack call for Unfulfillable orders
Ack call won’t trigger for unfulfillable orders. Even if one sub order is fulfillable and other sub order is unfulfillable, Ack call won’t trigger.
8. Internal error in CIMS
If there is an error stating ‘Internal error in CIMS’ and we could see the Client-Channel pair is missing in CIMS, then we have to touch CIMS war.
9. Orders not visible on OMS screen
If orders are not visible on OMS even if the status is Success or 200, then check in Failed orders in CIMS. Orders will fail mostly if Article master and Listings are not uploaded properly for the SKU for which order is placed.
10. Error in closing shipment
Mostly this error will trigger if the values are not provided for mandatory fields or incorrect values. So check if all the mandatory fields are provided with proper values like Zip, Phone number etc.
11. Get Shipping label via RMS
If there is a single shipment then only referenceNo can be passed as parameter. If there are multiple shipments then we have to provide referenceShipmentNo as well.
12. IndexOutOfBounds Exception in RMS Returns
Check if the values are provided correctly. For example, Phone number, Date fields.
13. Error in CIMS while adding Client-Channel pair
If we get an error while selecting a client name in the process of adding a Client-Channel pair in CIMS, then add Users in CHAMP.
14. Unable to turn ON Inventory sync in CIMS
If Inventory Sync toggle button is in default state then add Invex job in CHAMP.
15. Increff cancellation failed
Increff cancellation failed with response: {\"code\":\"BAD_DATA\",\"message\":\"Invalid channelOrderId T3JkZXI6MzQ= against channel VIRGIO and cimsLocationId : null\",\"description\":null}
There are three possibilities of this error -
Order is not present
ChannelId is incorrect
LocationId is incorrect.
16. Return order creation error
While creating Return order, received an exception as NoSuchElementException. Here the issue is due to the wrong pincode. The Drop address pin code should be the same as which is configured for the warehouse address.
17. Error while creating Outward order using partner code
message":"Error From Channel : No partner mapping exists for partnerCode
Check if mapping exists for that particular partner codes and if everything is good check if orderType is correct.
18. While adding the Vendor or Customer we give an address with it then while adding location for vendor or customer we give address. What's the relevance of giving address twice ? Why is address required while creating Vendor/Customer for the first time?
-- Whatever the address we give first time is set as default Vedor/Customer address
19. What is the use of Integration Scheduler ? (Need to be discussed with OMNI wings)
-- Intergration Schedular screen is used to schedule jobs in CIMS
20. How to configure Client's End Point URL ?
-- Client's End Point URL can be configured in Magic URL Config Screen. If the URL name is not present under dropdownlist then the URL has to be configured in OMNI MAGIC2 UI.
21. What is the difference between the ChannelSKUid and ChannelSerialno ?
-- ChannelSKUid: 1st identifier and ChannelSerialno is the 2nd identifier for the Channel. Basically ChannelSKUid is exposed to outer world and all internal communication happens based on ChannelSerialno.
22. What is the use of listing and Article Master in ASIM? (Need to be discussed with OMNI wings)
-- We are able to place orders for the SKUs which do not have Listings and Article Master.
23. What is the use of ack order and sync order in ASIM?
-- Ack Order: To Notify the client about the status of the order
Sync order: It is get_order_status call triggred by client.
24. What is open po and open ro?
-- Open PO: Placing the Purchase Order(Inward Order) without giving any quantity.
Open RO: Placing the Return Order(Inward Order) without giving any quantity.
25. When will be return order posting sent?
--After the order is received and processed in the Warehouse , return order postings are sent.
26. What is trigger for Sales order posting ?
--There are four event types in Sales Order Posting:
-Outward_Order_Create Posting: When the order is created
-Outward_Order_Complete Posting: When the order is dispatched.
-Outward_Order_Partial_Cancel: When the order is partially cancelled.
-Outward_Order_Cancel: When the order is cancelled completely.
27. What are the Credential keys and Credential values?
--Credential key Value pair is of below type:
Key: Username Value: Koskii
Key: Password Value: Koskii@1234
28. What is the difference between Inventory Update and Consolidated Inventory Update ?
--Inventory Update: Updates are sent location wise(Either Store or Warehouse)
Consolidated Inventory Update: Updates are sent for Inventory for all the Warehouses/Stores or Warehouses + Store
29. While adding a channel if the integration type is other then what should be the channel URL?
--Channel URL should be Proxy BaseURL
30. What does the Sync Required checkbox does in the Inventory Screen ?
--If Sync Required checkbox is checked then the Inventory Updates go to ERP automatically else it is to be done manually.
31. Why the details collected in Manifest Screen and Handover Screen same ? (Need to be discussed with OMNI wings)
--
DB Queries
Below are some DB Queries which would be helpful in Integration testing.
OMS
select * from oms.oms_shipping_labels; - To get Shipping Label details like ShipmentId, AWB, DocumentId.
select * from oms.oms_client_sku_pojo; - To fetch Article Masters list.
select * from oms.oms_inventory_quantity; - To fetch the Inventory quantity available for each SKU.
select * from oms.oms_sub_orders; - To fetch Sub-order details.
select * from oms.oms_outward_order_items; - To fetch outward order line items.
select * from oms.oms_area_cluster_mappings; - To fetch Area Cluster mappings.
WMS
select * from wms.wms_wms_order; - To view the order status(Picked, Packed, Cancelled, Completed etc)
select * from wms.wms_item; - To fetch Items that are GRNed and can get ItemId’s list.
select * from wms.wms_gate_entry_lot; - To fetch LotId (boxId).
select * from wms.wms_bin; - To fetch Bin status.
select * from wms.wms_aisle; - To fetch list of Aisles.
CIMS
select * from cims.cims_sku_listing_pojo; - To fetch Listings.
select * from cims.cims_client_channel_pojo; - To fetch Client-Channel pair details.