1. Introduction Last updated: July 4th 2025

1.1. Scope

This document provides an overview of the CMP 8.19 release with specific focus on the additional functional and non-functional enhancements with respect to CMP 8.18.

1.2. Audience

This document is aimed at internal and external audiences familiar with CMP, to explain the key features of the release including any changes in how existing functions or processes are working.

2. Overview of Changes

With respect to CMP 8.18, CMP 8.19 introduces new functionality as well as changes to existing functionality and non-functional improvements. These changes can be summarised as follows:

2.1. New Functionality

2.1.1. Business Configuration Orders

A new Orders section has been added to the Business Configuration console. This area supports the configuration of order-related entities and introduces context-sensitive panels for managing resource attribute list values and template associations. These enhancements provide further support for CMP’s updated order management capabilities. This section contains new screens enabling the configuration of the elements that make up an order including the Products option which has been moved from the Propositions section of Business Configuration. The following options are included:

  • Products - these are configured to be used as part of the sales order process
  • Warehouses - the warehouses used by customers
  • Sales Channels - the Sales Channels through which customers purchase products and services
  • Brands - these can be defined to allow you to configure the products available to subscribers
  • Resource Template - these contain attributes that describe the product
  • Resource Attributes - add and maintain a configurable list of values that can be associated with certain types of product items
  • Item Types - allow for the grouping of different types of hardware products
  • Order Delivery Methods - add and maintain the delivery options used by customers.

See section 3.4.1.2. below for further information.


2.1.2. Number Change Bulk Action

In CMP 8.19, a new Number Change Bulk Action has been added to allow one or more serial numbers to be changed for multiple subscriptions. These serial numbers can be managed or non-managed numbers of connected or not connected subscriptions.


2.1.3. Operation Monitoring

In CMP 8.19, a new menu option, CMP REST API Dashboard has been added to the Operation Monitoring menu option to track REST API performance, including component availability, response times, throughput, and error rates.

2.2. Changed Functionality

2.2.1. Business Configuration

The following modules have been updated to include new screens that allow users to add and maintain additional configuration data. These include:

  • The Customer Management Business Configuration menu option has been enhanced to include the following new sub-menu options:
    • Occupations - add and maintain the occupations typically used by customers
    • Titles - add and maintain the titles that can be assigned to customers
    • Account Default Values - define the parameters that are automatically applied to an account when it is created
    • ID Types - add and maintain the types of customer identification used
    • Account Serial Numbers - define the validation rules that are to be applied when creating account serial numbers
    • Industrial Classifications - categorise a business based on their primary economic activity
    • Attribute Group - these are used to group a number of attributes, which describe generic customer related attributes
    • Salespersons - add and maintain the salespersons used in creating and upgrading subscriptions.
  • The Billing Business Configuration menu option has been enhanced to include the following new sub-menu options:
    • Billing Media - configure the different formats available for invoices, statements and itemised bills.
    • External Charge Cross References - configure the mappings between third party charges and CMP service codes which are used to facilitate billing of external charges in CMP.
  • Payments Business Configuration menu option has been enhanced to include the following new sub-menu options:
    • Payment Terms - add and maintain the payment terms that represent the terms of payment agreed to by the customer.
    • Payment Term Defaults - define a payment term with a selected payment type to be used as the default when creating accounts.
  • System Configuration Business Configuration menu option has been enhanced to include the following new sub-menu options:
    • Units of Measure - add and maintain the formats used to represent usage in a readable format for agents and on customer bills.
    • Security Levels - define the levels of authority required.

2.2.2. Offline Shared Allowances

The handling of shared allowance limits for offline subscriptions has been enhanced to align with the behaviour already available for online subscriptions. This includes support for setting and retrieving percentage-based usage limits per subscription, as well as improvements to data handling and group membership visibility. These changes apply across AgentView, REST APIs, and background jobs, and simplify how shared group limits are managed across network types.


2.2.3. Web Services Changes

