Running it On Oracle fusion cloud

i took care that in sql now my concern is only to replace null values with '-'

thanks for the help

brajesh, Syntax is wrong because if budget =0 then it should replace with '-' but its not doing that in my case. thanks

All this information is being stored in PER_LOCATION_LEG_F table

actually we can acheive the information using table atk_report_mappings but i wish there should be a table to capture custom made reports too.

Correct answer is GL_FRC_REPORTS_B table contains the list of reports available in BI catalog

Srini, I was looking for unit number and work site description in oracle fusion financials application and path for the data would be >> setup and maintenance>>manage locations>>enter location name and enter>> United States Multiple Worksite Reporting Information Trade NameWorksite DescriptionSC001-EOPSUnit Number15405