Enhancements:
SDP-23032: Updated index hint to address throughput in execution of message streams
...
SDP-22742: Created new Inbound interface for EntityLiquidity
Created a new inbound interface to load Entity Liquidity object records to the database
Created functionality to delete the Entity Liquidity object records from the database via Inbound Interface
The Inbound interface for EntityLiquidity was added to the eagle_wrf_generic_load workflow
Changed files:
eagleml_entity.xml
ent_entityliquidity_delete.inc
generate_sp_on_fly.inc
parse_ent_common_fields.inc
xml-ent_delete.xml
xml-ent_objects.rsf
...
The parameter TIBCOMode has an impact on the mapping of attributes for extract data.
The EagleML and transactionMessage nodes did not contain important attributes for TIBCO mode when using streaming mode.
Support was provided to the group of extracts below:
WORKINGTRIALBALANCEEXTRACT
PREFERREDSHAREEXTRACT
UNAPPROVEDVARMARGINEXTRACT
WEIGHTEDAVERAGEEXTRACT
MDCLENEAGEGRAPHEXTRACT
WASHSALEEXTRACT
Extra grouping in the out_t_streaming includes was deleted (includes were optimized) for the listed extracts:
WRHSBROKTRDQUOTEEXTRACT
WRHSCASHACTIVITYEXTRACT
WRHSCASHFLOWPROJEXTRACT
WRHSCLOSELOTEXTRACT
WRHSCSTDACTIVITYEXTRACT
WRHSCSTDBALANCEEXTRACT
WRHSNAVEXTRACT
WRHSPENDINGTRADESEXTRACT
WRHSPERFORMANCEEXTRACT
WRHSPOSITIONEXTRACT
WRHSTRADEEXTRACT
WRHSNAVMONTHENDEXTRACT
Files changed:
t_eml_header_streaming.inc
t_rule_start_obj_header_streaming.inc
t_rule_start_trx_header_streaming.inc
t_acct_preferred_share_streaming.inc
t_acct_unapproved_var_margin_streaming.inc
t_acct_weighted_average_streaming.inc
t_ref_mdc_leneage_graph_streaming.inc
t_ref_mdc_leneage_graph_streaming.xml
t_warehouse_brokertradequote_streaming.inc
t_warehouse_brokertradequote_streaming.xml
t_warehouse_brokertradequote_streaming_eml.inc
t_warehouse_cash_activity_streaming.inc
t_warehouse_cash_activity_streaming.xml
t_warehouse_cash_activity_streaming_eml.inc
t_warehouse_cash_flow_proj_streaming.inc
t_warehouse_cash_flow_proj_streaming.xml
t_warehouse_cash_flow_proj_streaming_eml.inc
t_warehouse_close_lot_streaming_eml.inc
t_warehouse_closelot_streaming.inc
t_warehouse_custody_activity_streaming.inc
t_warehouse_custody_activity_streaming.xml
t_warehouse_custody_activity_streaming_eml.inc
t_warehouse_custody_balance_streaming.inc
t_warehouse_custody_balance_streaming.xml
t_warehouse_custody_balance_streaming_eml.inc
t_warehouse_nav_streaming.inc
t_warehouse_nav_streaming.xml
t_warehouse_nav_streaming_eml.inc
t_warehouse_pending_trades_streaming.inc
t_warehouse_pending_trades_streaming.xml
t_warehouse_pending_trades_streaming_eml.inc
t_warehouse_performance_streaming.inc
t_warehouse_performance_streaming.xml
t_warehouse_performance_streaming_eml.inc
t_warehouse_position_streaming.inc
t_warehouse_trade_streaming.inc
t_warehouse_trade_streaming.xml
t_warehouse_trade_streaming_eml.inc
t_wash_sale_streaming_eml.inc
t_warehouse_nav_month_streaming.xml
t_acct_working_trial_balance_streaming.inc
t_acct_working_trial_balance_streaming.xml
...
The definition of the following feed types have been added to the swagger-extracts.json file:
ENTITYCOLLATERALSUMMEXTRACT
ENTITYANALYTICEXTRACT
ENTITYPEERGROUPRANKINGEXTRACT
ENTITYRATINGEXTRACT
ENTITYSECLENDINGEXTRACT
ENTITYSTATISTICEXTRACT
GENISSUEANALYTICEXTRACT
PRICINGREPORTEXTRACT
ISSUERRELEXTRACT
ISSUEEXCHANGEPRICEEXTRACT
ISSUERENTRELEXTRACT
ISSUERESGEXTRACT
ISSUERRATINGEXTRACT
ISSUERREGULATORYEXTRACT
CONTROLCENTEREVENTLOGEXTRACT
EAGLEADMINISTRATIONSETTINGSEXTRACT
Support of the following Feeds have been added in Extract Services (MC2).
ENTITYCOLLATERALSUMMEXTRACT
ENTITYANALYTICEXTRACT
ENTITYPEERGROUPRANKINGEXTRACT
ENTITYRATINGEXTRACT
ENTITYSECLENDINGEXTRACT
ENTITYSTATISTICEXTRACT
PRICINGREPORTEXTRACT
ISSUERENTRELEXTRACT
ISSUERESGEXTRACT
ISSUERRATINGEXTRACT
ISSUERREGULATORYEXTRACT
CONTROLCENTEREVENTLOGEXTRACT
EAGLEADMINISTRATIONSETTINGSEXTRACT
SDP-20827: Corrected the mapping for the AccountingTrade Python rule
...
Supported EagleML filters:
Date Filter
Sources Filter
Entity Filter
User Group Filter
Common Filter
Changed files:
extracts.rsf
extract_service.rsf
t_eagleml-2-0_streaming.rsf
w_config.inc
...
These options enable logic for storing extended information about the incoming files in the database instead of a file on the app server.
SDP-19850: Updated the Warehouse Position rules for loading and extracting the new Liquidity data model
...
Added support for two new RTR parameters JMSExtractDeliveryStream and CollectDistributionErrors in the eagle_wrf_generic_extract workflow when the ExtractDeliveryMethod='JMS'.
The corresponding global parameter are also supported with the W_COLLECT_DISTRIBUTION_ERRORS global parameter.
RTR Sample Parameters:
<taskParameter>
<name>CollectDistributionErrors</name>
<dataType>S</dataType>
<value>JMS</value>
</taskParameter>
<taskParameter>
<name>JMSExtractDeliveryStream</name>
<dataType>S</dataType>
<value>JMS_stream_sample_extract</value>
</taskParameter>
w_config_custom Sample Parameters:
<COL TAG="W_COLLECT_DISTRIBUTION_ERRORS" EXPRESSION= "'JMS'"/>
<COLTAG="W_JMS_DEF_EXTRACT_STREAM"EXPRESSION="'JMS_EAGLE_extract'"USERDESCRIPTION="Default JMS EXTRACT Delivery Stream"/>
Files changed:
eagle_default_cm_file_distribution.xml
reporter_dist_methods.inc
eagle_wrf_generic_extract.wrf
eagle_wrf_generic_extract.ejmwf
...
The following changes in the profiles syntax have been added:
If the file is part of the archive, the archive mask should be specified before the file mask as follows: [package mask]/[sourсe file mask]
- As usual, one of the files
Only one file per profile should be a bundle trigger. To mark a file as a bundle trigger, prefix it with the tilde symbol: ~bundle_archive/source_file
Archived and plain files may appear together in one profile.
Files changed:
eagle/estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/ndfa/launch_load_by_profile.inc
eagle/estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/ndfa/ndfa_exec.xml
eagle/estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/unpacker/custom_routing.inc
eagle/estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/unpacker/send_to_wrf.xml
eagle/estar/tpe/dynamic/pyrules/eagleinvsys/wrf_generator/_main_.py
Files added:
eagle/estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/run_wrf_instance.inc
...
SDP-9466: Added the ability to extract a Static or Dynamic Entity List
Added two new FeedTypes were added:
STATICENTITYLISTEXTRACT
DYNAMICENTITYLISTEXTRACT
Both feeds are based on ENTITYLISTLISTEXTRACT rules and have the same output structure and are supported by Generic Extract workflow.
STATICENTITYLISTEXTRACT – extracts only static Entity with type LIST, dynamic lists will be ignored.
EntityFilter(Optional) – type can be only EntityList or ProcessCenter.DYNAMICENTITYLISTEXTRACT– extracts only dynamic Entity with type LIST, static lists will be ignored.
EntityFilter(required) with type EntityList
Changed files:
eagle_ml-2-0_cm/extract_filter_entity.inc
eagle_ml-2-0_cm/out/tagvalue/extract_entity_list_list.inc
eagle_ml-2-0_cm/out/tagvalue/extracts.rsf
eagle_ml-2-0_cm/out/xml/extract_service.rsf
eagle_ml-2-0_cm/out/xml/extract_service_start.inc
eagle_ml-2-0_cm/out/xml/t_eagleml-2-0_out_extract_service.rsf
eagle_ml-2-0_cm/out/xml/t_eagleml-2-0_streaming.rsf
eagle_ml-2-0_cm/out/xml/t_entity_list_list_streaming.inc
eagle_ml-2-0_cm/w_config.inc
Production Bugs
SDP-23322: Corrected logic for CreateConsolidatedTSR query
The CreateConsolidatedTSR query was working incorrectly in case of when the varchar columns in sub-select the subselect contained non-alpha values, and as alphanumeric values. As a result, the ConsolidatedTSR was not created. This issue was fixedidentified and corrected.
Changed files:
eagle/estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/out/xml/task_reporter.xml
...
SDP-22713: Fixed lastTradeDate mapping for Exchange Price Object type
Value The value for the lastTradeDate is loading correctly now via the RDC Price Evnet Event and panel.
Changed files:
xml-ref_security_pricing_common.inc
...
The records grouping was removed from transformation. Every extracted record is now enveloped under a separate <accountingTransaction> node.
Changed file:
t_acct_cash_journal_streaming.inc
SDP-22083: Logic for the Distribution Rate Summary model was improved for within the WRHSNAVMULTIEXTRACT
The total summary value in the Distribution Rate model was equal to sum of rate the rates of all processed records for a given Portfolio Account, Valuation Date and Share Class.
Such approach had a problem in case of canceled records. Calculations The subtotals were corrected to properly account for canceled records.
The logic was changed to reflect the correct total sum reversing cancels when they are present in the dataset.
Changed rules:
• extract_nav_multi_me_details_tables.inc
...
SDP-20418: GenericSMF load replaces some xref data with Primary Asset or Alt Asset values
When the GenericSMF was loaded via panels (accountingValidationFlag=Y) and the Primary Asset Type, and/or Alt Asset Type had any values in the Xref ('ISIN', 'SEDOL', 'RIC', 'BBID', 'SICOVM', 'VALOREN', 'CMM', 'INTERNAL', 'CINS') some xrefs were replaced by the Primary Asset Type or Alt Asset Type values.
Added logic to reorder of the xref before sending to the panel based on the panel replacement logic. Changes were made for the following SMF types: Equity ('EQCSCS', 'EQCSPF', 'EQCSPK'), ; Mutual Fund ('EQEQMF'), ; and Long Term Debt ('DBFLTP', 'DBIBFD', 'DBIBMU', 'DBIBPK', 'DBIVIV', 'DBMFDD', 'DBAMTL', 'DBIBTL').
...
SDP-20235: Entitlement filter for SP-Based Extracts was improved
Fixed issues related to the Entitlement filter with the attribute "all entities are included" in SP-Based Extracts.
The following changes were implemented:
1) If the Entity filter and the Entitlement filter (RTR parameter is ‘usergroups’) are used at the same time, the Entitlement filter works as an additional restriction for Entity filter (default logic).
2) If the Entitlement filter is only used (RTR parameter is ‘usergroups’), the extract performed performs according to the Business group assigned:
When the Business group with a list of specific entities is used,
thenit works as the source for allowed portfolios for next processing in extract (default logic).
When the Business group with the attribute "all entities are included" is used, the extract will be cancelled with the error message: "User Group with access to all entities cannot be used without Entity filter".
This logic works only for following extracts:
CASHJOURNALEXTRACT Accounting Cash Journal
COMPLIANCE2A7PRICINGEXTRACT Accounting Compilance 2a7 Picing Report
CONSEARNEDINCOMEEXTRACT Accounting Cons Earned Income
EXPENSEACTIVITYEXTRACT Accounting Expense Activity
FAIRVALUECOMPARISONEXTRACT Accounting Fair Value Comparison
POSITIONASOFEXTRACT Accounting Position AsOf
REALIZEDGAINLOSSEXTRACT Accounting Realized Gain Loss
TRIALBALANCEEXTRACT Accounting Trial Balance
UNAPPROVEDVARMARGINEXTRACT Accounting Unapproved Var Margin
UNSETTLEDTRANSACTIONSEXTRACT Accounting Unsettled Transactions
WEIGHTEDAVERAGEEXTRACT Accounting Weighted Average
WORKINGTRIALBALANCEEXTRACT Accounting Working Trial Balance
...