2.2.3.1. RESTful Web Services

The following web services have been modified in CMP 8.19:

  • the Product Attribute metadata has been removed from the GET Compatible Packages and GET Compatible Price Plans web service responses.
  • the POST Orders web service request has been modified to include a product offering identifier to distinguish between a product code and product offering ID. The product offering ID allows for the addition of resource attributes.
  • the GET Orders List web service has been modified to return a list of orders for an Account based on a new order date filter.

3. Impacts on CMP

The functional and non-functional changes highlighted in section 2 above have had an impact CMP in the following areas:

3.1. AgentView

3.1.1. New Screens

No new AgentView screens have been introduced as part of CMP 8.19.


3.1.2. Changed Screens

No AgentView screens have been changed as part of CMP 8.19.


3.1.3. Changed Functionality

3.1.3.1. AgentView Cut & Paste

In CMP 8.19, the audit workflows raised during AgentView cut and paste have been refactored and although the behaviour experienced by the user is unchanged, there are configuration changes to support this. Previously, the workflows were configured via the Cut/Paste Default table, but for CMP 8.19, the configuration is now managed through the Workflow Event Properties option in Business Configuration. See sections 6.4.3 and 6.5.2.1 for further information on the dropped table and the updated configuration requirements.

3.1.3.2. Shared Allowances – AgentView Support for Offline Limits

CMP 8.19 extends AgentView to include management of shared allowance limits for offline subscriptions. This brings offline functionality in line with what is already available for online networks. Key updates include:

  • Agents can now view and set percentage-based consumption limits for offline subscriptions consuming from shared voice, text, or data allowances.
  • Limit entry is done using the same Update Shared Limits action already used for online subscriptions.
  • Offline subscriptions will only reflect limits that apply to their applicable allowance types.
  • Once a subscription is removed from a shared group, any shared allowances related to that group are no longer visible in AgentView.
  • These changes apply to both viewing and updating offline shared group membership and limits.

3.2. Bulk Actions

3.2.1. New Bulk Actions

3.2.1.1. Number Change Bulk Action

A new Number Change bulk action has been added to the Bulk Action Console in CMP 8.19. This action allows for the update of one or more serial numbers across multiple subscriptions using a structured template and the standard Bulk Action batch submission process. Key features include:

  • Support for both managed and non-managed serial number changes
  • Used for both connected and not connected subscriptions
  • Validates number rules including format, prefix, and duplicate submissions
  • Prevents changes for terminated or disconnected subscriptions
  • Provides audit logs showing both successful and failed updates for each batch
  • Allows for the option to blank out serial numbers where permitted.

Other enhancements include:

  • New Excel template supporting up to 5 managed and 9 non-managed number updates per batch
  • The Sales account search uses a modernised UI component for improved filtering
  • Access control is enforced via a new WSO2 role: bulk-number-change.

3.2.2. Changed Bulk Actions

No bulk actions have been changed as part of CMP 8.19.

3.3. Admin Console

3.3.1. Daily Operations

3.3.1.1. New Jobs and Daemons

No new jobs and daemons have been introduced as part of the CMP 8.19 release.

3.3.1.2. Changed Jobs and Daemons

No jobs or daemons have been changed as part of the CMP 8.19 release.

3.3.1.3. Deprecated Jobs and Daemons

No jobs or daemons have been deprecated as part of the CMP 8.19 release.


3.3.2. System Management

No changes have been made to any of the options within the System Management menu option in CMP 8.19.


3.3.3. System Monitoring

3.3.3.1. Operation Monitoring

CMP 8.19 extends the existing capability of monitoring overall system performance by adding a new dashboard reporting REST API performance metrics. It includes:

  • API request and response volumes, to understand usage patterns and detect surges or drops in traffic
  • Response times, which measures how quickly APIs return data, including average, P95, and P99 latency
  • Error rates and status codes, to identify issues such as failed authentications, timeouts, or server errors
  • Throughput and Availability, which tracks whether APIs are reachable and functioning.

