My Oracle Support Banner

FAQ Web Report (Doc ID 2787830.1)

Last updated on MAY 13, 2022

Applies to:

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


 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
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?
 Q6: How to migrate Web Report Gen 1 to Web Report Gen 2?
 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 the WMS (Warehouse Management Services) 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?
 Q1: How to optimize scheduled reports?
 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: What condition do I add to create a join between the item_hierarchy_defn category and the inventory_history category?
 Q16: Why is it not possible to schedule chained reports?
 Q17: How to convert the dates and DateTime values to the format 'yyyy-MM-dd' (e.g. 2021-02-15) in Gen2 Web reports?
 Q18: Why is an Inventory History report not pulling the correct Date and Timezone?
 Q19: How to get Date and Time format like 'yyyy-mm-ddThh:mm:ss' in Web report Gen2?
 Q20: Why is the report fetching time-based on UTC rather than facility time?
 Q21: How to display in the reports the date in the following format: 'DD-MM-YYYY'?
 Q22: How to filter the report to get the data created only for the last 24 hours?
 Q23: Why is it that when running web reports there are lines showing in the sample, but when extracting the report, the lines are blank?
 Q24: Why does the report show duplicate rows?
 Q25: Compared to Gen 1, when running a report that has filters on dates, reports display a 'No Data Qualified' message. Why is that?
 Q26: How can one add the filters in the results view in WEB REPORT Gen 2?
 Q27: How to represent a tabular graph web report?
 Q28: What are the correct joins in WEB REPORT Gen 2 to achieve the same result as corresponding WEB REPORT Gen 1?
 Q29: 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?
 Q30: How to link 'Inventory' with 'Location' to get the inventory by Location wise?
 Q31: Why are the item.barcode and item.description fields blank when combined with an appointment in a join sequence?
 Q32: Why does a report that should return everyday stock, show 'No Location' for some of the data?
 Q33: How To Print Full Name (First And Last) On Web Reports Gen2?
 Q34: Why is the scheduled job failing when running a web report: 'Unexpected error'?
 Q35: How to schedule a web report that is running for more than 90 seconds?
 Q36: Where can one configure the 'FTP Host' of a GEN 2 web report?
 Q37: Why are reports not being sent to the correct folder?
 Q38: What is the reason for the following error --> "Unrecognized datatype return type: integer"?
 Q39: How to retrieve data for Internal Picking Order Type? When adding this condition, the report returns 'No Data Qualified'.
 Q40: Why is my WebReport in Dashboard not formatting?
  Q41:  How to insert a blank page after each task in task report?
 Q42: How to create an ETA Range which will show 30 min before ETA and 15 min after ETA, using order_hdr.cust_field_1 (Text Field) = to store ETA DateTime in format DD/MM/YYYY hh:mm:ss.--how to show this field in Web report and create an ETA Range which will show 30 min before ETA and 15 min after ETA.
 When to log a Service Request?

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