CMK_COLLAB_MSG_PARAMS
A data store for Collaboration Messaging Parameters.
Details
-
Schema: FUSION
-
Object owner: CMK
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CMK_COLLAB_MSG_PARAMS_PK |
MSG_PARAM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MSG_PARAM_ID | NUMBER | 18 | Yes | Primary key of the Collaboration Messaging Parameters. | |
| NUM_LINES_RET_SIN_QUERY | NUMBER | 4 | PO Lines Retrieved in a Single Query | ||
| LARGE_PO_MIN_LINE_COUNT | NUMBER | 6 | Defines the minimum line count of a large purchase order and the maximum number of lines retrieved at a time when processing a large purchase order. | ||
| LARGE_PO_DEL_RET_DUR | NUMBER | 3 | Duration of time in minutes to attempt delivery of large purchase orders. | ||
| LARGE_PO_ATTEMPT_RET_INT | NUMBER | 3 | Defines the interval in minutes to attempt delivery of large purchase orders. | ||
| MSG_HISTORY_DEFAULT_DUR | NUMBER | 5 | This parameter configures the number of hours collaboration message history records to be displayed in Manage Collaboration Messaging History on the history page landing. | ||
| STORE_OUT_INPUT_FLAG | VARCHAR2 | 10 | Store Outbound Input Flag is used to verify outbound processing composite to store Input payload in Mesage Log. | ||
| STORE_OUT_OUTPUT_FLAG | VARCHAR2 | 10 | Store Outbound Output Flag is used to verify outbound processing composite to store Input payload in Mesage Log. | ||
| STORE_IN_INPUT_FLAG | VARCHAR2 | 10 | Store Inbound Input Flag is used to verify inbound processing composite to store Input payload in Mesage Log. | ||
| STORE_IN_OUTPUT_FLAG | VARCHAR2 | 10 | Store Inbound Output Flag is used to verify inbound processing composite to store Input payload in Mesage Log. | ||
| GLOBAL_SENDER_ID | VARCHAR2 | 64 | Global Sender Identifier of the Collaboration Messaging Framework. | ||
| GLOBAL_SENDER_ID_TYPE | VARCHAR2 | 100 | Global Sender Identifier Type of the Collaboration Messaging Framework. | ||
| ELECTRONIC_ORDER_SRC_SYS | VARCHAR2 | 100 | The source system name that is defaulted for inbound order processing. | ||
| UCM_DOC_SECURITY_GRP | VARCHAR2 | 100 | The security group that determines user privileges for accessing documents in UCM. | ||
| INVOICE_OUT_PER_THREAD_COUNT | NUMBER | 18 | The number of invoices processed by each thread in outbound invoice processsing. | ||
| 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. | ||
| MAX_OUT_ATTACHMENT_SIZE | NUMBER | 3 | Yes | Maximum attachment size limit in MB. | |
| MAX_MSG_PAYLOAD_SIZE | NUMBER | 3 | This column determines whether or not the payloads (both original and transformed) get logged during processing. | ||
| ESS_OUT_REP_INTERVAL | NUMBER | 5 | Auto Retry Job Interval. | ||
| AUTO_REP_TIME_PERIOD | NUMBER | 5 | Time period of record selection for automatic reprocess of messages. | ||
| ESS_OUT_ENABLE_FLAG | VARCHAR2 | 1 | Flag to enable or disable the outbound reprocessing mechanism. | ||
| DEFAULT_SEARCH_LOCATION | VARCHAR2 | 100 | Default search location for Trading Partner | ||
| MULTI_IN_MSGS_WAIT_DUR | NUMBER | 3 | Minimum duration in minutes that a message must be in the status of In-Process before an attempt to reprocess it. | ||
| MAX_MSG_IN_PAYLOAD_SIZE | NUMBER | 2 | Maximum size (in MB) ofthe inbound message payload that is logged, any payloads that are above this value in size will not be logged | ||
| MIN_INPROCESS_TIME | NUMBER | 3 | Minimum length of time that an outbound message may be in-process before any action can be performed on it. | ||
| IN_DOC_SETUP_REQUIRED | VARCHAR2 | 1 | This column determines whether or not B2B setup is required for inbound documents. The default value is Y. | ||
| SUPPLIER_LEVEL_ACC_SETUP | VARCHAR2 | 1 | This flag enables the Account Number setup at Supplier Level, otherwise at Supplier Site level. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMK_COLLAB_MSG_PARAMS_U1 | Unique | FUSION_TS_SEED | MSG_PARAM_ID, ORA_SEED_SET1 |
| CMK_COLLAB_MSG_PARAMS_U11 | Unique | FUSION_TS_SEED | MSG_PARAM_ID, ORA_SEED_SET2 |