3.3.3.2. Message Queues

In CMP 8.18, some of the names configured for inbound and outbound message queues were inconsistent and caused confusing. In CMP 8.19, improvements have been made to standardise on the naming consistency across message queue names. These changes affect only the names of the queues — the daemon functionality and behaviour remains unchanged.

The updated queue names are as follows:

  • Comms External Extract Daemon
    • Old name: commsexternal
    • New name: outboundCommsExternal
  • External Comms Load Daemon
    • Old name: commsExternal
    • New name: inboundCommsExternal
    • Old name: commsExternalError
    • New name: inboundCommsExternalError
  • Push to Handset Transmission Daemon
    • Old name: commspush
    • New name: outboundCommsPush

These queues are now created with the updated names automatically.

Important

Any third-party systems consuming from the previous queue names must be updated accordingly to continue receiving messages.


3.3.4. System Configuration

No changes have been made to any of the options within the System Configuration menu option in CMP 8.19.


3.3.5. System Administration

3.3.5.1. Users

In CMP 8.19, a new bulk action role, Bulk Number Change has been added to the Bulk Action Console tab in the Add and Edit User screens.

3.4. Business Configuration

3.4.1. New Business Configuration Screens

3.4.1.1. New CRUD Panels

CMP 8.19 introduces a range of new CRUD (Create, Read, Update, Delete) panels within Business Configuration. These panels provide UI-based configuration of various reference data items that previously required direct database access to configure them. This enhancement streamlines administrative processes and improves accessibility for system administrators.

The following new panels have been added:

  • Occupations - types of jobs or professional roles held by individuals who use or purchase a company’s products or services.
  • Titles - formal prefixes used before a person's name to indicate respect, marital status, professional/academic qualifications, and so on.
  • Unit of Measure Formats - the formats used to represent usage in a readable format for agents and on customer bills.
  • Account Default Values - preconfigured settings or parameters that are automatically applied to an account when it is created.
  • ID Types - types of customer identification, for example, driving license, passport, that is used when capturing a personal address.
  • Billing Media - define different formats available for invoices, statements and itemised bills, for example, A4 paper, braille, online billing etc.
  • Delivery Methods - define delivery day options which are used when customers order products.
  • Payment Terms - the rules that define how, when, and by what method a customer is expected to pay for goods or services.
  • Payment Term Defaults - refers to the automatically applied conditions that define when a payment is due for an invoice.
  • Salespersons - a salesperson is responsible for selling products or services to customers, as well as understanding customer needs in order to present suitable offerings, and close sales to generate revenue for the business.
  • Account Serial Validations - supports the define the validation rules that are to be applied when creating account serial numbers.
  • Industrial Classifications - used to categorise businesses based on their primary economic activity, enabling more effective creation and management of business customer profiles.
  • Item Types - allows different types of hardware products to be grouped.
  • External Charge Cross References - mappings between third party charges and CMP service codes which are used to facilitate billing of external charges in CMP.
  • Attribute Groups - definition of groupings of customer attributes.
  • Security Level - CMP security has 9 levels of authority. Each CMP user is assigned one of those levels, as are all of the features the user has access to.

3.4.1.2. New Orders Panels

CMP 8.19 introduces a new Orders section within the Business Configuration console. This addition supports the configuration of key entities used in the CMP ordering process and provides a centralised location for defining order-related configuration.

The following new panels have been introduced under the Orders section:

  • Brands – Maintains the list of brands (manufacturers) used within product definitions
  • Brand Item Types – Enables brands to be linked to item types (accessed via the Brands panel)
  • Models – Stores product model details including brand association (accessed via the Brands panel)
  • Warehouses – Maintains configuration for warehouse locations used in the fulfilment process
  • Sales Channels – Defines the channels through which products can be sold or distributed
  • Resource Templates – Allows the creation of templates used to group resource attributes for reuse
  • Resource Attributes – Defines the individual attributes that can be used to capture structured product or order data.

