FSG Report and Components Overview

GL : FSG Report and Components Overview:-
---------------------------------------------------

FSG REPORTS AND COMPONENTS OVERVIEW

Details definitions of FSG reports by component, and includes several small scripts for listing all components across different charts of accounts.

Can be used for SOX and system audits.

I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.

I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly if you have multiple SOB in your business Structure.

-- FSG REPORTS --------------
SELECT FST.ID_FLEX_STRUCTURE_NAME
, R.NAME
, R.REPORT_TITLE
, R.DESCRIPTION
, R.COLUMN_SET"COLUMN SET"
, RW2.STRUCTURE_ID
, RW2.DESCRIPTION"COL DESC"
, R.ROW_SET"ROW SET"
, RW.DESCRIPTION"ROW DESC"
, R.REPORT_DISPLAY_SET"DISPLAY SET"
, R.CONTENT_SET"CONTENT SET"
, R.ROW_ORDER"ROW ORDER"
, R.ROUNDING_OPTION "RND"
, U.USER_NAME
, U.DESCRIPTION
, R.CREATION_DATE
FROM RG_REPORTS_V R, FND_ID_FLEX_STRUCTURES_V FST, FND_USER U, RG_REPORT_AXIS_SETS_V RW, RG_REPORT_AXIS_SETS_V RW2
WHERE R.STRUCTURE_ID = FST.ID_FLEX_NUM
AND R.ROW_SET_ID = RW.AXIS_SET_ID
AND R.COLUMN_SET_ID = RW2.AXIS_SET_ID
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
AND R.CREATED_BY = U.USER_ID
ORDER BY 1, 2

-- FSG ROW SETS AND COLUMN SETS ----------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, DECODE(RW.AXIS_SET_TYPE,'R','ROW SET','C','COLUMN SET','##') "ROW/COLUMN"
, RW.NAME"SET NAME"
, RW.AXIS_SET_ID
FROM RG_REPORT_AXIS_SETS_V RW, FND_ID_FLEX_STRUCTURES_V FST
WHERE RW.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
ORDER BY 1,2,3

---- CONTENT SETS ------------------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, CS.NAME
, CS.CONTENT_SET_ID
FROM RG_REPORT_CONTENT_SETS CS, FND_ID_FLEX_STRUCTURES_V FST
WHERE CS.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')

----- ROW ORDERS ---------------------------
SELECT FST.ID_FLEX_STRUCTURE_NAME "COA"
, RO.NAME "ROW ORDER"
, RO.DESCRIPTION "DESCRIPTION"
, RO.STRUCTURE_ID
, RO.ROW_ORDER_ID
FROM RG_ROW_ORDERS RO, FND_ID_FLEX_STRUCTURES_V FST
WHERE RO.STRUCTURE_ID = FST.ID_FLEX_NUM
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN (''HB')
ORDER BY RO.NAME