SAS_ALL_ROLES

Global role catalog and stable role ID registry for seeded and custom roles. Inactive rows reserve retired role IDs so IDs are not reused. SAS_ALL_ROLES_PK is the disabled primary-key constraint for GLOBAL_ROLE_ID. SAS_ALL_ROLES_U1 enforces unique GLOBAL_ROLE_ID values and supports stable lookup during cache decode and projection joins. SAS_ALL_ROLES_U2 preserves the natural role-name mapping so a role name cannot receive multiple global IDs. SAS_ALL_ROLES_N1 supports active registry scans and catalog materialization ordered by ID. SAS_ALL_ROLES_CHK1 constrains ROLE_TYPE to SEEDED or CUSTOM. SAS_ALL_ROLES_CHK2 constrains ACTIVE_FLAG to 0 or 1. SAS_ALL_ROLES_S allocates new stable role IDs without identity columns.

Details

• Schema: FUSION

• Object owner: FND

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SAS_ALL_ROLES_PK	GLOBAL_ROLE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
GLOBAL_ROLE_ID	NUMBER		18	Yes	Stable compact numeric role identifier used by projection tables and cache payloads. Allocated from SAS_ALL_ROLES_S.
NAME	VARCHAR2	1024		Yes	Source role name used as the natural key for preserving role identity across projection refreshes.
ROLE_TYPE	VARCHAR2	6		Yes	Logical role type. Expected values are SEEDED and CUSTOM.
ACTIVE_FLAG	NUMBER		1	Yes	Indicates whether the role is currently active in source data. Inactive rows reserve retired IDs to prevent reuse.

Indexes

Index	Uniqueness	Tablespace	Columns
SAS_ALL_ROLES_N1	Non Unique	Default	ACTIVE_FLAG, GLOBAL_ROLE_ID
SAS_ALL_ROLES_U1	Unique	Default	GLOBAL_ROLE_ID
SAS_ALL_ROLES_U2	Unique	Default	NAME