In addition, two context-sensitive panels have been introduced:

  • Resource Attribute List Values – Allows for list values to be defined against a resource attribute, when the attribute type is set to List.
  • Resource Template Attribute – Enables attributes to be linked to a specific resource template.

3.4.1.3. Add Product Panel

A new Add Product panel has been added to the Orders section of Business Configuration. This panel provides a structured and comprehensive form to define hardware products that contain a single item. Key features of the Add Product panel include:

  • Selection of Item Type, Brand, and Model (filtered by selected brand)
  • Ability to specify Product Description, Version, and Warehouse
  • Date range controls for Effective Date and Expiry Date
  • Definition of Minimum, Maximum, and Default Price
  • Entry of Upfront and Instalment Hardware Costs
  • Dynamic resource attributes based on the selected Resource Template.

All relevant data is written to the Product, Item, and Product Item tables upon creation.


3.4.2. Changed Business Configuration Screens

3.4.2.1. Propositions – Attributes & Products

The Attributes and Products panels have been removed from the Propositions section of Business Configuration. It should be noted that the removal of these panels is also reflected in the underlying database structure — associated tables have been dropped as part of this release (see section 6.4.3 for details).

3.4.2.2. Workflows

Minor usability and labelling updates have been applied across various Workflow panels in the Business Configuration console:

  • In the Event Type List panel, column label corrected to Corporate Level
  • In the View Event Type panel, Associated Reason Codes: is now correctly left-aligned beneath the Explanation field
  • In the View Event Code panel, under the Main tab, the Default Reason Code and Default Workflow fields now remain blank when not populated
  • In the View Event Code panel, Status After Confirmation configured as Pending Auto Processing is now correctly displayed as such.

3.4.2.3 Products

The Products option has been relocated from the Propositions section to the newly introduced Orders section within the Business Configuration console. This change reflects the product's closer alignment with order-related configuration and supports the restructuring of the ordering domain introduced in CMP 8.19.

3.4.2.4. Add Panels

To improve consistency across the Business Configuration and Pricing Configuration applications, the behaviour of the Add Panel input fields has been standardised where a code entry is required. Previously, some panels enforced upper case input for code fields while others allowed mixed case. From CMP 8.19 onward, all relevant panels have been updated to enforce upper case entry in the code fields.

The panels updated to enforce upper case code entry are as follows:

  • Propositions Menu Option
    • Price Plan
    • Price Plan Group
    • Tariff
    • Package
    • Service
    • Discount
  • Comms Menu Option
    • Default Fields
  • Network Menu Option
    • Network Command
    • Network Command Group
    • Network Features.

3.5. Pricing Configuration

3.5.1. New Pricing Configuration Screens

No new pricing configuration screens have been introduced as part of CMP 8.19.


3.5.2. Changed Pricing Configuration Screens

No pricing configuration screens have been changed as part of CMP 8.19.

3.6. SOAP Web Services

3.6.1. New Web Services

No new SOAP web services have been introduced as part of the CMP 8.19 release.


3.6.2. Changed Web Services

No SOAP web services have been changed as part of the CMP 8.19 release.

3.7. RESTful Web services

3.7.1. New CMP Web Services

No new RESTful web services have been introduced as part of the CMP 8.19 release.


3.7.2. Changed CMP Web Services

The following web services have been enhanced for CMP 8.19:

3.7.2.1. Get Orders Web Service

The existing Get Orders web service has been enhanced to support filtering based on the order date. This improvement allows for more precise and efficient querying of order data by enabling retrieval of only orders that meet specific date-based criteria.

To enable this, a new filter has been introduced that supports the following comparative operations on the order date:

  • Less than
  • Less than or equal to
  • Equal to
  • Greater than or equal to
  • Great than.

3.7.2.2. Update Shared Limits Web Service

