Paper Plane 11.3.0

 

This document summarizes the main improvements and fixes introduced in the Pricefx Unity minor release version.

Version

Unity Paper Plane 11.3.0

Release date

October 27, 2023

Release type

Minor

In this document:

Improvements

Improvement Description

ID

Improvement Description

ID

Warnings raised by the Optimization Engine are now more obvious to users - they display as error pop-ups. Previously, they were available only in calculation details after clicking an icon.

PFUN-14394

Support for the customFormHeader (CFOH) logic nature has been added to Studio.

PFUN-15460

The new Header Type column has been added to the Price List overview page allowing users to filter Price Lists created with specific Header Type.

PFUN-16508

Heartbeat: The ephemeral storage for jobs running in Kubernetes is now supported.

PFUN-17877

A filter applied to the list of models remains applied when the model list page is left and then opened again.

PFUN-18313

The labelTranslations field has been added to Model Class allowing to specify the translation of the label.

PFUN-19089

A single portlet instead of an entire Dashboard using the DashboardAPI.setPortlet() method can be embedded.

PFUN-20883

Improved performance when fetching the data from the Company Parameters table.

PFUN-20964

Detection Rules for the results of the Dashboard logic and for the specific portlet can be created in Dashboard Watcher.

PFUN-21035

CRM Visual Mapping: When the PFX Object is already created, a user is now not allowed to map the same object again.

PFUN-21133

Quotes, Rebate Agreements, Agreements & Promotions, Compensation Plans: Filters are retained when performing actions (e.g., Duplicate, Create new revision,...) in the list.

PFUN-21161

A new Groovy API method DashboardApi.newExecution() that executes a Dashboard has been introduced.

PFUN-21221

The search within the Attribute field in the Mass Edit dialog is allowed and values in the Attribute field are sorted alphabetically.

PFUN-21286

Notifications: When a user clicks a notification of the Validation type, the full content of the message is displayed in the pop-up dialog. Basic HTML tags can be used in the message.

PFUN-21332, PFUN-21323

The performance when querying the Customer Extension data has been improved.

PFUN-21345

The basic HTML tags can be used within inline alert and warning icon tooltips.

PFUN-21547

The ModulCatetogy CFOs list has its own AttributeMeta.

PFUN-21573

Job/Task Tracking and Calculation Tracking tables contain new Created By and Last Updated By columns. The Last Updated By column is hidden by default and can be displayed via the Select Fields to Display menu.

PFUN-21630

Dynamic Tabs filters have been improved – advanced filter operators have been added.

PFUN-21639

Visual Configuration: The Formula Builder provides functions categorized into Measure, Operators, and Functions menu categories.

PFUN-21688

Data Change Requests: The existing endpoint has been extended to support asynchronous processing: dcrmanager.submit/${dcr.id}/async. The DCR size threshold from which asynchronous processing is applied is set by the advanced config option asyncSubmitDCRThreshold with the default value of 100.

PFUN-21705

Context Linking: A new parameter targetPageSelection has been added, allowing for the creation of links to the specific line in the Price List and Live Price Grid detail.

PFUN-21706

Strategy Designer and Workflow Designer are no longer standalone apps, they have been integrated into Unity.

PFUN-21725

Data Change Requests: A user is notified via the Notification Centre when the Data Change Request is successfully submitted or if errors occur during submission.

PFUN-21763

Interceptors: The new interceptor method QC_QUOTES_DELETE, which executes logic when a Quote is deleted in QuoteList and QuoteDetails, has been introduced.

PFUN-21786

The new Pricefx header logo is now clickable as a link.

PFUN-21802

The Import button has been moved into the 3-dots menu in Models and Watchers tables.

PFUN-21825

Interceptors: A new Interceptor template 'Send Multiple Requests Using Composite' has been added to the Configuration > CRM Integration > Interceptors.

PFUN-21832

The Job/Task Tracking page now displays a warning icon if at least one element of the logic raises a warning or message.

PFUN-21852,

PFUN-14394

Optimization: Improved loading times of the Model Object list.

