MSC_SR_COLLECTED_BO
This table idenitifies the business objects that the user would like to monitor for incremental changes in fusion collections. It also identifies the tables that actually have monitoring enabled.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_SR_COLLECTED_BO_PK |
DESTINATION_CODE, BUSINESS_OBJECT |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DESTINATION_CODE | VARCHAR2 | 30 | Yes | Instance code of the destination instance | |
| BUSINESS_OBJECT | VARCHAR2 | 20 | Yes | The business object that may or may not be monitored. | |
| CONT_COLL_REQUESTED | NUMBER | Whether the user wants to collect inicremental changes on the associated business object. | |||
| CONT_COLL_ENABLED | NUMBER | Whether or not CDC change monitoring is set up for the tables in this business object. | |||
| 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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_CYCLE_START_SCN | NUMBER | 18 | SCN at the time when last collection cycle started. | ||
| LAST_CYCLE_START_TIMESTAMP | TIMESTAMP | TimeStamp at the time when last collection cycle started. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_SR_COLLECTED_BO_U1 | Unique | Default | DESTINATION_CODE, BUSINESS_OBJECT |