CMK_SERVICE_PROVIDERS_B
This table provides the Service Provider Setup details. A Provider of Collaboration Services who serves as an intermediary in messaging between Fusion Applications and external Trading Partner.
Details
-
Schema: FUSION
-
Object owner: CMK
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CMK_SERVICE_PROVIDERS_B_PK |
SERVICE_PROVIDER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SERVICE_PROVIDER_ID | NUMBER | 18 | Yes | Primary key of the Service Provider. | |
| DEL_STATUS_UPDATE_ENABLED | VARCHAR2 | 1 | Flag to indicate whether the service provider is enabled to provide message processing status. | ||
| USER_DEFINED | VARCHAR2 | 1 | Flag to indicate whether the service provider was created by the user or not. | ||
| PREDEFINED_ENDPT_IND | VARCHAR2 | 1 | Flag to Indicate if the endpoints are pre-seeded for the service provider. | ||
| OBN_ID | VARCHAR2 | 100 | OBN ID is required to be specified in order to use OBN. The column stores the ID entered by user to use their OBN account. | ||
| SERVICE_PROVIDER_NAME | VARCHAR2 | 256 | Yes | Name of the Service Provider e.g. E2OPEN. | |
| SP_EXT_PARTNER_ID | VARCHAR2 | 256 | Autogenerated value that when combined with the Partner ID type is used to identify the service provider uniquely | ||
| EXT_PARTNER_ID | VARCHAR2 | 100 | ID of the Service Provider in B2B. | ||
| EXT_PARTNER_ID_TYPE | VARCHAR2 | 100 | The type of ID e.g. DUNS. | ||
| FROM_PARTNER_ID_TAG | VARCHAR2 | 512 | A Tag used in protocol headers to identify the partner sending the message. | ||
| FROM_PARTNER_ID_TYPE_TAG | VARCHAR2 | 512 | A Tag used in protocol headers to identify the ID Type of the partner sending the message. | ||
| TO_PARTNER_ID_TAG | VARCHAR2 | 512 | A Tag used in protocol headers to identify the partner to whom the message is being sent. | ||
| TO_PARTNER_ID_TYPE_TAG | VARCHAR2 | 512 | A Tag used in protocol headers to identify the ID Type of the partner to whom the message is being sent. | ||
| EXT_MSG_TYPE_TAG | VARCHAR2 | 512 | External Message Type Tag use for outbound Headers to identify from Partner. | ||
| EXT_MSG_VERSION_TAG | VARCHAR2 | 512 | External Message Type Version Tag use for outbound Headers to identify from Partner. | ||
| EXT_MSG_STANDARD_TAG | VARCHAR2 | 512 | External Message Type Standard Tag use for outbound Headers to identify from Partner. | ||
| SERVICE_PROVIDER_ID_TAG | VARCHAR2 | 512 | Service Provider ID Tag use for outbound Headers to idenfity from Partner. | ||
| 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. | ||
| MSG_EXCHANGE_STANDARD | VARCHAR2 | 100 | Standard of the message exchanged by the service provider. | ||
| 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. | |
| SP_CATEGORY | VARCHAR2 | 256 | Identifies the category of the service provider. | ||
| ATTCH_PROCESS_MTHD | VARCHAR2 | 100 | Determines where message attachments are located within the B2B message. The attachments may be sent as embedded binary content within the payload element of the message, or in the attachment element or as a MIME part outside of the B2B message. | ||
| CONNECTION_TYPE | VARCHAR2 | 100 | Indicates the outbound delivery method connection type i.e., test or production | ||
| ELECTRONIC_INVOICE_BU | VARCHAR2 | 512 | This column stores Electronic Invoicing Business Unit name for France E-Invoicing feature. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cmk_delivery_methods | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| cmk_application_partners | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| cmk_delivery_rules | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| cmk_account_numbers | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| cmk_external_partners | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| cmk_collab_messages_log | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| cmk_external_ptnr_msgs_b | cmk_service_providers_b | SERVICE_PROVIDER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CMK_SERVICE_PROVIDERS_B_U1 | Unique | FUSION_TS_SEED | SERVICE_PROVIDER_ID, ORA_SEED_SET1 | |
| CMK_SERVICE_PROVIDERS_B_U11 | Unique | FUSION_TS_SEED | SERVICE_PROVIDER_ID, ORA_SEED_SET2 | |
| CMK_SERVICE_PROVIDERS_B_U2 | Unique | FUSION_TS_SEED | SERVICE_PROVIDER_NAME, ORA_SEED_SET1 | Obsolete |
| CMK_SERVICE_PROVIDERS_B_U21 | Unique | FUSION_TS_SEED | SERVICE_PROVIDER_NAME, ORA_SEED_SET2 | Obsolete |
| CMK_SERVICE_PROVIDERS_B_U3 | Unique | FUSION_TS_SEED | SERVICE_PROVIDER_NAME, USER_DEFINED, ORA_SEED_SET1 | |
| CMK_SERVICE_PROVIDERS_B_U31 | Unique | FUSION_TS_SEED | SERVICE_PROVIDER_NAME, USER_DEFINED, ORA_SEED_SET2 |