PFUN-21934

The recommendations.recommend endpoint returns typedId in the response.

PFUN-21962

Charts: Save Chart and Load Chart buttons order has been changed.

PFUN-21976

Notifications: A new filter 'Submit for approval' has been added.

PFUN-22018

Deal Planner has been removed from the main menu, as this module will be discontinued.

PFUN-22073

Caching mechanism for Contract Term Types has been added.

PFUN-22192

Bug Fixes

Bug Description

ID

Bug Description

ID

If values imported from CSV or Excel start with the quote char ' and the second char is one of these: +-@= then the first quote char is removed and values are saved in DB without this first quote.

PFUN-13918

Quotes and Agreements & Promotions (Contracts) Mass Update displays incorrect values in Target Status and Source Status columns in the Summary dialog.

PFUN-15744

Compensation Record detail displays Rebate Chart Definition instead of Compensation Chart Definition in the Category drop-down field.

PFUN-15895

Dashboard Charts: The text is out of the tooltip frame after performing Drilldown or Exclude in the Data tab.

PFUN-16444

A user cannot see a preview of the workflow steps in the Workflow tab of a Deal Plan or Custom Form if their status is DRAFT.

PFUN-16449

In the Messages tab, inactive users can be selected in the drop-down menu.

PFUN-17666

The hidden Datamart field is available in the Generic Filter in Data Analyzer and Dashboards.

PFUN-17731

Quotes, Rebate Agreements, Agreements & Promotions, Compensation Plans: In the Header tab, indentation and alignment are not correctly applied to the content of the Description field.

PFUN-18175

In a quote, after adding items for the first time, the first visible, non-frozen column appears frozen.

PFUN-18651

Model Objects: The incorrect progress bar behavior when uploading large attachments.

PFUN-19413

The MATRIXLOOKUP input type allows a user to enter any value in the Items table.

PFUN-19545

Selected option is duplicated after filtering out in data search in the Input Parameters tab on a Rebate item.

PFUN-20720

Watcher > Detection Rules: Not all columns from selected Series are displayed in the drop-down menu when defining the rules.

PFUN-20805

Charts in the Quote header (React): An error message is displayed when the chart contains no data.

PFUN-20820

A placeholder remains in the cell when a user clicks in the cell in some Unity tables.

PFUN-20841

In Visual Mapping, the mapping menu is not displayed.

PFUN-21022

When using api.find with more than 65356 of parameters in filters, the query fails with "org.hibernate.exception.DataException: could not prepare statement".

PFUN-21236

Calculation Grids numeric columns are sorted as a String.

PFUN-21372

When a user submits a Compensation Record during the compensation calculation, the Compensation Record throws 'Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [net.pricefx.domain.CompensationRecordSetCalculation#3]' error.

PFUN-21397

Quotes, Rebate Agreements, Agreements & Promotions, Compensation Plans: The Customer, and Product Group fields cannot be imported/exported using the Copy all items to clipboard and Import items from clipboard functions.

PFUN-21594

Incorrect sorting in the Group By table within the Data Table chart.

PFUN-21605

Charts: When the Measure table is sorted, the new order is not applied to the chart.

PFUN-21606

Charts: Some functions in the Measure table do not work correctly after sorting.

PFUN-21607

The Dashboard filter that contains an DMFilterBuilder input is displayed only after reloading the page.

PFUN-21636

The information message is displayed over fields in the Input Parameters tab on a Quote, Rebate Agreement, Agreements & Promotion, Compensation Plan.

PFUN-21670

Internalization Value Override does not allow HTML for the unity_clic_importLineItems_textAreaLabel key (Import Line Items).

PFUN-21684

A User Role 'Administer Users' does not work when it is assigned to a Business role.

PFUN-21704

Charts on Dashboard: All values disappear when a user clicks on one value within the Dimension Filter field.

PFUN-21760

Visual Configuration: A block is not displayed after the If function or If null value function is selected in the Formula Builder.

PFUN-21765

In a Dashboard, hidden input fields are not available in the second run (application of preferences).

