MSC_CC_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: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MSC_CC_COLLECTED_BO_PK |
INSTANCE_ID, BUSINESS_OBJECT |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INSTANCE_ID | NUMBER | Yes | The instance id of the source that this monitoring information is targeted. | ||
| BUSINESS_OBJECT | VARCHAR2 | 100 | 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. | |||
| CROSS_REFERENCE_REQ | NUMBER | Identifies whether or not cross referencing is enabled for this business object. | |||
| 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. | |||
| CONT_COLL_SUBMITTED_ON_UI | NUMBER | 2 | 1-true; 2-false (This col not consumed by collections; consumed only by UI) | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_CC_COLLECTED_BO | msc_apps_instances | INSTANCE_ID |
| MSC_CC_COLLECTED_BO | msc_business_objects_b | BUSINESS_OBJECT |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_CC_COLLECTED_BO_U1 | Unique | Default | INSTANCE_ID, BUSINESS_OBJECT |