The existing Update Shared Limits REST API has been extended to support offline shared allowances.

  • It is now possible to define percentage-based consumption limits for offline subscriptions consuming from shared voice, SMS, or data allowances
  • Limits are recorded against each applicable allowance type
  • Once submitted, the shared limit percentage is used by Allocation Monitor to calculate and enforce the actual value across one or more underlying allowance records
  • No workflow is raised for offline network changes, as these are handled internally.

3.7.3. New Business Configuration Web Services

No new Business Configuration RESTful web services have been introduced in CMP 8.19.


3.7.4. Changed Business Configuration Web Services

No RESTful web services have been updated as part of the CMP 8.19 release.


3.7.5. New TM Forum Open APIs

The CMP 8.19 release supports the TM Forum API set around Product Ordering Management conformance. This has been certified by the TM Forum against the TMF622 API specification.

3.8. Integration Adapters

No changes have been made to integration adapters in CMP 8.19.

3.9. NetEngage Adapters

The NetEngage-specific adapters are optional components of the CMP deployment that are based on the licence agreement with MDS Global.

No changes have been made to the NetEngage adapters in CMP 8.19.

3.10. UK-specific Adapters

No changes have been made to UK-specific adapters in CMP 8.19.

4. Product Fixes

In addition to functional and non-functional changes and improvements, the CMP 8.19 product version also addresses a number of application support issues. This section provides a summary of the issues fixed in this release.

The following issues have been addressed within this release:

Reference Area Description
CMPIS-1908RESTful Web ServicesError handling improvements – correct error now returned when the Get Purchases request contains more than one filter or contains an invalid reference (i.e. subscription number, agreement number, account number).
CMPIS-2607Sabre ServerSystem Monitoring - Selecting a message queue and using the purge option now works correctly to purge all messages from a queue. In addition, selecting a message on the queue and deleting it individually now works as expected.
CMPIS-3048Bulk ActionInvalid subscription in batch now handled as record level error so only the incorrect record fails.
CMPIS-3200RESTful Web ServicesPurchase TopUp REST – Resolved an issue with how card expiry dates are handled.
CMPIS-3326RESTful Web ServicesCreate Administrator REST – endpoint updated from /agreements/createAdministrator to /agreements/administrator.
CMPIS-3327RESTful Web ServicesGet Allowances REST – The filter on agreement number changed from agreementId.exact to agreementNumber.exact.
CMPIS-3328RESTful Web ServicesGet Allowances Summary REST – The filter on agreement number changed from agreementId.exact to agreementNumber.exact.
CMPIS-3348Credit ControlIssue resolved for when the job runs in ‘Report’ mode to ensure report created as expected in correct outbound directory.
CMPIS-3363Sabre ServerWSO2 vulnerabilities addressed.
CMPIS-3366Business ConfigurationAdd Allowance – Data & Voice Allowances – inconsistencies around how the allowance amount is entered and stored have been resolved.
CMPIS-3368ProvisioningDuplicate records were being created by the Provisioning Extract Daemon in some cases, fix ensures that only one record per command is created.
CMPIS-3371Business ConfigurationAdd Package Service – minor changes to how the price field is displayed upon initial entry to the panel and when a service is selected from the dropdown list.
CMPIS-3382Business ConfigurationCreate Price Plan – fixed an issue whereby an error was being displayed when creating a new price plan.

5. Documentation

5.1. Product Documentation

The product documentation is available online on the documentation portal. This online portal requires authorised access, which can be obtained by contacting MDS Global support. The documentation is also available as downloadable PDFs as follows:

  • Installation Guide
  • Technical Architecture
  • CMP Overview
  • Documentation Overview
  • System Administration Guide
  • Security Guide
  • AgentView Function Security Guide
  • Operational Overview
  • Business Configuration Overview
  • Billing Functionality Guide
  • Communications Functionality and Configuration Guide
  • Propositions Functionality and Configuration Guide
  • Payments Functionality Guide
  • Extracts Guide
  • Purge Guide
  • Standard Reporting
  • Batch Jobs and JSON Schemas Guide
  • RESTful Web Services API Guide
  • SOAP Web Services Semantics Guide
  • Business Configuration RESTful Web Services API Guide
  • Glossary.