PFUN-21792

quotesDetailRecalculate should be triggered only after logic.

PFUN-21858

Models: Configurator input fields are editable in the Approved or Submitted status.

PFUN-21868

Configuration Wizard: The value from the input field is not used when the Apply button is clicked.

PFUN-21885

Dynamic Tabs: In the Documents tab, the Type column displays uniqueName instead of the Custom Form label.

PFUN-21894

Groovy Sandbox: list.with with closure(s) is not compilable. 

PFUN-21895

Interceptors: The Submit dialog does not close when the Submit action is not canceled.

PFUN-21928

Interceptors: An error message is not displayed when the interceptor contains an unknown method.

PFUN-21929

The slider automatically scrolls to the bottom when adding new Series in Charts, Rollups, and Actionable Insights.

PFUN-21930

When adding a new line item to an Agreement & Promotion document (Contract) that uses folders with automatic re-assignment driven by a header logic, the item does not display in the list until it is filtered out.

PFUN-21933

Charts: A user can click on the Save Chart or Save Rollup button when there is no data.

PFUN-21974

Quotes, Rebate Agreements, Compensation Plans, Agreements/Promotions: The Confirm button is enabled while the workflow logic is still running.

PFUN-21978

When a Contract or Rebate is opened, an unexpected error is thrown: Cannot read properties of null (reading 'replaceAll').

PFUN-21985

Job Status Tracker items are not processed in a correct order. 

PFUN-21988

Actionable Insights Watchers: An unclear error message appears when a selected field does not exist in the corresponding Datamart.

PFUN-21999

Incorrect sorting in the Action Definition > Add Action > Advanced Assignment > Add Assignee dialog when selecting from the drop-down menus.

PFUN-22000

RedisAppender (used by the /servelog endpoint to serve the logs to the UI) does not log errors, instead they are silently dropped.

PFUN-22003

Dynamic Tabs: In the Documents tab, if no label is set for the Custom Form Type, its typedId is displayed instead of uniqueName when adding a Custom Form.

PFUN-22052

Models: Edits to the Name or Label require a page reload to be correctly displayed in the Model Object list.

PFUN-22056

Migrations have failed validation. Migration checksum mismatch for migration version. Logging in is not possible on some partitions.

PFUN-22072

The master DB connection sometimes times out by the time a Refresh DL finished.

PFUN-22129

Second call to dataloader.flush() raises a runtime exception.

PFUN-22216

Hot Fixes

The following hot fixes have been released for the 11.3 version:

11.3.1 PR

Released on November 6, 2023

Bug Description

ID

Bug Description

ID

In Advanced Filter, a value to select is shown several times in the dropdown and when it is selected, it is shown even more times. 

PFUN-21540

After you select already saved Preferences in the LPG, adjust column width by using "Auto Fit" and save it, you still get the previous version of Preferences.

PFUN-21757

In a percent input field, only 2 decimals are displayed when it is not actively updated. But when you start updating the value, you should be able to see all decimals you are inserting.

PFUN-21952

Interceptor finishes before the logic, and as a result, the fields are overwritten by the logic after the Interceptor fills them.

PFUN-22231

On the Documents tab for Quotes, Contracts, CFO etc. in the Add Document modal, there is Type Id displayed instead of Label.

PFUN-22233

The Models List table is not refreshed after Revoke is used, so unless you refresh the table, you still see the model as Approved and not withdrawn.

PFUN-22234

When using Filter.in  filter on a partition, you get an error "Could not find property 'attributeExtension___AgreementRole' on class class net.pricefx.domain.RebateAgreement". 

PFUN-22238

When requesting the s3 bucket collecting all ApplicationProperties from all partitions via AWS Athena, you get an error "The specified key does not exist". This is due to the fact this file contains a name with non recommended characters.

PFUN-22246

11.3.2 PR

Released on November 16, 2023

Bug Description

ID

Bug Description

ID

Read only input fields are not rendered.

PFUN-21383

When creating a revision or duplicating a Quote, the original Quote’s "Last Update Date" value changes.

