FND_FA_IDCS_NOTIF_JOB_STATUS
Version 2 of SaaS-PaaS sync job used for notifying the IDCS to sync users/roles and Role associations
Details
-
Schema: IDCSUSERJOBNOTIFY
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
fnd_fa_idcs_notif_job_sta_PK |
ESS_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ESS_REQUEST_ID | NUMBER | 18 | Yes | Indicates the ESS job request ID and unique identifier of the table. | |
| FA_USER_REQ_URL | VARCHAR2 | 512 | The URL for retrieving user data. | ||
| FA_USER_REQ_SENT_ON | TIMESTAMP | The time stamp when the ESS job sent the REST request to the application to retrieve data about users. | |||
| FA_USER_RESP_RCVD | NUMBER | 4 | The response code about users received from the REST endpoint. The response description about users received from the REST endpoint. | ||
| FA_USER_RESP_MSG_RCVD | CLOB | The response description about users received from the REST endpoint. | |||
| FA_USER_RESP_PROCESSED_MSG | VARCHAR2 | 255 | The user-friendly representation of the response about users received from the REST endpoint. | ||
| FA_ROLE_REQ_URL | VARCHAR2 | 512 | The URL for retrieving role data. | ||
| FA_ROLE_REQ_SENT_ON | TIMESTAMP | The time stamp when the ESS job sent the REST request to the application to retrieve data about roles. | |||
| FA_ROLE_RESP_RCVD | NUMBER | 4 | The response code about roles received from the REST endpoint. | ||
| FA_ROLE_RESP_MSG_RCVD | CLOB | The response description about roles received from the REST endpoint. | |||
| FA_ROLE_RESP_PROCESSED_MSG | VARCHAR2 | 255 | The user-friendly representation of the response about roles received from the REST endpoint. | ||
| FA_USER_ATOM_REQ_URL | VARCHAR2 | 512 | FA_USER_ATOM_REQ_URL | ||
| FA_USER_ATOM_REQ_SENT_ON | TIMESTAMP | FA_USER_ATOM_REQ_SENT_ON | |||
| FA_USER_ATOM_RESP_RCVD | NUMBER | 4 | FA_USER_ATOM_RESP_RCVD | ||
| FA_USER_ATOM_RESP_MSG_RCVD | CLOB | FA_USER_ATOM_RESP_MSG_RCVD | |||
| FA_USER_ATOM_DELTA_FLAG | CHAR | 1 | FA_USER_ATOM_DELTA_FLAG | ||
| FA_USER_ATOM_PROCESSED_MSG | VARCHAR2 | 255 | FA_USER_ATOM_PROCESSED_MSG | ||
| FA_USER_DELTA_FLAG | CHAR | 1 | Indicates whether there is any change in users. Valid values are: Y or N. | ||
| FA_ROLE_DELTA_FLAG | CHAR | 1 | Indicates whether there is any change in roles. Valid values are: Y or N. | ||
| FA_USER_ROLE_ASSN_DELTA_FLAG | CHAR | 1 | Indicates whether there is any change in user role associations. Valid values are: Y or N. | ||
| IDCS_JOB_NOTIFY_TYPE | VARCHAR2 | 15 | Indicates the job notification type. Valid values are: INCREMENTAL for IDCS or NULL. Use NULL if the requests are from Oracle HCM Cloud. | ||
| IDCS_REQ_URL | VARCHAR2 | 512 | The job notification URL of Identity Cloud Service (IDCS). | ||
| IDCS_REQ_URL_PAYLOAD | VARCHAR2 | 1000 | The job notification URL of IDCS with payload in JSON format. | ||
| IDCS_REQ_SENT_ON | TIMESTAMP | The time stamp when the ESS job sent the REST request to IDCS. | |||
| IDCS_RESP_MSG_RCVD | CLOB | The response description received from the IDCS REST endpoint. | |||
| IDCS_JOB_ID | VARCHAR2 | 255 | The IDCS job id. | ||
| IDCS_RESP_RCVD | NUMBER | 4 | The response code about IDCS Job received from the REST endpoint. | ||
| IDCS_APPID | VARCHAR2 | 50 | APPID of Oracle Cloud Fusion | ||
| ERROR_MESSAGE | VARCHAR2 | 4000 | ERROR_MESSAGE | ||
| ERROR_CODE | VARCHAR2 | 2000 | ERROR_CODE | ||
| ATRRIBUTE1 | VARCHAR2 | 2000 | ATRRIBUTE1 | ||
| ATTRIBUTE2 | VARCHAR2 | 2000 | ATTRIBUTE2 | ||
| ATTRIBUTE3 | VARCHAR2 | 2000 | ATTRIBUTE3 | ||
| ATTRIBUTE4 | VARCHAR2 | 2000 | ATTRIBUTE4 | ||
| ATTRIBUTE5 | VARCHAR2 | 2000 | ATTRIBUTE5 | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated with 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. |