Oracle WMS Cloud Web Reports Gen2 – Unable to Generate Sequential S.No. for Grouped Output Rows

Business Requirement

We have created a Web Reports Gen2 report for inbound shipment receipts.

The report displays received items with information such as:

• ib_shipment_dtl.cust_short_text_8 (KANBAN)
• Item / Legacy Part Number
• Received Box Quantity
• inventory_attribute.invn_attr_b
• Qty/Box
• item_characteristics.brand_code
• ib_shipment_dtl.cust_short_text_1

There can be multiple underlying ib_shipment_dtl records for the same Item/Kanban combination. We therefore group the report by Item so that multiple receipt records for the same Item/Kanban are consolidated into a single displayed row.

The grouping and quantity aggregation are working correctly.