AMPS 2.18 Release

Last updated
Save as PDF

Overview

Enhancements and fixes to Aria Media Publishing Suite (AMPS) for this release are described below.

Release Date

17 April 2023

Release 2.18 Contents

New and Improved Functionality
1. BMD-12651 Remove OCR string on CC and MP dunning emails (WFAMPS-3935)
2. ERP refund file: changes to documentNo and outAccountNo fields (WFAMPS-3916)
Application Fixes

New and Improved Functionality

This section covers the release notes related to new functionality and capabilities added to AMPS. For this release no new enhancement has been developed.

BMD-12651 Remove OCR string on CC and MP dunning emails (WFAMPS-3935)

Existing process has been amended to exclude the OCR string from notification emails where payOptionID is CCARD and MOBILEPAY

ERP refund file: changes to documentNo and outAccountNo fields (WFAMPS-3916)

To fix this, length for documentNo has been limited to 32 characters. outAccountNo field name has been changed to ourAccountNo

Application Fixes

This version sees the following application fixes deployed:

Error when changing Billing Group from Net Terms to Payment Method (WFAMPS-3958)

To fix this issue acctManageBillingGroup API has been updated to support removing and adding new collection groups associated with each title code when moving from methods to net terms.

Custom Rates not setting for PRICE-PERIOD (WFAMPS-3995)

To fix this issue, process is updated to set supplemental field in Aria only when there is a change scheduled in price. This will allow to update prices with a margin of only 1 day.

Payment File Processing Code Change (WFAMPS-3933)

To fix this issue, PayEx file processing has been updated to continue processing of the file even when it finds transactions that are in COMPLETED status. A new counter has been added in file processing output showing the number of records having COMPLETED status.

Processing new credit notes in ERP uses account number from input parameter even when not used (WFAMPS-3991)

To fix this issue, the processing for credit notes in ERP process has been updated to use ariaAccountNo from TransDetailItem.AriaAccountNo instead of ariaAccountNo provided in input.

Wrong GL account used when posting excess payments originating from Credit notes (WFAMPS-3948)

To fix this issue, ERP process has been updated to return correct GL acct code for credit notes (2972) rather than 1931/1796 unless the credit amount is consumed by any future invoice.

Create an Issue does not correctly produce new invoice when changing schedule (WFAMPS-3943)

To fix this issue, credit and reissue process for DocmManageDocument API has been updated to consider PRICE-PERIOD and PRICE-ADJUST rates when generating the new invoices.

Use of client_sku for ERP processing (WFAMPS-3936)

Due to technical restrictions, ERP processing has been amended to use client_sku in the place of client_item_id. This impacts ERP reporting for order based invoices like campaigns, final invoices etc.

Change ERP process to ensure migrated invoices and payments are not included in the ERP file (WFAMPS-3984)

To overcome this issue, ERP process for processing new invoices and payments has been updated to use criteria to exclude any invoice/payment data added by migration process.

Change a complaint Status from OPEN to CLOSED (WFAMPS-4007)

To fix this bug, CompManageComplaints API is updated to set Complaint Status value to the same as received in input.

Grants not removed in Zephr on cancellation of subscription (WFAMPS-3971)

To fix this issue, aria event handling is updated to use status change event (724) to determine if plan has been cancelled. If cancelled, the process will update AccountsCache in AMPS and Zephr to remove grants.

Fault in registration of complaint (WFAMPS-3912)

To fix this, CompManageComplaint API has been updated to do additional checks when compManageComplaintCompensationInfo is not provided in the input request.

Complaint not sent when complaintSendToDist is set to NULL (WFAMPS-3874)

To fix this issue, if complaintSendToDist is not provided in the call to register complaint or has some value other than SEND or DONTSEND then comp_export_to_dist_system will be honored. If it is mentioned as true then complaint will be sent to DIMAPS.

Unable to create a complaint on same date as scheduled address change (ARIAS-370) (WFAMPS-3873)

To fix this issue, CompCheckComplaintEligibility has been updated to use correct time stamp when checking distribution start date with complaint date.

Change GL code used for unmatched payments (WFAMPS-3963)

This is a configuration changes where value for glAcctPaymentUnmatched is changed to 86061 from old value 86099.

Translations not added correctly in DiscSyncDiscount process (WFAMPS-3959)

To fix this issue discount sync process has been updated to create and use correct translations and translation references in AMPS.

Enhance Scheduled Sending of Complaint Files (WFAMPS-3957)

To overcome this issue where some of the complaints get stuck in INPROGRESS status, an option has been introduced in AMPS Dashboard (the option is not visible until requested by client) to process complaints stuck in INPROGRESS state.