PFUN-21689

Visual Configuration: Syntax error is shown when the user enters decimal or negative number.

PFUN-22064

batchFilters() errors out when it's supposed to return 2 records.

PFUN-22086

Mass update - Documents are not unlocked when created by copy

PFUN-22131

Custom Forms attribute extensions: Cannot duplicate Custom Form when attribute extension column is set (jsonDeserialize: deserialization error).

PFUN-22206

Login failure from IM requests.

PFUN-22328

Unable to filter data in Dimension dropdown list by typing text.

PFUN-22412

Redirect parameters are not working in CRM.

PFUN-22450

11.3.3 PR

Hot fix not publicly available.

11.3.4 PR

Hot fix not publicly available.

11.3.5 PR

Released on December 12, 2023

Bug Description

ID

Bug Description

ID

Stop generating createIndexOn:TMP metrics.

PFUN-22059

Significant slowness of DS/DM operations. Fix: PartitionedObject.partition is not refreshed along the object anymore.

PFUN-22062

Different rounding in datamart.fetch. Fix: datamart.fetch response data were not formated as for regular paged query. Response is generated in stream mode when there is no endRow defined or endRow is bigger than some threshold usually 300.

PFUN-22565

Background tasks (janitor, heartbeat, etc.) exceptions are not always logged.

PFUN-22728

FileSecretsManager is not properly initialized.

PFUN-22730

11.3.6 PR

Released on December 20, 2023

Bug Description

ID

Bug Description

ID

Customer Details > Customer Assignments do not show the complete list.

PFUN-20829

Incorrect product ID is displayed when user selects a product in Price List and wants to check "Product Details".

PFUN-22510

Unlimited length of log records causing problems. Fix: Configurable maximum message length with 8,000 characters as the default (in logback.xml and logback-cloud.xml).

PFUN-22909

dmCtx.streamQuery returning "[N/A]" instead of nulls.

PFUN-22938

JS error while recalculating Quote since version 11.1. when no message specified in api.yellowAlert("").

PFUN-22942

Message Recipient list includes soft deleted users.

PFUN-22947

Method api.find does not find emails anymore.

PFUN-22975

11.3.7 PR

Released on January 8, 2024

Bug Description

ID

Bug Description

ID

Email template variables not working for creation workflow emails.

PFUN-22478

Data Load doesn't respect Data Source sorting.

PFUN-22793

Claims detail: Loop of errors is thrown when backend returns 500 HTTP status in response.

PFUN-22913

Percent type inputs are not working correctly when min/max value is used.

PFUN-22940

lookuptablemanager.loaddata (aka loaddata) should ignore name field of MLTV.

PFUN-22971

customFormApi not working using post-step workflow logic when logic updates the same CFO.

PFUN-22974

Min/Max bounds on Groovy-generated inputs cause an infinite loading on CFO Details page.

PFUN-23006

It’s not possible to validate / revoke Claims from UI. Buttons do not trigger proper action.

PFUN-23008

When removing a file from a Claim, Claim items are not refreshed.

PFUN-23028

11.3.8 PR

Released on January 25, 2024

Bug Description

ID

Bug Description

ID

Rename and Customize Column: Cannot add a row in Advanced Table in Unity if the column is referencing other column.

PFUN-17787

Rebate Record is not deleted after Rebate Agreement(draft) Item is deleted by logic.

PFUN-21443

Error when submitting a Custom Form via Calculation Flow. Fix: Empty user allowed on Custom Form workflow submit/withdraw/revoke.

PFUN-22425

LPG / PriceLists - attribute Field / Weight in Results Fields not displayed when a text is longer.

PFUN-22708

Price List revision - option "Use filter criteria" is not respected.

PFUN-22753

Rebate/Compensation Record calculations: Start Date value missing in the Calculations table.

PFUN-23027

Two jobs with same ID on one cluster, job from one partition terminated successfully but in the context of the second partition.

PFUN-23113

E-signature: Missing info about signed documents.

PFUN-23138

LPG: Paper Plane is not restricting users from running more than 1 Mass Action.