Document Version Document Changes
AgentView Function Security Guide 1.1 The screens have been updated to reflect the new MDS logo and branding colours in the AgentView Function Security Guide for CMP 8.19.
Batch Jobs and JSON Schemas Guide 1.1 The Batch Jobs and JSON Schemas Guide has been updated to include the changes to the jobs and daemons highlighted above.
Billing Functionality Guide 1.0 There are no updates to the Billing Functionality Guide as part of CMP 8.19.
Business Configuration Overview 1.0 Added new configuration functionality that allows users to add, edit, and view additional CMP configuration data.
Business Configuration RESTful Web Services API Guide 1.0 There are no updates to the Business Configuration RESTful web services guide as part of CMP 8.19.
CMP Overview 1.0 Updated the business configuration and product catalogue to include the new configuration functionality that allows users to add, edit, and view additional CMP configuration data.
Communications Functionality and Configuration Guide 1.0 There are no updates to the Communications Functionality and Configuration Guide as part of CMP 8.19.
Documentation Overview 1.0 There are no updates to the Documentation Overview as part of CMP 8.19.
Extracts Guide 1.0 There are no updates to the Extracts Guide as part of CMP 8.19.
Glossary 1.0 There are no updates to the Glossary as part of CMP 8.19.
Installation Guide 1.0 There are no updates to the Installation Guide as part of CMP 8.19.
Operational Overview 1.0 Updated the Operation Monitoring topic to include the new interactive dashboards that monitor the infrastructure and application performance in CMP.
Payments Functionality Guide 1.0 There are no updates to the Payments Functionality Guide as part of CMP 8.19.
Propositions Functionality and Configuration Guide 1.0 There are no updates to the Propositions Functionality and Configuration Guide as part of CMP 8.19.
Purge Guide 1.0 There are no updates to the Purge Guide as part of CMP 8.19.
RESTful Web Services API Guide 1.1 The REST web services guide has been updated based on the changes highlighted in sections 3.7.1 above.
Security Guide 1.0 There are no updates to the Security Guide as part of CMP 8.19.
SOAP Web Services Semantics Guide 1.0 There are no updates to the SOAP Web Services Semantics Guide as part of CMP 8.19.
Standard Reporting 1.0 There are no updates to the Standard Reporting Guide as part of CMP 8.19.
System Administration Guide 1.0 There are no updates to the System Administration Guide as part of CMP 8.19.
Technical Architecture 1.0 Updated the Spring Framework, Spring Boot, Spring Batch, Spring Security and Tomcat versions.

5.2. Online Documentation

Online help is available in AgentView, Business Configuration, the Administration Console, the Bulk Actions and the Pricing Configuration console. The following table summarises the current versions of the online help and the changes since CMP 8.18:

Online Help Version Document Changes
AgentView 1.9 There are no updates to AgentView in CMP 8.19.
Business Configuration 1.23 An Orders topic has been added to cater for the new configuration screens that have been added to Business Configuration in 8.19 to enable users to create, read, update and delete additional CMP configuration data. In addition, new topics have been added to the following modules to cater for the new configuration screens:
  • Customer Management
  • Billing
  • Payments
  • System
Administration Console 1.21 New dashboards have been added to the Administration Console as part of CMP 8.19 to cater for the Grafana dashboard functionality. The Operation Monitoring topic has been updated to include these interactive dashboards that monitor the infrastructure and application performance in CMP.
Pricing Configuration Console 1.8 There are no updates to the Pricing Configuration Console as part of CMP 8.19.
Bulk Action Console 1.12 A Number Change topic has been added to the Bulk Action Console help in CMP 8.19.

6. Release Upgrade

The CMP 8.19 installer includes the capability to upgrade a CMP 8.18 installation without the loss of configuration or customer data provided that the software, file system and database structure of the installation in question are at no point manually modified.

