My Oracle Support Banner

Fusion BI: How to Add A Column To Display The Row Number In The Report? (Doc ID 1982099.1)

Last updated on JANUARY 20, 2020

Applies to:

Oracle Fusion Goal Management Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

You have custom OTBI reports using Subject Area - Management - Goal Status Overview Real Time.
You would like to add a column to display the row number in the report. You tried adding ROWNUM to the SQL but it returned an error. How can we add ROWNUM to the report?

Solution

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
Goal
Solution


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