Rampur 13.1.0
This document summarizes the main improvements and fixes introduced in the Pricefx Unity minor release version.
Version | Unity Rampur 13.1.0 |
Release date | September 8, 2024 |
Release type | Minor |
In this document:
Improvements
Analytics
Description | ID |
---|---|
The Refresh Data Load can delete from Datamart those rows that are no longer present in the Data Source. | PFUN-25476 |
In Calculation Data Loads settings, there is a new option With source snapshot. If disabled, the job does not populate the source DatamartRowSet1. This is useful when the calculation logic generates or queries the data itself, rather than expects to iterate over the (pre-populated) source row set. | PFUN-25648 |
Calculation messages about source and target snapshots in Calculation Data Loads are available in the Job Details. | PFUN-25663 |
CLIC Modules
Description | ID |
---|---|
Column tooltip is displayed when hovering over the Items table header in the form of “label [sourceAttribute]”. | PFUN-24437 |
Input type OPTIONS can be exported and imported from/to Excel in the format option1;option2;option3. Semicolons in the values are escaped. | PFUN-24507 |
Optimization
Description | ID |
---|---|
Possibility to access the URL of images that are part of the attachment in a logic and then using these images in HTML portlets. A new endpoint to get the attachment ( | PFUN-13086 |
Support of filtering as you type in data source drop-down lists in the module. | PFUN-19296 |
When duplicating a model, all associated Parameter Tables will now be included in the duplicated model. | PFUN-25675 |
CRM Integration
Description | ID |
---|---|
Visual Mapping: A new field called Transformation allows you to define a transformation of values coming in the payload from the CRM before they are saved into Pricefx. | PFUN-22186 |
CRM integration helper is available on the SAML Configuration page. It helps with building correct URLs for integration with CRM applications. | PFUN-24730 |
Interceptors: The | PFUN-25714 |
The Develop Interceptors user role allows the user to edit and create interceptors and visual mappings. | PFUN-25908 |
Configuration
Description | ID |
---|---|
Added support for allow-object-modification and calculation-context in | PFUN-15316 |
The method | PFUN-25539 |
General
Description | ID |
---|---|
Pricefx GenAI chatbot supports markdown language which allows it to correctly display structured text (numbered and bullet lists, etc.) | PFUN-24784 |
After Pricefx upgrade, users had to clear the browser cache to be able to log in successfully to the app. As a fix, the backend now sends invalidated CHIPS and normal JWT and CSRF cookies during the logout. It prevents the login error that occurred after CHIPS was introduced. | PFUN-25535 |
Items can be exported and imported from/to Visual Formula Designer and Visual Strategy Designer. | PFUN-25687 |
Context linking parameters are removed from the URL when the link is opened from the root page. | PFUN-25788 |
The enter key on the numeric keypad now behaves the same way as the regular enter key in keyboard shortcuts. | PFUN-25919 |
Bug Fixes
Description | ID |
---|---|
Product Extension items mass delete throws error when Product__sku is selected instead of sku. Fix: ProductMaster__ fields are now supported in filters in Product Extensions mass delete. | PFUN-13432 |
Standalone Custom Form list: submitDate is returned from server as date even though it is saved in DB as dateTime (filtering issue). | PFUN-14559 |
Materialized Rollup doesn't load data when column is renamed. | PFUN-15036 |
Custom Forms: Cannot update label via API. Fix: | PFUN-16368 |
Add a more clarifying and detailed error message when recalculating a Custom Form with a non-existing or inactive formula. | PFUN-16900 |
Quotes, Agreements/Promotions, Rebate Agreements, Compensation Plans: Attachment file with a semicolon in its name has the rest of its name cropped. | PFUN-17506 |
Company Parameters: Preferences do not get cloned when cloning SIMPLE, JSON and RANGE table. Fix: Preferences are copied with Company Parameters duplication (for all sub types). | PFUN-18618 |
Custom Form list: Sorting and filtering does not work correctly when using the filters 'approved by is null' or 'denied by is null'. | PFUN-20538 |
Quotes, Agreements/Promotions, Rebate Agreements, Compensation Plans: Attachment generated during "Send" is not counted among the number of attachments. | PFUN-20904 |
To prevent potential email flooding, the following Advanced Configuration options have been added limiting the | PFUN-21027 |
Pricefx for Salesforce: Visual Mapping is not working with multiple levels of inputs. | PFUN-21333 |
Agreements & Promotions, Rebates, Sales Compensation: If no filtering logic is set in the header type or as default, any active logic is applied while no logic should be applied in this case. | PFUN-23145 |
Price Setting: Mass edit and edit actions offer different attributes for editing. | PFUN-23211 |
Datamart Viewer ignores the set preference and loads all columns, not just those saved in the preference. | PFUN-23335 |
| PFUN-23449 |
Misleading message in case there are failed rows after running the Import functionality in Customer, Product or Seller Extensions or Company Parameters table. | PFUN-23659 |
Rebates: The Rebate Records tab doesn’t show to which set a Rebate Record belongs. Fix: RebateRecordSet column has been added. | PFUN-23841 |
Dashboards, context linking: Pre-filled data disappear with targetPageTarget 'same' when a dashboard is selected again and the button with the link clicked. | PFUN-23853 |
The enablePriceGuidance property is ignored in various Analytics pages. Fix: If the advanced configuration option 'enablePricingGuidance' is false or undefined, then all queries related to DMM are dropped, so the user cannot choose a DMM source in Analytics Chart, Rollup or Data Load and the option 'Model Calculation' is hidden when 'Add new data load'. | PFUN-24088 |
Missing translation of the headings of the Rebate Record Groups and Model Classes logic editing dialogs. | PFUN-24278 |
Live Price Grids: Advanced filter with custom date is not correctly applied in Mass Actions. | PFUN-24540 |
Quotes, Agreements/Promotions, Rebate Agreements, Compensation Plans: Table tree view cannot unfreeze all columns. | PFUN-24551 |
Data Load JST: No job parameter details displayed for jobs triggered by the system. Fix: JST parameters map attribute is passed to a method scheduling a new DataLoad run. | PFUN-24700 |
Company Parameters: Timestamps are not working for JSON tables. | PFUN-24720 |
New attribute name and label is not displayed in Product Extension business key dropdown without reloading the page. | PFUN-24763 |
Data Change Request: DCR label is a required field when creating a request from Company Parameters but it is not when creating it on the Data Change Request page. | PFUN-24866 |
It is possible to change the label of an approved Custom Form. | PFUN-24911 |
Quotes, Agreements/Promotions, Rebate Agreements, Compensation Plans: Default header type has wrong value in exports. Fix: The header type and records contain translated '(Default)' headerType name value in the xls exports. | PFUN-25000 |
Condition Records: Combination type should only contain 'function' value. | PFUN-25045 |
Custom Forms, Module Category, Model Classes: Plural instead of singular on Save button. Fix: Save button in all model object screens now has "Save <singular>" instead of "Save <label taken from breadcrumbs>". | PFUN-25061 |
Rebates: Paging is not working for the table on the Rebate Records tab of Rebate Agreements. | PFUN-25065 |
Calculated Field Sets: When a user tries to add Relative Target Date while Target Date is already set, Relative Target Date is not saved and it is replaced by empty value. Fix: Target Date and Relative Date columns are mutually exclusive. Any value written in one of them will clear the value in the other one. | PFUN-25091 |
Strategy Designer: Product ID value changes from sku to typedId when a block in the configuration is changed. | PFUN-25127 |
Strategy Designer: Error when clearing ProductID in Live Preview. | PFUN-25173 |
When switching between Condition Record Sets, the list does not update. | PFUN-25181 |
When the user applies a view preference that contains an advanced filter when creating a new Price Lists, clears the filter and goes to the next step and back, the filter is applied again. | PFUN-25214 |
Rollups: Hidden fields are available in Group By and Measures drop-down lists. | PFUN-25227 |
The condition record creation logic should execute asynchronously from the Workflow, so that the WF is not blocked till the logic finishes. | PFUN-25258 |
It is not possible to fetch calculation results from the link on the Rebate Record Group list page. | PFUN-25270 |
Optimization: Scoring Calculation in Calculation tab fails. | PFUN-25364 |
Date picker - format is not automatically converted and date is not selected. Fix: Before the fix, users were able to enter dates by typing them only in the exact format according to the user's locale. Now, the input field rules are more relaxed (e.g., where 06/07/2024 is accepted, 6/7/2024 is accepted as well). From a configuration engineer's perspective, for certain fields there used to be only one format. Now there is an array, where the 1st element is the preferred one and all other elements are the allowed ones. | PFUN-25372 |
Dashboards: Saved filter is not applied when a dashboard is loaded. | PFUN-25376 |
Quotes, Agreements/Promotions, Rebate Agreements, Compensation Plans: For input type OPTION, labels are not displayed in the Items table. | PFUN-25380 |
DOCX conversion connection failed with "Connection reset". | PFUN-25451 |
Lookups in Strategy Designer do not maintain selection of values. Fix: The operator and the field are considered together when determining the output type of the data lookup block. | PFUN-25466 |
Analytics: Batching Calculation Data Load is missing rows when Source is set equal to Target. Fix: When there is no separate Source in batching Calc DL, then the query on the source to get the next batch data no longer applies an OFFSET filter, and the already processed rows are already omitted by the filter on lastUpdateDate (which prevents (re-)processing rows added or updated by the job itself). | PFUN-25470 |
Labels of user groups, Master Data columns, Custom Form item folders, Dashboard category, Module Category, Model Classes, Calculated Field Sets, Data Change Requests, header logics, Manual Price Lists are not translated when custom translation keys are used. | PFUN-25475 |
Distributed Calculation Data Loads: On the Calculation tab, when Enrichment or Allocation load mode is selected, the Target Fields input has been moved above the Logic input for better user experience (an error was displayed when the user selected a logic before target fields). | PFUN-25498 |
When user duplicates Competition Data API with the same name, the job is cycled after the click on the Save button instead of displaying an error message. | PFUN-25520 |
Scatter chart: Missing "Aggregation By" data in exported Excel file when the option "Merge Close Data Points" is selected. | PFUN-25527 |
Waterfall/Waterfall Comparison charts in Actionable Insights: Labels on the detection rule dropdown list should be Waterfall Elements' labels not Datamart fields' labels. | PFUN-25528 |
Datamart Watcher > Action Definition: Unnecessary column “_index” in Table Column Options in the Action Definition step. | PFUN-25543 |
Waterfall: Aggregate/Disaggregate elements are not saved after clicking the "Save Chart" button. | PFUN-25556 |
In the SQL generation of an Analytics SQL query, we materialize the CTEs. This is not a very suitable approach for Citus environments as it may end up in an exceeded result size error. Fix: The 'paDisableMaterializedCTE' application property has been added to switch off MATERIALIZED CTEs in SQL query generation. It is expected to be used in every Citus environment. | PFUN-25590 |
Quotes: View preferences change column order after recalculation. | PFUN-25619 |
Quoting: "Something unusual happened" error message. | PFUN-25640 |
Strategy Designer: The live preview in data lookups can return data in a different order than when it's used in a strategy. | PFUN-25670 |
Strategy Designer: Selected strategy/lookup is forgotten when switching to lookups and back. | PFUN-25722 |
Data Load: Distributed calculation with Full load mode is not deleting data in case logic is not generating new data. Fix: Now always truncating the target table if DL.LoadMode == FULL, when the job completes successfully. | PFUN-25781 |
Groovy API: api.datamartFilterBuilderUserEntry is deprecated but not all functions have been migrated to InputBuilder. Fix: api.inputBuilderFactory().createDmFilterBuilder().* features have been added. | PFUN-25924 |
Max Grid Group By setting in Configuration > General Settings does not work. Changing the setting does not have any effect. | PFUN-25951 |
It is possible to select a zoom area in a waterfall comparison chart although this feature is not supported by this chart type. | PFUN-25963 |
Visual Configuration: JCS does not allow to delete "active" and "superseded" entries. Fix: User roles PB_STRATEGY_DESIGNER_ADMIN and PM_FORMULA_DESIGNER_ADMIN have been added that allow deleting such entries. | PFUN-25987 |
In class ContractRecalculationTask list, lockedCts is never updated, but it is queried. Fix: A notification is displayed when calculation uses feeder logic and selects locked document/record. | PFUN-26045 |
LPG parameter configuration is not passing dynamic filter to secondary keys. | PFUN-26094 |
All emails from partition are not sent after adding SMTP configuration in partition configuration. | PFUN-26218 |
Issue with api.getDatamartContext().calendar().getTimePeriod() returning null for week 2022-W53 in December 2022. | PFUN-26285 |
Condition Record set shows records of other table (CR set) if set column filter "Sales Org". | PFUN-26313 |
Hot Fixes
The following hot fixes have been released for the 13.1 version:
13.1.1 PR
Released on October 2, 2024
Description | ID |
---|---|
Advanced Filter with a more complicated condition (e.g., AND || OR) does not work in Configurator Table. | PFUN-25989 |
Analytics: Two Data Loads of DM refresh runs finishes differently. One run displays the following message: `Skipping update from DMDS not all key fields {} are in the target DM's table`. | PFUN-26372 |
Condition Record not loaded or deleted sometimes when a null key is involved. | PFUN-26375 |
Analytics: Incremental DDL misses rows in Citus. | PFUN-26537 |
Analytics: Only allow creating distributed tables in a fully fledged Citus pgops cluster. | PFUN-26571 |
Analytics Data Load: java.lang.NullPointerException: Cannot invoke entityField.getEntity() because "targetField is null. | PFUN-26614 |
Data Change Request async submit: Missing link to JST. | PFUN-26634 |
Analytics: A large number of system catalog queries in PA DB after upgrade to 13.x. | PFUN-26644 |
When exporting, condition record set contains more data then expected. | PFUN-26663 |
Found an issue in documentation? Write to us.
Pricefx version 13.1