Important

The CMP 8.19 Installation Guide, and the details below, should be read before attempting the upgrade to CMP 8.19.

It is important that the following sections are read prior to performing the upgrade, specifically the Configuration Changes section, as it may be advisable to backup relevant configuration prior to performing the upgrade to ensure the configuration can be replicated, if necessary, post upgrade.

6.1. Upgrade Notes

Important

As highlighted in section 3.3.3.2 above, some existing message queues that are used for external system communication have been updated to a naming standard that is consistent with other queue names. After upgrade to CMP 8.19 the application will automatically create the new queues and start writing messages to them. It is important therefore that any third-party systems consuming from the previous queue names are updated accordingly to continue receiving messages.

Important

CMP 8.19 and future versions of CMP will allow any version from CMP 8.16.1 to be upgraded to the latest version of CMP in a single upgrade. This will be automatically handled by the installer based on the current version of CMP already installed.

6.2. Installation Configuration Tool Changes

A new property Prometheus JMX Exporter Port has been added to the Prometheus section of the Installation Configuration Tool to allow the port to be specified for the JMX exporter. This is defaulted to port 9101.

6.3. Third party libraries

The following third-party libraries have been updated as part of the CMP 8.19 release:

  • Spring Framework has been upgraded from version 5.3.28 to version 5.3.31
  • Spring Boot has been upgraded from version 2.7.13 to version 2.7.18
  • Spring Batch has been upgraded from version 4.3.8 to version 4.3.10
  • Spring Security has been upgraded from version 5.7.9 to version 5.8.16 for the Sabre Server, Bulk Action Console and REST
  • Tomcat has been upgraded from version 9.0.76 to version 9.0.100.

6.4. Database Changes

6.4.1. New Tables and Views

The following table has been added in CMP 8.19:

  • model - Stores the model of hardware products
  • brandItemType - This table indicates the item types that are valid for a particular brand
  • productSpecificationAttributeValue - This table allows for resource attribute values to be stored against individual products
  • productOfferingAttributeValue - This table allows for resource attribute values to be stored against individual product offerings
  • orderAttributeValue - This table allows for resource attribute values to be stored against individual orders
  • itemProductLevel - This table for CMP entities i.e. price plans, serial numbers, to be presented as products in the product catalogue
  • productOfferingPrice - This table stores pricing information about the products in the product catalogue
  • productOfferingRecurringHardwarePrice - This table stores additional pricing information about hardware products that are paid over the duration of a contract
  • sharedLimitUpdate - This table is used to enforce a limit for a subscription to a shared allowance
  • productUploadInterfaceBatchHeader - This is a staging table that holds attribute details i.e. sales channel, offering start date, that apply to a batch of product offerings that are being uploaded via the Aurora console.
  • productUploadInterfaceBatchDetail - This is a staging table that holds the product details uploaded for a particular product data upload
  • productUploadAttributeBatchDetail - This is a staging table that holds attribute information about the products uploaded into CMP.

6.4.2. New Attributes

The following table attributes have been added in CMP 8.19:

  • Table CSNOREP (item), attributes brandCode, modelCode, version
  • Table CSQAREP (orderLine), attribute productOfferingIdentifier
  • Table CSNLREP (productItem), attributes upfrontPayment, installmentPayment, isPrimary
  • Table productOffering, attribute productOfferingPriceIdentifier
  • Table orderFulfilmentAttributeValue, attibutes auditUser, AuditProcess, AuditTimestamp
  • Table CSOTREP (warehouse), attribute isDefault
  • Table CSQ4REP (itemType), attributes companyNumber, resourceTemplateCode
  • Table CSQAREP (orderLine), attribute productOfferingIdentifier.

6.4.3. Dropped Tables and Views

