3 Reporting
EICS can produce reports for retails to view.
Reports are generated from within the functional areas of EICS and includes information about shipping documentation, delivery reports, pick detail reports and so on. EICS uses a report screen to preview the report by sending the request parameters as report name and required parameter for the corresponding listed reports.
This section covers the following:
EICS Reporting Framework
The following section describes the reporting framework.
Figure 3-1 Reporting Framework
Report Service
The report format type is predefined as pdf format in the client. The report service use REST service calls to access the EICS server.
Security Considerations
Customers should create an IDCS or OCI IAM user and the user should be assigned the following BI IDCS or OCI IAM groups to access the report endpoints.
IDCS or OCI IAM groups required for production environment:
-
BIConsumer
-
BIContentAuthor
-
BIAdministrator
IDCS or OCI IAM groups required for non-production environment:
-
BIConsumer_preprod
-
BIContentAuthor_ preprod
-
BIAdministrator _ preprod
BI Publisher Server
EICS uses BI Publisher as the printing engine. BI Publisher gets the report data from the database by sql and generates the report in pdf format. The following is the workflow for the process of Preview Reports:
-
A retailer makes a request on the JET Client to preview a report.
-
Format type of reports (pdf) which is added to the report detail parameters requested by retailers.
-
The client calls the reporting service to request the REST call.
-
The REST request hit the EICS server and fetch the report configuration from the EICS database to request the BI Publisher.
-
The BI Publisher server receives URLs or parameters, runs a query to retrieve data to be printed, and formats the data.
-
That data is then sent back to the UI as response and reports are download in the pdf format.
Note:
EICS tables (REPORT_TEMPLATE) refer to the report format. The EICS server fetches the report configuration detail from this table.
Report URL Location
The URL Location for each report type:
Table 3-1 Report URL Location
Type | URL Location |
---|---|
Customer Order Report |
<BIP_XMLPSERVER_URL>/SIOCS/CustomerOrder Report/CustomerOrderReport.xdo |
Customer Order Delivery BOL Report |
<BIP_XMLPSERVER_URL>/SIOCS/CustomerOrderDeliveryBOLReport/CustomerOrderDeliveryBOLReport.xdo |
Customer Order Bin Label Report |
<BIP_XMLPSERVER_URL>/SIOCS/CustomerOrderB inLabelReport/CustomerOrderBinLabelReport.xdo |
Customer Order Delivery Report |
<BIP_XMLPSERVER_URL>/SIOCS/CustomerOrder DeliveryReport/CustomerOrderDeliveryReport.xdo |
Customer Order Pick Report |
<BIP_XMLPSERVER_URL>/SIOCS/CustomerOrderP ickReport/CustomerOrderPickReport.xdo |
Customer Order Pick Discrepancy Report |
<BIP_XMLPSERVER_URL>/SIOCS/CustomerOrderP ickDiscrepancyReport/CustomerOrderPickDiscrepancyReport.xdo |
Customer Order Reverse Pick Report |
<BIP_XMLPSERVER_URL>/SIOCS/CustomerOrderReversePickReport/CustomerOrderReversePickReport.xdo |
Direct Delivery Report |
<BIP_XMLPSERVER_URL>/SIOCS/DirectDeliveryR eport/DirectDeliveryReport.xdo |
Direct Delivery AGSN Report |
<BIP_XMLPSERVER_URL>/SIOCS/VendorDeliveryAGSNReport/VendorDeliveryAGSNReport.xdo |
Direct Delivery Discrepant Item Report |
<BIP_XMLPSERVER_URL>/SIOCS/DirectDeliveryDi screpantItemsReport/DirectDeliveryDiscrepantItemsRe port.xdo |
Direct Delivery Label Report |
<BIP_XMLPSERVER_URL>/SIOCS/VendorDeliveryLabel/VendorDeliveryLabel.xdo |
Inventory Adjustment Report |
<BIP_XMLPSERVER_URL>/SIOCS/InventoryAdjust mentReport/InventoryAdjustmentReport.xdo |
InventoryAdjustmentAGSNReport |
<BIP_XMLPSERVER_URL>/SIOCS/InventoryAdjustmentAGSNReport/InventoryAdjustmentAGSNReport.xdo |
Item Basket Report |
<BIP_XMLPSERVER_URL>/SIOCS/ItemBasketReport/ItemBasketReport.xdo |
Item Detail Report |
<BIP_XMLPSERVER_URL>/SIOCS/ItemDetailRepor t/ItemDetailReport.xdo |
Purchase Order Report |
<BIP_XMLPSERVER_URL>/SIOCS/PurchaseOrderR eport/PurchaseOrderReport.xdo |
RFID History Report |
<BIP_XMLPSERVER_URL>/SIOCS/RFIDHistoryReport/RFIDHistoryReport.xdo |
RTV Report |
<BIP_XMLPSERVER_URL>/SIOCS/RTVReport/RTV Report.xdo |
RTV Shipment Report |
<BIP_XMLPSERVER_URL>/SIOCS/VendorShipmentReport/VendorShipmentReport.xdo |
RTV Shipment BOL Report |
<BIP_XMLPSERVER_URL>/SIOCS/VendorShipmentBOLReport/VendorShipmentBOLReport.xdo |
RTV Shipment Container Report |
<BIP_XMLPSERVER_URL>/SIOCS/VendorShipmentCartonReport/VendorShipmentCartonReport.xdo |
RTV Shipping Label Report |
<BIP_XMLPSERVER_URL>/SIOCS/VendorShippingLabel/VendorShippingLabel.xdo |
Scan List Report |
<BIP_XMLPSERVER_URL>/SIOCS/ReplenishmentGapReport/ReplenishmentGapReport.xdo |
Shelf Adjustment Report |
<BIP_XMLPSERVER_URL>/SIOCS/ShelfAdjustment Report/ShelfAdjustmentReport.xdo |
Shelf Replenishment Report |
<BIP_XMLPSERVER_URL>/SIOCS/ShelfReplenishm entReport/ShelfReplenishmentReport.xdo |
Stock Count All Location Report |
<BIP_XMLPSERVER_URL>/SIOCS/StockCountAllLo cReport/StockCountAllLocReport.xdo |
Stock Count Report |
<BIP_XMLPSERVER_URL>/SIOCS/StockCountReport/StockCountReport.xdo |
Stock Count Export Report |
<BIP_XMLPSERVER_URL>/SIOCS/StockCountExpo rtReport/StockCountExportReport.xdo |
Stock Count Rejected Item Report |
<BIP_XMLPSERVER_URL>/SIOCS/StockCountRejec tedItemReport/StockCountRejectedItemReport.xdo |
Store Order Report |
<BIP_XMLPSERVER_URL>/SIOCS/StoreOrderReport/StoreOrderReport.xdo |
Transfer Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferReport/ TransferReport.xdo |
Transfer Receiving Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferDelivery Report/TransferDeliveryReport.xd |
Transfer Receiving AGSN Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferDeliveryAGSNReport/TransferDeliveryAGSNReport.xdo |
Transfer Receiving Exception Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferDelivery ExceptionReport/TransferDeliveryExceptionReport.xdo |
Transfer Receiving Label Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferDelivery Label/TransferDeliveryLabel.xdo |
Transfer Shipment Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferShipmen tReport/TransferShipmentReport.xdo |
Transfer Shipment BOL Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferShipmen tBolReport/TransferShipmentBolReport.xdo |
Transfer Shipment Container Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferShipmen tCartonReport/TransferShipmentCartonReport.xdo |
Transfer Shipping Label Report |
<BIP_XMLPSERVER_URL>/SIOCS/TransferShippin gLabel/TransferShippingLabel.xdo |
Note:
<BIP_XMLPSERVER_URL> is the folder where EICS reports have been uploaded on the BI Publisher server.
Previewing a Report
Users can download the report from EICS JET UI Home/Operations/Report.
Figure 3-2 Reports Screen
EICS Operational Reports
The following list shows the EICS Operational Reports.
Table 3-2 Operational Reports
Report Name | Report Parameters | Primary Views or Tables |
---|---|---|
Customer Order Bin Label Report |
PICK_ID, COPIES |
RPRT_FUL_ORD_BIN_V |
Customer Order BOL Report |
DELIVERY_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_FUL_ORD_DLV_BOL_V |
Customer Order Delivery Report |
DELIVERY_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_FUL_ORD_DLV_V |
Customer Order Pick Discrepancy Report |
PICK_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_FUL_ORD_PICK_DISC_ V |
Customer Order Pick Report |
PICK_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_FUL_ORD_PICK_V |
Customer Order Report |
ORDER_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_FUL_ORD_V |
Customer Order Reverse Pick Report |
REVERSE_PICK_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_FUL_ORD_RV_PICK_V |
Direct Delivery AGSN Report |
CARTON_ID,COPIES |
DSD_LINE_ITEM_UIN, ITEM_UIN |
Direct Delivery Discrepant Items Report |
RECEIPT_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_DSD_DISCREPANT_IT M_V, RPRT_DSD_V |
Direct Delivery Label Report |
CARTON_ID,LOCALE_ID |
STOREDSD,DSD_CARTON,DSD_LINE_ITEM,SUPPLIER,ADDRESS, |
Direct Delivery Report |
RECEIPT_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_DSD_V, NOTES |
Inventory Adjustment AGSN Report |
INV_ADJUST_ID, COPIES |
ITEM_UIN, INV_ADJUST_LINE_ITEM_UIN |
Inventory Adjustment Report |
INV_ADJUST_ID, LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_INV_ADJUST_V, CONFIG_SYSTEM |
Item Basket Report |
ITEM_BASKET_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
ITEM_BASKET, CODE_DETAIL |
Item Detail Report |
ITEMID,STOREID,LOCALE_ID,STORE_TIMEZONE,COPIES |
STORE_SEQUENCE_ITEM,STORE_SEQUENCE_AREA,PRINT_FORMAT,TSF_ALLOCATION,ITEM,WAREHOUSE,RPRT_ITEM_DE TAIL_V |
Purchase Order Report |
PURCHASE_ORDER_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_PURCHASE_ORD_V |
RFID History Report |
ITEM_ID, FROM_DATE, TO_DATE, LOCALE_ID, COPIES |
RPRT_RFID_HISTORY_V |
RTV Report |
RETURN_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_RTV_V |
RTV Shipment BOL Report |
SHIP_NUMBER,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_RTV_SHIP_BOL_V, NOTES |
RTV Shipment Container Report |
CARTON_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_RTV_SHIP_V |
RTV Shipment Report |
SHIP_NUMBER,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_RTV_SHIP_V |
RTV Shipping Label Report |
CARTON_ID,LOCALE_ID, COPIES |
RPRT_RTV_SHIP_BOL_V,RTV_SHIP,CODE_DETAIL |
Scan List Report |
REPLENISH_GAP_ID,LOCALE_ID,STORE_TIMEZONE, COPIES |
RPRT_REPLENISH_GAP_V |
Shelf Adjustment Report |
SHELF_ADJUST_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_SHELF_ADJUST_V |
Shelf Replenishment Report |
SHELF_REPLENISH_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_SHELF_REPLENISH_V |
Stock Count All Location Report |
STORE_ID,STOCK_COUNT_ID,COPIES |
RPRT_STOCK_COUNT_V |
Stock Count Detail Report |
STOCK_COUNT_ID,STOCK_COUNT_CHILD_ID, STORE_TIMEZONE,PHASE,COPIES |
RPRT_STOCK_COUNT_V |
Stock Count Export Report |
STOCK_COUNT_ID,COPIES |
STOCK_COUNT_LINE_ITEM,STOCK_COUNT,STOCK_COUNT_LINE_ITEM_ UIN |
Stock Count Rejected Item Report |
STORE_ID,LOCALE_ID,COPIES |
RPRT_STOCK_COUNT_NOF_ V |
Store Order Report |
STORE_ORDER_ID, STORE_TIMEZONE, LOCALE_ID |
RPRT_STORE_ORDER_V, STORE_ORDER, STORE_ORDER_CFA, STORE_ORDER_CDA, CUSTOM_ATT_ADMIN |
Transfer Receiving AGSN Report |
CARTON_ID,COPIES |
TSF_DELV_LINE_ITEM_UIN,ITEM_UIN |
Transfer Receiving Exception Report |
DELIVERY_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
TSF_DELV,TSF_DELV_CARTON,TSF_DELV_LINE_ITEM,ITEM,STORE,WAREHOUSE,PARTNER,CONFIG_SYSTEM |
Transfer Receiving Label Report |
CARTON_ID,LOCALE_ID |
TSF_DELV,TSF_DELV_CARTON,TSF_DELV_LINE_ITEM,STORE,ADDRESS |
Transfer Receiving Report |
DELIVERY_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
TSF_DELV,TSF_DELV_CARTON,TSF_DELV_LINE_ITEM,ITEM,STORE_ITEM_STOCK,STORE,WAREHOUSE,PARTNER,CONFIG_SYSTEM,NOTES |
Transfer Report |
TRANSFER_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_TRANSFER_V |
Transfer Shipment BOL Report |
SHIPMENT_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
TSF_SHIP,TSF_SHIP_CARTON,TSF_SHIP_LINE_ITEM,ITEM,CONFIG_SYSTEM,SHIPMENT_BOL,SHIPMENT_CARTON_DIM,SHIPMENT_CARRIER_SERVICE, SHIPMENT_CARRIER, STORE,ADDRESS,NOTES |
Transfer Shipment Container Report |
CARTON_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
TSF_SHIP,TSF_SHIP_CARTON,TSF_SHIP_LINE_ITEM,ITEM,STORE,WAREHOUSE,PARTNER,CONFIG_SYSTEM,SHIPMENT_REASON |
Transfer Shipment Report |
SHIPMENT_ID,LOCALE_ID,STORE_TIMEZONE,COPIES |
RPRT_TSF_SHIP_V, NOTES |
Transfer Shipping Label |
CARTON_ID,LOCALE_ID |
TSF,TSF_SHIP,TSF_SHIP_CARTON, TSF_SHIP_LINE_ITEM,ITEM,SHIPMENT_BOL,STORE,ADDRESS |