Enhancements Bug Fixes
Molecule App Molecule API
11 October 2024

Here's what's new in Molecule...

Improved Certificate Inventory Allocation Support

Serial Number Creation From Range

MOL-18409 - We’ve added support for creating multiple serial numbers from a range, enabling better tracking of offsets and RECs. This feature simplifies managing large quantities of serial numbers in ticket-based workflows.

Allocations POST API

MOL-18429 - Enhancements to the Allocations POST API allow the setting of source values and improve the handling of identical allocations, reducing redundancy and streamlining the allocation process. MOL-18424 - The Allocations POST API has been enhanced to allow sending an empty list of allocations, making it easier to end allocations for a ticket on a specific date without manually deleting them.

Inventory Valuations API - Join Allocations

MOL-18433 - The Inventory Valuations API now supports joining allocations to valuation records. This enhancement allows for a more comprehensive view of allocated and actual inventory volumes, improving data visibility.

Allocations Delivery Detail screen has new columns & drag-and-drop features

MOL-18390/MOL-18430 - The Delivery Allocations Detail screen has been upgraded with additional features, detailed obligation grids, and improved UI interactions for managing certificate allocations. The screen now includes new columns for allocated and unallocated volumes and the ability to expand inventory rows to view associated allocations, offering users greater visibility into allocated and unallocated inventory. MOL-18425 - We’ve also introduced drag-and-drop functionality to the allocation details grids, making it easier to allocate inventory to obligations. This feature improves user interaction and streamlines the allocation process.

Requested Changes and Fixes

Fixed a Performance Issue with PPA Trades

MOL-18465 - We’ve addressed high CPU utilization in the Molecule web application when creating specific PPA trades. The fix results in better performance when processing trades in production environments.

Bug: Hourly Forecasted Average Ignoring As-Gen Quantity (%)

MOL-18375 - We’ve resolved an issue where the hourly forecasted average function ignored the "as-gen" percentage on trades. This fix enables quantities and P&L calculations properly reflect the percentage value entered on the trade.

Migrated API Keys Screen to Admin Screens

MOL-18329 - The API Keys screen has been migrated to the Admins Settings pages, offering a centralized interface for managing API tokens with other settings.

Identifying TAS Trades in Bigbang

MOL-17619/MOL-18461 - The pricing_type column has been added to the Bigbang trades table, making it easier for users to identify TAS (Trade At Settlement) trades in their reporting.

Slow Valuations on Options

MOL-17373 - We’ve identified and are addressing the cause of slow options valuations. This enhancement reduces the delay in revaluing options after new market data is available.  MOL-18217 - We’ve added logging to address issues with delayed vendor marking of trades, to help us monitor the timeliness of trade valuations. MOL-18452 - We’ve added additional logging for allocated entries to help identify and resolve issues related to trade allocations, improving transparency and troubleshooting capabilities.

Blocks Incorrect for Hourly Trades

MOL-18350 - We’ve corrected an issue with some custom blocks for hourly trades. These blocks now properly create legs for the expected intervals, supporting accurate trade creation.

Update Multiple Tables/Fields for Natural Gas Trades

MOL-17442 - We’ve updated multiple tables and fields for natural gas trades so trade data is correctly stored without affecting actualization history.

New Terms Selections on Agreement Annexes

MOL-17416 - New terms options have been added to agreement annexes, allowing users to calculate payment dates based on contract_start dates. This enhancement provides more flexibility in managing agreements.

Update Trade/Settlement Entries Agreement ID for Attached Trades

MOL-17176 - A data migration script has been created to update the agreement ID on trades and associated entries, ensuring accurate payment date calculations and agreement associations.

Multiple Tags Available for Assets

MOL-16817 - Users can now select multiple book tags for an asset, accommodating scenarios where an asset needs to be categorized under multiple tags. This update provides more flexibility in asset management and tagging.

Support Account-Specific FCM Encryption Keys

MOL-18448 - We now support account-specific encryption keys for FCMs, allowing for more secure and customizable encryption setups per account. 

Update Filename Expectations for as_of Extraction

MOL-18477 - We’ve updated the filename format expectations for Morgan Stanley's daily and portfolio files, enabling reconciliation processes run smoothly with the new filenames.

Updating Fees Mapping for Daily File

MOL-18482 - We’ve updated the fee mapping process for Morgan Stanley’s daily reconciliation files. The Commission and NFA Fees fields are now correctly reconciled as molecule fees, improving financial accuracy.

Adjust AutoReconciliation Transformer for Morgan Stanley