The following tables or views have been dropped in CMP 8.19:

  • Table CZICREP (Cut/Paste Defaults) – this table previously controlled workflow configuration for the AgentView hierarchy cut and paste feature. As of CMP 8.19, this logic has been migrated to the Diary Event Properties table (also see section 6.5.2 Module Configuration Updates).
  • Table C4JVREP (Analyser Extract Params) - this table has been deprecated as the information previously stored here is now maintained as job properties.
  • Table sharedLimitUpdateRequest has been superseded by the sharedLimitUpdate table
  • Table CKA2CPP (Resource Target) has been renamed to orderFulfilmentAttributeValue
  • Table Manufacturer has been renamed to Brand.
  • In addition, the following legacy tables have been deprecated as the information that would have been on these tables will be stored in resource attribute tables instead:
    • Table CVBIREP (Product Attribute)
    • Table CVBJREP (Product Attribute Group)
    • Table CVBLREP (Product Attribute Value)
    • Table CVBHREP (Product Template)
    • Table CVBKREP (Product Template Attribute)
    • Table CVBMREP (Product Level Attribute)
    • Table CVBOREP (Product Level Template)

6.4.4. Dropped Attributes

The following attributes have been dropped in CMP 8.19:

  • Table COIWREP (Account Default Values), multiple attributes
  • Table orderFulfilmentAttributeValue, attributes A2AUVN, (Created by Program), A2AVTM, (Time Created), A2AVVN, (Changed by Program), A2AWTM, (Time Changed), A2CKTX, (Created by DISE User ID), A2CMTX, (Changed by DISE User Id), A2EJDT, (Date Created), A2EKDT, (Date Changed)
  • Table CSNOREP (item), attibute manufacturerCode
  • Table productOffering, attribute productPriceTemplateCode

6.4.5. Modified Attributes

As part of CMP 8.19, the following table attributes have been modified in CMP 8.19:

  • Table usageBatchDetail, attribute usageClassificationKey has been changed to VARCHAR(200)
  • Table CSN0REP (product), attribute N0AVTY (productDescription) has been changed to VARCHAR(250)
  • Table CSNKREP (category), attribute NKCICD (companyNumber) has been changed to CHAR(3)
  • Attribute CustomerReference has been changed to VARCHAR(25) on the tables CSOQREP (order), interfaceBatchDetail, purchaseProduct, purchaseProductError, requestApproval, subscriptionServicePurchaseProduct, productOffering, genericExtractIncludeExclude, commsRequestTargetDetail, customerCommsProfile, customerCommsPreference, triggerNotifiction, commsRequestTargetDetail, quickJobTrigger, AdvanceNotification

6.5. Configuration Changes

6.5.1. Automatic Updates

As part of the upgrade to CMP 8.19 the following configuration changes have been automatically applied:

6.5.1.1. Bulk Action Application Access

The following application group has been added to the applicationGroup table to allow access to specific bulk actions:

  • bulk-number-change

Important

To enable a user to have access to the Number Change bulk action, access to this option will need to be enabled through the System Administration->User option within the Administration Console, or directly through WSO2 for the specific user.

6.5.2. Manual Configuration

6.5.2.1. Workflow Properties

In CMP 8.19, the audit workflows raised during AgentView cut and paste have been refactored. Previously, these workflows were configured via the Cut/Paste Default table. From this release onward, the configuration will be managed via the Workflow Event Properties.

To support this update, new workflow event property records must be manually configured in Business Configuration (System – Workflow Properties):

Property GroupProperty NameEvent TypeEvent Code
AGENTVIEW_CUT_PASTEsubscriptionWorkflow Event Type of the event to be raised when moving a subscriptionWorkflow Event Code of the event to be raised when moving a subscription
AGENTVIEW_CUT_PASTEaccountWorkflow Event Type of the event to be raised when moving an accountWorkflow Event Code of the event to be raised when moving an account
AGENTVIEW_CUT_PASTEcorporateWorkflow Event Type of the event to be raised when moving a corporateWorkflow Event Code of the event to be raised when moving a corporate