OKC_REVIEW_MESSAGES
This table is used to store the messages during the upoload of Word document. As part of uploading the word document, message during the review process are stored in this table.
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
OKC_REVIEW_MESSAGES_PK |
REVIEW_MESSAGES_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REVIEW_MESSAGES_ID | NUMBER | 18 | Yes | Sequence Id - Ptimary Key for OKC_REVIEW_MESSAGES | |
| REVIEW_UPLD_TERMS_ID | NUMBER | Reference to Clause or Section or root id stored in OKC_REVIEW_UPLOADED_TERMS table | |||
| ERROR_SEVERITY | VARCHAR2 | 1 | Code that denotes Severity as Error or Warning | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Message Name for the error or warning. | ||
| 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. | |
| VARIABLE_CODE | VARCHAR2 | 30 | Variable Code for which this message is used | ||
| 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_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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| MESSAGE_TOKEN1 | VARCHAR2 | 240 | Token1 of the message uploaded to the word doc | ||
| MESSAGE_VALUE1 | VARCHAR2 | 240 | Value of Token1 of the message uploaded to the word doc | ||
| MESSAGE_TOKEN2 | VARCHAR2 | 240 | Token2 of the message uploaded to the word doc | ||
| MESSAGE_VALUE2 | VARCHAR2 | 240 | Value of Token2 of the message uploaded to the word doc | ||
| MESSAGE_TOKEN3 | VARCHAR2 | 240 | Token3 of the message uploaded to the word doc | ||
| MESSAGE_VALUE3 | VARCHAR2 | 240 | Value of Token3 of the message uploaded to the word doc | ||
| MESSAGE_TOKEN4 | VARCHAR2 | 240 | Token4 of the message uploaded to the word doc | ||
| MESSAGE_VALUE4 | VARCHAR2 | 240 | Value of Token4 of the message uploaded to the word doc | ||
| MESSAGE_TOKEN5 | VARCHAR2 | 240 | Token5 of the message uploaded to the word doc | ||
| MESSAGE_VALUE5 | VARCHAR2 | 240 | Value of Token5 of the message uploaded to the word doc |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| OKC_REVIEW_MESSAGES | okc_review_upld_terms | REVIEW_UPLD_TERMS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_REVIEW_MESSAGES_N1 | Non Unique | Default | REVIEW_UPLD_TERMS_ID |
| OKC_REVIEW_MESSAGES_U1 | Unique | Default | REVIEW_MESSAGES_ID |