My Oracle Support Banner

FAQ Web Report (Doc ID 2787830.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 21.1 and later
Information in this document applies to any platform.

Purpose

 To provide the answers to frequently asked questions about Web Reports.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Web Report Gen 1
 Q1: Why is WMS not allowing to save reports from screen Web Report (*)?
 Q2: Why can we no longer modify any Gen 1 Web Report? The error message states to contact the administrator.
 Q3: Is there any specific timeline by which Web Reports Gen1 will be disabled?
 Q4: Until when would we be receiving support for Web Reports Gen1 (SR support, fixes, etc.)?
 Q5: How to convert Web Gen 1 report to Web Gen 2? What condition do I add to create a join between the item_hierarchy_defn category and the inventory_history category?
 Q6: How to migrate Web Report Gen 1 to Web Report Gen 2?
 General
 Q1: How to migrate Web reports from a test instance to a production instance?
 Q2: Can a function value from a different report be passed as a parameter (in Chain reports)?
 Q3: Is it possible to pull item images onto web reports?
 Q4: Are there any pre-built reports or dashboards on WMS (Warehouse Management Services) cloud test instance?
 Q5: How to give access to users to see other facility data in the reports, other than the eligible ones?
 Q6: Can we print out web reports using RF Interface?
 Q7: How to get the Web Report Gen 2 Screen shown in UI?
 Q8: Is there a way to filter values from a drop-down list in the filter section, based on the aliases?
 Q9: Are optional features like GoogleMaps or GeoCharts available?
 Q10: How to check the audit history of users running a web report?
 Q11: How do user roles work?
 Q12: Why are the IDs not available to be shown in reports, and only available for joins?
 Q13: What is the URL for Web Reports Gen2?
 Q14: How to achieve a report that shows the frequency of users' login into WMS per day?
 Q15: How to check the Exago version in Web Repots?
 Performance
 Q1: How to optimize scheduled reports?
 Setup
 Q1: Why are users receiving the error: 'Access denied'?
How to give access to users to execute sub-reports?
 Q2: Why is WEB REPORT creating random values when executing it?
 Q3: How can I get the raw value for the Unit Volume field from the Item category?
 Q4: Why are the filter functions not working correctly?
 Q5: When running a report with a user that has another language, other than English, as default, the statuses are not translated. How can we translate them?
 Q6: From which category in Web Report Gen 2, can I get the Current Qty available in the Reserve Inventory screen?
 Q7: How can one view the active inventory?
 Q8: Why is the Custom Packing Slip Report not displaying data for 1 facility (XXX) and returning blank report output?
 Q9: How to join order_hdr and/or order_dtl info to the OB Load?
 Q10: How to remove categories from a web report, when all red ‘x’s are disabled?
 Q11: How to achieve the following: report showing inventory attributes and lock codes?
 Q12: How can we achieve grouping in the report by department and status, and sort it by QTY descending?
 Q13: What categories need to be used to achieve the following: Order_hdr join with Load to pull the order status, and load number when available?
 Q14: Why is the Report with the following categories not pulling data?
 Q15: Why is it not possible to schedule chained reports?
 Q16: How to convert the dates and DateTime values to the format 'yyyy-MM-dd' (e.g. 2021-02-15) in Gen2 Web reports?
 Q17: Why is an Inventory History report not pulling the correct Date and Timezone?
 Q18: How to get Date and Time format like 'yyyy-mm-ddThh:mm:ss' in Web report Gen2?
 Q19: Why is the report fetching time-based on UTC rather than facility time?
 Q20: How to achieve the date for DD-MM-YYYY in report columns?
 Q21: How to filter the report to get the data created only for the last 24 hours?
 Q22: Why is it that when running web reports there are lines showing in the sample, but when extracting the report, the lines are blank?
 Q23: Why does the report show duplicate rows?
 Q24: Compared to Gen 1, when running a report that has filters on dates, reports display a 'No Data Qualified' message. Why is that?
 Q25: How can one add the filters in the results view in WEB REPORT Gen 2?
 Q26: How to represent a tabular graph web report?
 Q27: What are the correct joins in WEB REPORT Gen 2 to achieve the same result as corresponding WEB REPORT Gen 1?
 Q28: There are 3 different LPNs for the same item in a single ASN but the report is showing only one line. How can one get the report to show the details?
 Q29: How to link 'Inventory' with 'Location' to get the inventory by Location wise?
 Q30: Why are the item.barcode and item.description fields blank when combined with an appointment in a join sequence?
 Q31: Why does a report that should return everyday stock, show 'No Location' for some of the data?
 Q32: Why is the scheduled job failing when running a web report: 'Unexpected error'?
 Q33: How to schedule a web report that is running for more than 90 seconds?
 Q34: Where can one configure the 'FTP Host' of a GEN 2 web report?
 Q35: Why are reports not being sent to the correct folder?
 When to log a Service Request?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.