| Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Release 18.0 F13732-01 |
|
 Previous |
 Next |
| Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Release 18.0 F13732-01 |
|
Previous |
Next |
EICS has the ability to produce reports for retails to view.
Reports are generated from within the functional areas of EICS and include 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:
The following section describes the reporting framework.
The report format type is predefined as pdf format in the client. The report service use REST service calls to access the EICS server.
EICS uses BI Publisher as the printing engine. BI Publisher gets the report data from the database by sql and generated 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 call 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 (PRINT_FORMAT) refer to the report format. The EICS server fetches the report configuration detail from this table. |
The URL Location for each report type:
Table 3-1 Report URL Location
| Type | URL Location |
|---|---|
|
Customer Order Bin Label Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/CustomerOrder Report/CustomerOrderReport.xdo |
|
Customer Order Delivery BOL Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/CustomerOrderB inLabelReport/CustomerOrderBinLabelReport.xdo |
|
Customer Order Delivery Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/CustomerOrder DeliveryReport/CustomerOrderDeliveryReport.xdo |
|
Customer Order Pick Discrepancy Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/CustomerOrder DeliveryBOLReport/CustomerOrderDeliveryBOLReport.xdo |
|
Customer Order Pick Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/CustomerOrderP ickReport/CustomerOrderPickReport.xdo |
|
Customer Order Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/CustomerOrderP ickDiscrepancyReport/CustomerOrderPickDiscrepancyReport.xdo |
|
Customer Order Reverse Pick Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/CustomerOrder ReversePickReport/CustomerOrderReversePickReport.xdo |
|
Direct Delivery Discrepant Items Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/DirectDeliveryDi screpantItemsReport/DirectDeliveryDiscrepantItemsRe port.xdo |
|
Direct Delivery Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/DirectDeliveryR eport/DirectDeliveryReport.xdo |
|
InventoryAdjustmentAGSNReport |
<BIP_SIM_REPORTS_FOLDER>/SIM/InventoryAdjustmentAGSNReport/InventoryAdjustmentAGSNReport.xdo |
|
Inventory Adjustment Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/InventoryAdjust mentReport/InventoryAdjustmentReport.xdo |
|
Item Detail Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/ItemDetailRepor t/ItemDetailReport.xdo |
|
Purchase Order Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/PurchaseOrderR eport/PurchaseOrderReport.xdo |
|
Replenishment Gap Report |
<BIP_SIM_REPORTS_FOLDER>>/SIM/ReplenishmentGapReport/ ReplenishmentGapReport.xdo |
|
RTV Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/RTVReport/RTV Report.xdo |
|
Shelf Adjustment Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/ShelfAdjustment Report/ShelfAdjustmentReport.xdo |
|
Shelf Replenishment Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/ShelfReplenishm entReport/ShelfReplenishmentReport.xdo |
|
Stock Count All Loc Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/StockCountAllLo cReport/StockCountAllLocReport.xdo |
|
Stock Count Export Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/StockCountExpo rtReport/StockCountExportReport.xdo |
|
Stock Count Rejected Item Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/StockCountRejec tedItemReport/StockCountRejectedItemReport.xdo |
|
Stock Count Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/StockCountRepo rt/StockCountReport.xdo |
|
TransferDeliveryAGSNReport |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferDeliveryAGSNReport/TransferDeliveryAGSNReport.xdo |
|
Transfer Receiving Exception Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferDelivery ExceptionReport/TransferDeliveryExceptionReport.xdo |
|
Transfer Receiving Label |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferDelivery Label/TransferDeliveryLabel.xdo |
|
Transfer Receiving Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferDelivery Report/TransferDeliveryReport.xd |
|
Transfer Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferReport/ TransferReport.xdo |
|
Transfer Shipment Bol Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferShipmen tBolReport/TransferShipmentBolReport.xdo |
|
Transfer Shipment Container Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferShipmen tCartonReport/TransferShipmentCartonReport.xdo |
|
Transfer Shipment Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferShipmen tReport/TransferShipmentReport.xdo |
|
Transfer Shipping Label |
<BIP_SIM_REPORTS_FOLDER>/SIM/TransferShippin gLabel/TransferShippingLabel.xdo |
|
VendorDeliveryAGSNReport |
<BIP_SIM_REPORTS_FOLDER>/SIM/VendorDeliveryAGSNReport/VendorDeliveryAGSNReport.xdo |
|
Vendor Delivery Label |
<BIP_SIM_REPORTS_FOLDER>/SIM/VendorDeliveryLabel/ VendorDeliveryLabel.xdo |
|
RTV Shipment BOL Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/VendorShipment BOLReport/VendorShipmentBOLReport.xdo |
|
RTV Shipment Container Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/VendorShipment CartonReport/VendorShipmentCartonReport.xdo |
|
RTV Shipment Report |
<BIP_SIM_REPORTS_FOLDER>/SIM/VendorShipment Report/VendorShipmentReport.xdo |
|
RTV Shipping Label |
<BIP_SIM_REPORTS_FOLDER>/SIM/VendorShipping Label/VendorShippingLabel.xdo |
|
Note: <BIP_SIM_REPORTS_FOLDER> is the folder where EICS reports have been uploaded on the BI Publisher server. For example, if EICS reports have been uploaded to the Guest folder, the folder is /Guest. |
Users can download the report from EICS JET UI Home/Operations/Reports.
The following list shows the EICS Operational Reports.
Table 3-2 Operational Reports
| Report Name | Report Parameters | Primary Views or Tables |
|---|---|---|
|
CustomerOrderBinLabelReport |
bin_id, sim_customer_order_id, copies |
RPRT_FUL_ORD_BIN_V |
|
CustomerOrderDeliveryBOLReport |
delivery_Id, store_timezone, copies |
RPRT_FUL_ORD_DLV_BOL_V |
|
CustomerOrderDeliveryReport |
delivery_Id, store_timezone, copies |
RPRT_FUL_ORD_DLV_V |
|
CustomerOrderPickDiscrepanc yReport |
store_timezone, pick_id, copies |
RPRT_FUL_ORD_PICK_DISC_ V |
|
CustomerOrderPickReport |
store_timezone, pick_id, copies |
RPRT_FUL_ORD_PICK_V |
|
CustomerOrderReport |
order_id, store_timezone, copies |
RPRT_FUL_ORD_V |
|
CustomerOrderReversePickReport |
reverse_pick_id, store_timezone, copies |
RPRT_FUL_ORD_RV_PICK_V |
|
DirectDeliveryDiscrepantItems Report |
receipt_id, store_timezone, copies |
RPRT_DSD_DISCREPANT_IT M_V, RPRT_DSD_V |
|
DirectDeliveryReport |
receipt_id, store_timezone, copies |
RPRT_DSD_V, NOTES |
|
InventoryAdjustmentAGSNReport |
Inv_Adjust_ID, Copies |
ITEM_UIN, INV_ADJUST_LINE_ITEM_UIN |
|
InventoryAdjustmentReport |
inv_adj_id, store_timezone, copies |
RPRT_INV_ADJUST_V, CONFIG_SYSTEM |
|
ItemDetailReport |
itemid, storeid, store_timezone, copies |
STORE_SEQUENCE_ITEM, STORE_SEQUENCE_AREA, PRINT_FORMAT, TSF_ALLOCATIONITEM, WAREHOUSERPRT_ITEM_DE TAIL_V |
|
PurchaseOrderReport |
purchase_order_id, store_timezone, copies |
RPRT_PURCHASE_ORD_V |
|
ReplenishmentGapReport |
replenish_gap_id, copies, store_timezone, locale_id |
RPRT_REPLENISH_GAP_V |
|
RTVReport |
return_id, store_timezone, copies |
RPRT_RTV_V |
|
ShelfAdjustmentReport |
shelf_adjust_id, copies, store_timezone |
RPRT_SHELF_ADJUST_V |
|
ShelfReplenishmentReport |
shelf_replenish_id, store_timezone, copies |
RPRT_SHELF_REPLENISH_V |
|
StockCountAllLocReport |
store_id, stock_count_id, copies |
RPRT_STOCK_COUNT_V |
|
StockCountExportReport |
stock_count_id, copies |
STOCK_COUNT_LINE_ITEM, STOCK_COUNT, STOCK_COUNT_LINE_ITEM_ UIN |
|
StockCountRejectedItemReport |
store_id, copies |
RPRT_STOCK_COUNT_NOF_ V |
|
StockCountReport |
stock_count_id, location_id, store_timezone, phase, copies |
RPRT_STOCK_COUNT_V |
|
TransferDeliveryAGSNReport |
Carton_ID, Copies |
TSF_DELV_LINE_ITEM_UIN, ITEM_UIN |
|
TransferDeliveryExceptionReport |
delivery_id |
TSF_DELV, TSF_DELV_CARTON, TSF_DELV_LINE_ITEM, ITEM, STORE,WAREHOUSE, PARTNER, CONFIG_SYSTEM |
|
TransferDeliveryLabel |
carton_id |
TSF_DELV, TSF_DELV_CARTON, TSF_DELV_LINE_ITEM, STORE, ADDRESS |
|
TransferDeliveryReport |
delivery_id |
TSF_DELV, TSF_DELV_CARTON, TSF_DELV_LINE_ITEM, ITEM, STORE_ITEM_STOCK, STORE, WAREHOUSE, PARTNER, CONFIG_SYSTEM, NOTES |
|
TransferReport |
transfer_id, store_timezone, copies |
RPRT_TRANSFER_V |
|
TransferShipmentBolReport |
shipment_id, store_timezone, copies |
TSF_SHIP, TSF_SHIP_CARTON, TSF_SHIP_LINE_ITEM, ITEM, CONFIG_SYSTEM, SHIPMENT_BOL, SHIPMENT_CARTON_DIM, SHIPMENT_CARRIER_SERVIC E,SHIPMENT_CARRIER, STORE, ADDRESS, NOTES |
|
TransferShipmentCartonReport |
store_timezone, carton_id, copies |
TSF_SHIP,TSF_SHIP_CARTON ,TSF_SHIP_LINE_ITEM, ITEM, STORE,WAREHOUSE, PARTNER, CONFIG_SYSTEM, SHIPMENT_REASON |
|
TransferShipmentReport |
shipment_id, copies, store_timezone |
RPRT_TSF_SHIP_V, NOTES |
|
TransferShippingLabel |
carton_id |
TSF,TSF_SHIP, TSF_SHIP_CARTON, TSF_SHIP_LINE_ITEM,ITEM, SHIPMENT_BOL,STORE, ADDRESS |
|
VendorDeliveryAGSNReport |
Carton_ID, Copies |
DSD_LINE_ITEM_UIN, ITEM_UIN |
|
VendorDeliveryLabel |
carton_id, locale_id |
DSD_CARTON, DSD_LINE_ITEM,SUPPLIER, DSD,ADDRESS,STORE |
|
VendorShipmentBOLReport |
store_timezone, ship_number, copies |
RPRT_RTV_SHIP_BOL_V, NOTES |
|
VendorShipmentCartonReport |
store_timezone, carton_id, copies |
RPRT_RTV_SHIP_V |
|
VendorShipmentReport |
store_timezone, ship_number, copies |
RPRT_RTV_SHIP_V |
|
VendorShippingLabel |
carton_id, copies |
RPRT_RTV_SHIP_BOL_V, RTV_SHIP,RTV_TYPE, CODE_DETAIL |
