SAS_CUSTOM_SEEDED_EDGES
Global custom role to seeded root inheritance edges for immutable projection snapshots. SAS_CUSTOM_SEEDED_EDGES_PK is the disabled primary-key constraint. SAS_CUSTOM_SEEDED_EDGES_U1 prevents duplicate custom-to-seeded root edges and supports custom-role-driven cache loading.
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SAS_CUSTOM_SEEDED_EDGES_PK |
SNAPSHOT_VERSION, CUSTOM_GLOBAL_ROLE_ID, SEEDED_ROOT_GLOBAL_ROLE_ID |
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| SNAPSHOT_VERSION | NUMBER | 18 | Yes | Immutable projection generation selected by snapshot control. |
| CUSTOM_GLOBAL_ROLE_ID | NUMBER | 18 | Yes | Custom role ID that inherits a seeded root. The unique index supports reads by snapshot and custom role. |
| SEEDED_ROOT_GLOBAL_ROLE_ID | NUMBER | 18 | Yes | Seeded role root reached from the custom role graph before deployment-scoped seeded closure expansion. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SAS_CUSTOM_SEEDED_EDGES_U1 | Unique | Default | SNAPSHOT_VERSION, CUSTOM_GLOBAL_ROLE_ID, SEEDED_ROOT_GLOBAL_ROLE_ID |