My Oracle Support Banner

E1: OVR: "Report Criteria" is Showing Only the First Line of the Advanced Query (Doc ID 2831030.1)

Last updated on DECEMBER 30, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.


"Report Criteria" added to the One View Report (OVR) shows only the first line of the Advanced Query (AQ), even though the query has more than one line. For example, below image demonstrates a scenario where the query has three lines but the Report Criteria displays only the first line from the query:


Steps to replicate:

  1. Access a One View Reporting-enabled form (eg: P03B2022|W03B2022A)
  2. Create a default AQ with more than one line
  3. From the One View menu, select Manage Reports
  4. Select the personal or reserved report that you want to modify
  5. On the side panel Layout tab, click the Edit Layout icon
  6. In BI Publisher, select the Edit option for the report
  7. Add the "Report Criteria" and Save
  8. Run the OVR and review the "Report Criteria" in the output




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

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