Pack Order error
We should add client configurations in Assure Magic by providing ClientId created in OMS.
AM2 URLs:
ASIM:https://assure-proxy-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.
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.