GL_FRC_REPORTS_B

This table contains the list of reports available in BI catalog. This includes all the 3 types of reports namely BIP, OTBI and Financial Report.

Details

• Schema: FUSION

• Object owner: GL

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
GL_FRC_REPORTS_B_PK	REPORT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REPORT_ID	NUMBER		18	Yes	Unique sequence generated identifier for each report in catalog.
REPORT_FOLDER	VARCHAR2	1000			Path of the folder in which the report is stored in the catalog.
REPORT_PATH	VARCHAR2	1000		Yes	Complete path of the report which is returned by the BI webservice.
REPORT_TYPE_CODE	VARCHAR2	30		Yes	Indicates the type of the report. Valid Values are BIP, Dashboard, Analysis and FR.
REPORT_DISPLAY_ICON	VARCHAR2	400		Yes	Holds the display icon path associated with each report type.
REPORT_IMAGE_PATH	VARCHAR2	400			Holds the report image path which would be displayed as an image on the reporting center user interface.
BIP_REPORT_JOB_DEFINITION	VARCHAR2	1000			Holds the ESS Job definition of a BIP report. This column will be populated only if the report type is BIP.
AUTHOR_DISPLAY_NAME	VARCHAR2	100			Display name of user who created the report in business intelligence catalog.
LAST_MODIFIED_DATE	TIMESTAMP				Date and time when report was last modfied in business intelligence catalog.
LAST_ACCESSED_DATE	TIMESTAMP				Date and time when report was last accessed in business intelligence catalog.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
gl_frc_reports_tl	gl_frc_reports_b	REPORT_ID
gl_frc_user_access_reports	gl_frc_reports_b	REPORT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
GL_FRC_REPORTS_B_U1	Unique	Default	REPORT_ID