FND_SP_SUGGESTIONS
Suggestions Service is a Helidon MP based Smart Platform micro service being developed as part of Saas-infra . It provides APIs to allows the sync client to synchronize the suggestions data at the client end with the database. This suggestion data is used in the VB application by smart platform to render personalization for specific user. The table FND_SP_SUGGESTIONS is used as a persistence layer where data will flow in through the spectra ucpwrapper which acts as a data source.
Details
-
Schema: SP
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_SP_SUGGESTIONS_PK |
USER_ID, SUBJECT, STRUCTURE_VERSION |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| USER_ID | VARCHAR2 | 200 | Yes | User guid which is mapped to each user logged into the application. |
| SUBJECT | VARCHAR2 | 4000 | Yes | Component information which explains the type, id and location of the component. |
| STRUCTURE_VERSION | VARCHAR2 | 64 | Yes | Version of internal structure of policy data payload. |
| POLICY_DATA_VERSION | VARCHAR2 | 200 | Yes | Version of data to support bi-directional sync. |
| POLICY_DATA | BLOB | Blob data which basically contains the data emitted by the subject. | ||
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SP_SUGGESTIONS_U1 | Unique | Default | USER_ID, SUBJECT, STRUCTURE_VERSION |