Change ERP Processing to stop the use of client_item_id (WFAMPS-3962)

In recent Aria API release (V47) client_item_id was made obsolete; ERP process is updated to use client_sku for instead.

subsRetrieveDiscount call shows incorrect data for value-based discounts (WFAMPS-3964)

To fix this issue, subsRetrieveDiscount API has been updated to return correct discount type as per disc_type returned in response from DiscDetail table.

Migration - Errors seen with SFTP file move during production migration (WFAMPS-3921)

Retry action has been added whenever a move action fails in SFTP. This retry is limited to one attempt.

BGMax Payments Failing (WFAMPS-3825)

To fix this issue, BGMAX payment file processing has been updated to remove validation of few fields for record type 20 and validate based on reference code found in record.

AMPS is setting some subscriptions to status 0 overnight (WFAMPS-3338)

To fix this issue, processing of future changes has been updated to set the initial status as per the input received.

SubsRetrieveSubscriptions not returning information for Term-Based Campaigns for Future Activations (WFAMPS-3990)

To fix this issue, the SubsManageSubscription for adding new subscriptions is updated to set correct CampaignOfferID & CampaignIDRef values in future changes table.

SPECIFIC-DATE cancellation for subscription with CAMPAIGN failed (WFAMPS-3972)

To fix this issue, SPECIFIC DATE processing has been updated to validate if cancellation date is equal to new anniversary date, then the process should not create a contract (as the contract will not be applied). In addition, the process will not try to generate invoice either.

OIOUBL contains wrong address references (WFAMPS-3974)

To fix this issue, the process is updated to use invoice_date to get active address when generating OIOUBL document for the invoice.

Change ERP Processing to stop the use of client_item_id (WFAMPS-3961)

In recent Aria API release (V47) client_item_id was made obsolete; ERP process is updated to use client_sku for instead.

Use AMPS generated string in case of acct_statement_seq_str is null (WFAMPS-3920)

For the invoices where acct_statement_seq_str is being returned null, system will generate its own unique string which will be used during the processing.

Result text value is shown incorrectly in TitleManageCalendar response (WFAMPS-3346)

To fix this issue TitleManageCalendar API has been updated to return correct resultText when no record is found for a given date.

TitleRetrievePayOptions is not returning all records (WFAMPS-3238)

To fix this issue, TitleRetrievePayOptions API has been updated to return all records where request source is provided as ANY.

CM-246 Balance transfer - Email notification (WFAMPS-3230)

To fix this issue, a check has been introduced to check if refund is created and refund status is INTERNAL then no email notification will be sent to customer. This is a client specific change.

CM-246 Balance transfer - Audit trail and visualization (WFAMPS-3231)

To fix this, payments/transfer comments has been updated to use payment references correctly for traceability.

Balance transfer - Transfer amount should count towards the refund limit (WFAMPS-3227)

To ensure that the payment transferred from the source account to the destination cannot be refunded several times, balance transfer process has been updated to create an entry in refunds table and payment transaction details table using payment ID provided in call and payment transaction no is set to ariaTransactionNo found against the payment ID.

Mark invoices as PAID where due amount is 0 (WFAMPS-3321)

To fix this issue, 1042 event processing has been updated to see if invoice due amount is 0 then mark the invoice as PAID.

Update SolmManageSQLObjects to handle Clustered Indexes (WFAMPS-3989)

To support creation of clustered indexes SolmManageSQLObjects flow is updated as per schema with updated holding index definitions.

Update AcctSearchAccount to not use ‘LIKE’ for Email Addresses (WFAMPS-3983)

The process is updated to fetch records using exact match when searching through email addresses.

Updated to email notification for Dunning (WFAMPS-3975)

Updated to notification emails for dunning process (client specific implementation – not available for all clients).

Generate invoice for Account No. and Invoice No. (WFAMPS-3869)

A new process introduced to enable a feature that can be used to generate any missing invoices (a link can be added to dashboard on client’s request).

Filtering AMPS Reports (WFAMPS-3883)

New filters are added to AMPS reports that will reduce the load on database when reports are loaded. Instead of fetching all the data, the reports will now use defined parameters to get only relevant records. This will reduce the load on database and improve load time for AMPS reports.

Improvements in AMPSEventLog (WFAMPS-3924)

AMPSEventLog is updated to add new fields that can be used to access relevant data – instead of quering payload.

Invoice period dates not being returned by DocmRetrieveDocumentsLite API (WFAMPS-3986)

To fix this issue, DocmRetrieveDocumentsLite API is updated to use same set of processes/flows to access invoice information as DocmRetrieveDocuments.