How can we confirm impacted reports before removing the subject area access from some roles

Question

There are many reports are developed using some subject area and saved in different folders. Can i check how many reports would be impacted before removing the access? For example, I want to check how many reports are using "Workforce Management - Grade Rate Real Time" subject area.

Bharat Agrawal · Answer

I do not believe Oracle yet exposes subject area of report information in table. GL_FRC_REPORTS_B table gives you list of reports without subject area.