MOL-18436—The AutoReconciliation Transformer has been adjusted to correctly map exchange codes from Morgan Stanley’s reconciliation files to support trade reconciliation.

Custom Fields Improvements

Note: This feature requires working with your CSM to enable.

Management & Usability

Custom Fields Management Screen
MOL-17171 - We’ve launched a new Custom Fields Management screen in the Admin console. This feature allows users with the custom_field_admin role to manage custom fields and their recommended values. The Custom Fields option appears under Inventory in the sidebar in the new Admin app and provides a grid view that displays existing fields by object type and order.
Actions include viewing audit history, deleting custom fields, and removing associated values and recommendations. This new screen offers users direct control over their organization’s custom field management.

Added Custom_Field_Admin Application Role
MOL-17316 - A new custom_field_admin role has been introduced. It allows users to create, update, and delete custom fields, providing better role-based access control.

MOL-18466 - We’ve restricted users' ability to assign the Custom Field Admin role. This role can only be transferred via specific admin interfaces, enforcing tight control over user permissions.

Custom Field Main Form
MOL-18077 - We’ve introduced a new and improved form for custom fields where users have more control over field attributes such as required fields, multiple-choice options, and field orders.

Custom Field New/Edit Modal
MOL-17146 - We’ve introduced a new modal to manage custom fields, allowing users to easily create, update, and delete.

Custom Field Filters / Recommendations Component
MOL-18078 - We’ve added a new component for custom field filters and recommendations, which allows users to apply and manage trade-specific filters and recommendations easily.

Ability to Apply Values to Custom Fields in Bulk
MOL-17566 - A new feature allows bulk modifications to custom fields, making managing missing or invalid values across trades, assets, and agreements easier.

Recommendations 

Custom Field Recommendations - Support Deterministic Ordering

MOL-17475 - We’ve added support for the deterministic ordering of custom field recommendation so the lowest-numbered recommendation is applied when multiple records are matched.

Custom Field Recommendations - Deactivation without Deletion

MOL-17466 - Users can now deactivate custom field recommendations without deleting them, preserving historical data while preventing inactive recommendations from being applied to new trades.

Custom Field Headers - Product Filters Cleanup

MOL-17569 - We’ve cleaned up the custom field headers product filters by supporting a list of values for product attributes such as Commodity, Instrument, and Price Type, enhancing custom field management.

Custom Field Headers - Support Deterministic Ordering
MOL-17535 - Custom fields now support deterministic ordering, so that fields are displayed consistently on the screen. This update improves the user experience by enforcing unique order values.

Validations, Fixes & Migration Support

Custom Field Header Validations

MOL-17968 - We’ve enhanced the validation rules for custom fields. When using a "multiple choice" field type, at least one option must be available in the list. Additionally, only custom fields associated with "Trade" can be marked as required, with the default setting for required fields set to false for accurate and consistent data handling across custom fields.

Bug: Error When Changing Custom Field Type With Nil Values

MOL-18480 - A bug causing errors when changing custom field types with nil values has been fixed. Users can now change field types without encountering issues related to empty values.

Remove Problematic Index on Custom Field Values Table

MOL-17662 - A problematic index on the custom_field_values table has been removed to prevent errors when editing custom fields and object types so custom fields can be edited without issues related to object type constraints.

Write to Custom Field Values Table and Cache to Trades

MOL-18407 - Custom field values for trades are now correctly written to the custom_field_values table and cached in the trades.custom_field_values column, enforcing data consistency during trade modifications.

Trade Custom Field Values Data Migration

MOL-18451 - We’ve improved the migration process for custom field values related to trades. The updated migration enforces data integrity by preserving values added before migration completion and allowing resumption in case of interruptions.

Coerce Old Custom Field Values to New Type

MOL-18188 - We’ve implemented functionality to automatically coerce old custom field values to a new field type when custom fields are updated. This prevents errors when field types are changed.

Validate Only Existing Product Short Names in Custom Field Product Filter

MOL-18037 - A new validation rule so that only existing product short names accessible to an account can be used in the product filter of custom fields.

API Enhancements

Custom Field Headers v2 API - Enable Create, Update, Delete

MOL-17148 /MOL-17318- The Custom Field Headers API now supports creating, updating, and deleting custom fields. This update gives users more control over managing custom field configurations in their accounts.

Custom Field Headers v2 API Accepts Parameters for Recommendations.

MOL-18038 - The /api/v2/custom_field_headers API now supports parameters for creating, updating, or deleting recommendations associated with custom fields, making it easier to manage recommendations.