CMK_COLLAB_DOC_OPERS
This table is used to capture the operations of a Fusion service involved in collaboration message processing e.g. Change Purchase Order operation of the Purchase Order Service. It provices the application interface and setup properties to process the primary object associated with a Collaboration Document.
Details
-
Schema: FUSION
-
Object owner: CMK
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CMK_COLLAB_DOC_OPERS_PK |
DOC_OPERATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOC_OPERATION_ID | NUMBER | 18 | Yes | Primary Key for the Collaboration Document Operation. | |
| VERSION | VARCHAR2 | 100 | Yes | Version of the Collaboration Document Operation e.g. 1.0 | |
| APPL_MOD_SHORT_NAME | VARCHAR2 | 256 | Module Name used to query Topology Manager to retrieve Application Context Root. | ||
| OBJ_LINE_XPATH | VARCHAR2 | 2000 | Stores the Xpath of Line in message | ||
| OBJ_SUBLINE_XPATH | VARCHAR2 | 2000 | Stores the XPath of Sub-line (Line schedule) in message. | ||
| EVENT | VARCHAR2 | 256 | An event that triggers outbound collaboration activity e.g. New Purchase Order Approved. | ||
| FUSION_RELEASE | VARCHAR2 | 100 | The Release in which the Object Version was introduced. | ||
| PTNR_RETRIEVAL_MOD_NAME | VARCHAR2 | 256 | Module Name used to query Topology Manager to retrieve Partner Retrieval Context Root. | ||
| PARTNER_KEY_TYPE | VARCHAR2 | 100 | Application specific partner key types e.g. Customer Account, Supplier Site. | ||
| VALIDATION_PAYLOAD | CLOB | Validation Payload Template for testing Outbound Collaboration Message. | |||
| DOCUMENT_ACCOUNT | VARCHAR2 | 1024 | UCM Account under which the file is uploaded. Default value for DOO documents is FAFusionImportExport. | ||
| DOCUMENT_ID | NUMBER | 18 | Yes | Foreign key to the Collaboration Document. | |
| 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. | ||
| 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. | |
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| OBJECT_XPATH | VARCHAR2 | 2000 | This column stores the root element of e-reporting payload used in France E-Invoicing feature. | ||
| OBJECT_KEY1_XPATH | VARCHAR2 | 2000 | This column stores the transaction id used in France E-Invoicing feature. | ||
| OBJECT_KEY2_XPATH | VARCHAR2 | 2000 | This column stores the transaction number used in France E-Invoicing feature. | ||
| OBJECT_KEY3_XPATH | VARCHAR2 | 2000 | This column stores the standard used in France E-Invoicing feature. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CMK_COLLAB_DOC_OPERS | cmk_collab_docs_b | DOCUMENT_ID |
| cmk_collab_messages_b | cmk_collab_doc_opers | DOC_OPERATION_ID |
| cmk_collab_oper_labels | cmk_collab_doc_opers | DOC_OPERATION_ID |
| cmk_collab_doc_props | cmk_collab_doc_opers | DOC_OPERATION_ID |
| cmk_collab_messages_log | cmk_collab_doc_opers | DOC_OPERATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMK_COLLAB_DOC_OPERS_U1 | Unique | FUSION_TS_SEED | DOC_OPERATION_ID, ORA_SEED_SET1 |
| CMK_COLLAB_DOC_OPERS_U11 | Unique | FUSION_TS_SEED | DOC_OPERATION_ID, ORA_SEED_SET2 |
| CMK_COLLAB_DOC_OPERS_U2 | Unique | FUSION_TS_SEED | VERSION, DOCUMENT_ID, ORA_SEED_SET1 |
| CMK_COLLAB_DOC_OPERS_U21 | Unique | FUSION_TS_SEED | VERSION, DOCUMENT_ID, ORA_SEED_SET2 |