PFUN-23147

Opening "Protected Expression" element makes Unity to crash.

PFUN-23151

Partition admin: Remove CS Metrics Enabled column from UI.

PFUN-23292

Count queries no longer correctly make use of workers in the Analytics DB.

PFUN-23312

11.3.9 PR

Released on February 12, 2024

Bug Description

ID

Bug Description

ID

NPE exception in CalculableLineItem.

PFUN-22139

Delete button does not appear for failed-submission Agreements/Promotions.

PFUN-22872

Heartbeat: Sequential jobs (concurrency key) should start as soon as previous has finished.

PFUN-22972

Public Analytics Data Rollups become private after resaving.

PFUN-23163

Cannot update External Ref column of Rebate Agreement from Groovy.

PFUN-23291

Agreement/Promotion recalculation throws LazyInitializationException for some users.

PFUN-23303

Redirect to URL is not working in SFDC.

PFUN-23342

Price List Summary fails with "SQLGrammarException: could not extract ResultSet".

PFUN-23364

Requests in Kibana missing the message (payload) for bare metal instances since 11.3.6.

PFUN-23383

Add fallbacks in "Import Line Items" when ClipboardAPI is not available.

PFUN-23416

Distributed Calc Data Load: DatamartContext.batchFilters() mutates and breaks its filter argument.

PFUN-23436

Sequential jobs with same concurrency key should not wait for pod removal.

PFUN-23441

DatamartContext.executeQuery() randomly fails - possible concurrency issue.

PFUN-23488

Distributed Calc Data Load: Random streamQuery() error.

PFUN-23517

Analytics: Idle hib db connection timeout in datamart.import.

PFUN-23525

Remove checking for opportunity/account page in *ListFilterAdd interceptor.

PFUN-23535

11.3.10 PR

Released on February 16, 2024

Bug Description

ID

Bug Description

ID

LPG with empty CreatedBy behaves strangely (strange Update BE request, createdBy gets filled after it is updated).

PFUN-21675

Add a Calculation Flow flag to spawn the CF job on dedicated pod.

PFUN-22122

JST running on killed BE in cloud incorrectly stay running for 4 hours.

PFUN-22827

View and Edit new Calculation Flow field `disableOnServiceRole` in the configuration UI.

PFUN-22904

Error when adding multiple UserGroups in Dashboard Admin due to exceeding the 255 char limit. Fix: On PostgreSQL all `userGroup` entitlement DB fields can now store an unlimited number of characters.

PFUN-23159

Random failure of Analytics queries due to "Table for entity <xxx> not found".

PFUN-23596

Advanced Filter fails when listing values for a field IndexOutOfBoundsException.

PFUN-23634

11.3.11 PR

Released on March 11, 2024

Bug Description

ID

Bug Description

ID

The option 'Submit on Creation WF finish and restart the last state when denied or withdrawn' does not work in Sales Compensation.

PFUN-20657

Baremetal clusters sending location=unknown and pretending to be in cloud in registry event.

PFUN-22870

Error when /datamart.fetchnocount reaches FORCE_STREAM limit.

PFUN-22894

Incorrect Rebate Record WF logic applied to Default Rebate Agreement Type.

PFUN-23201

Analytics: Schedules for Data Loads are fetched in batches from the database to improve loading time.

PFUN-23246

Rebate records are getting auto-approved even if there is a WF logic defined.

PFUN-23331

Price List: Output Elements show selected 0/100 even where there are boxes checked.

PFUN-23553

Agreements & Promotions: Items won't import from clipboard, UI freezes.

PFUN-23571

Live Price Grid: Custom Mass Action not passing arguments to Calculation Flow.

PFUN-23638

Agreements & Promotions: 'Submit' button keeps spinning and doesn't automatically refresh when we throw an exception in the workflow logic.

PFUN-23662

Configurator buttons are becoming unresponsive inconsistently.

PFUN-23663

Message templates: It is impossible to disable Action Item email templates.

PFUN-23688

Configuration > Calculation Flow: Impossible to display typedId in the UI.

