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 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 ?
How does integration scheduler work?
How to configure Client's End Point URL ?
What is the difference between the ChannelSKUid and ChannelSerialno ?
What is the use of listing and inventory in ASIM?
What is the use of ack order and sync order in ASIM?
How can we process partial return in ASIM ?
What is return order,open po and open ro?
What is trigger for return order posting ?
What is trigger for Sales order posting ?
What all flows can be tested in ASIM ?
What are the Credential values and Credential keys?
What is the purpose of the Integration Scheduler?
How to check the Search & Process Outward order in ASIM?
What is the difference between an inventory and
Consolidated Inventory Update.
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?
How does integration scheduler work?
How to configure Client's End Point URL ?
What is the difference between the ChannelSKUid and ChannelSerialno ?
What is the use of listing and inventory in ASIM?
What is the use of ack order and sync order in ASIM?
How can we process partial return in ASIM ?
What is return order,open po and open ro?
What is trigger for return order posting ?
What is trigger for Sales order posting ?
What all flows can be tested in ASIM ?
What are the Credential values and Credential keys?
What is the purpose of the Integration Scheduler?
How to check the Search & Process Outward order in ASIM?
What is the difference between an inventory and
Consolidated Inventory Update.
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.