Oracle Fusion ERP Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What should be the appropriate way to group the rows together so they show in same page?

Incorrect Answer
16
Views
2
Comments
CS Yuen-Oracle
CS Yuen-Oracle Rank 2 - Community Beginner
edited Nov 3, 2025 1:25AM in Oracle Fusion ERP Analytics

Hi,

I have a custom report, it contains a table, show both the invoice header and invoice distribution information. But they are in separate rows.

For example:

In same table,

Column Headings of Invoice Header

Column Headings of Invoice Distribution

Result Row of Invoice Header A

Result Row of Invoice Distribution A of Invoice Header A

Result Row of Invoice Distribution B of Invoice Header A

Now I want to have rows of same invoice to be shown in the same page, but the result is the header result row is shown in page 1, but the distribution rows of the invoice header shown in next page, how to modify the layout in RTF template to solve it

Related SR: 4-0001210487

Answers

  • CS Yuen-Oracle
    CS Yuen-Oracle Rank 2 - Community Beginner
    Screenshot (2617).png

    Above is the RTF template: Invoice Header row is in group 8, invoice distribution is in group 9.

    Here the result shows the header line on page 1, but the distribution group on page 2. how to set in RTF template, so they are shown both in page 2?

    Screenshot (2618).png
  • Manjunath Kaaluru
    Manjunath Kaaluru Rank 1 - Community Starter

    Fair response