PFUN-23790

11.3.12 PR

Released on March 26, 2024

Bug Description

ID

Bug Description

ID

Filtering: Numbers stored with scientific notation in attribute fields (stored as string) are not properly parsed when converted to real numbers. This impacts sorting as well as mass update and queries involving arithmetic operations.

PFUN-23548

Embedded CFOs in Quotes are not auto recalculated on page load even with auto recalculation enabled.

PFUN-23868

Feature Flags: enableLogoutAlert is not working properly, the logout message disappears.

PFUN-23897

Incorrect error message for user entry field with setFrom() and setTo() used.

PFUN-23908

Memory leak issue on Production.

PFUN-23928

inputBuilderFactory().createOptionEntry() - can't set valueOptions in PrePhase.

PFUN-23949

Importing 700+ materials in quote throwing Operation Time out error.

PFUN-24108

11.3.13 PR

Released on April 26, 2024

Bug Description

ID

Bug Description

ID

OTel: Missing query parameter in REST endpoint traces.

PFUN-23512

Live Price Grids: Mass Action dialog and date handling failure.

PFUN-23818

TypeError: Cannot destructure property 'extraOptions' of 't' as it is null.

PFUN-23924

DMDataLoad.pre80Config property has been removed from DMModel.

PFUN-24106

The method DMFilter.stopUsingDummy() is now synchronized to fix ConcurrentModificationException in charts with a generic filter.

PFUN-24111

ConfigCollector produces files with incorrect names.

PFUN-24276

Occasional IndexOutOfBoundsException when performing an api.find during distributed DMDL execution.

PFUN-24363

Analytics - Inconsistent behavior loading data into Data Source.

PFUN-24392

11.3.14 PR

Released on May 13, 2024

Bug Description

ID

Bug Description

ID

Quotes, Rebate Agreements, Agreements & Promotions, Compensation Plans: Default header type has value "__DEFAULT__" in exports.

PFUN-19615

Calculation Flows: Non-periodic job (non-draft) is deleted after "Run Now" and shows as finished with error.

PFUN-24441

Expanding/collapsing folder in line items triggers a calculation of even an approved Rebate Agreement.

PFUN-24554

Concurrency issue in Apache Commons FileUtils.listFiles() causes PA Distributed Calculation DL to fail when loading results into PostgreSQL.

PFUN-24597

File upload exceeds its maximum permitted size of -589934592 bytes.

PFUN-24645

Incorrect validation of CORS headers.

PFUN-24678

11.3.15 PR

Released on June 19, 2024

Bug Description

ID

Bug Description

ID

Unable to delete Data Load in "scheduled" but frontend says "deleted successfully".

PFUN-19017

loaddata/CX creates not optimal query for PGOP. Fix: loaddata now ignores nulls in attribute fields of the join fields if there are no nulls for them in the loaded data. Both on MariaDB and Postgres even though the performance improvement is really visible on Postgres.

PFUN-23344

CHIPS support for cross-site cookies has been implemented for Chromium-based browsers to enable users to continue using CRM integration after 3rd-party cookies are blocked. The new configuration ‘enableChips’ enables ‘Partitioned’ parameter on X-Pricefx-* cookies.

PFUN-24093

Custom Forms: Possible stored XSS due to the use of dangerouslySetInnerHTML.

PFUN-24260

Backend sometimes fails to reconnect after a PA DB restart.

PFUN-24658

SSO user unable to login due to apostrophe/single quote in name. Fix: The value of the filter is properly escaped in Search.addFilterEqualIgnoreCase (only used in SAML authentication).

PFUN-24969

Unable to login after upgrade to Rampur 13 (and from localhost). Fix: The backend sent a cookie with Max-Age=0 to remove the cookie from a browser but without the `Partitioned` param. In this case, the browser did not remove the cookie because it considered it a different one.

PFUN-25034

Unsupported type org.hibernate.type.LocalDateTimeType with Filter.in on PostgreSQL.

PFUN-25388

Found an issue in documentation? Write to us.

 
Pricefx version 13.1