GL_FRC_USER_ACCESS_REPORTS

This table contains the list of reports from BI catalog that a user has access. 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_USER_ACCESS_REP_PK	USER_ACCESS_REPORT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
USER_ACCESS_REPORT_ID	NUMBER		18	Yes	Unique sequence generated identifier for each report that user has access.
REPORT_ID	NUMBER		18	Yes	Unique identifier of the report.
USER_NAME	VARCHAR2	100		Yes	The latest principal username of the user.
REPORT_TYPE_CODE	VARCHAR2	30		Yes	Indicates the type of the report. Valid Values are BIP, Dashboard, Analysis and FR.
LAST_ACCESSED_DATE	TIMESTAMP				Holds the date on which the report is last accessed by the user from reporting center user interface.
LAST_ACCESSED_BIP_ESS_REQ_ID	NUMBER		18		Holds the ESS job request id which is last accessed by the user from 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.
FAVORITE_FLAG	VARCHAR2	1		Yes	Indicator to show whether a report is favorite for the given user. Valid values are Y or N.
DELETED_FLAG	VARCHAR2	1		Yes	Indicator to show whether a report is deleted from the catalog for the given user. Valid values are Y or N.
LATEST_REQUEST_EXISTS_FLAG	VARCHAR2	1		Yes	Indicator to show whether a new ESS request exists for a BIP report for the logged in user. Valid values are Y or N.
FR_REPORT_URL	VARCHAR2	1000			Holds the financial report URL.
PERMISSION_CODE	NUMBER		7		Permission code for report. The value in this column indicates the permission types ex - READ, TRAVERSE, DELETE, WRITE etc.
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_USER_ACCESS_REPORTS	gl_frc_reports_b	REPORT_ID
gl_frc_user_access_report_tags	gl_frc_user_access_reports	USER_ACCESS_REPORT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
GL_FRC_USER_ACCESS_REP_U1	Unique	Default	USER_ACCESS_REPORT_ID
GL_FRC_USER_ACCESS_REP_U2	Unique	Default	USER_NAME, REPORT_ID