Enhancements
SDP-81873 / SDP-87341 New Data Rules Resource to Support PERFORMDBO.PERF_APPROVAL_JOURNAL database table
New resource, warehousePerformanceSummaryStatus was added to support data extract from PERFORMDBO.PERF_APPROVAL_JOURNAL.
Extract will pull records updated in the table PERF_APPROVAL_JOURNAL via Performance Wizard User Interface.
The ingestion to Vault process will update the field STATUS_FLAG in the PERFORMDBO.PERF_SUMMARY table by using data from table PERF_APPROVAL_JOURNAL.
The DeltaBatch filter works with Performance Journal UpdateDate field - PERF_APPROVAL_JOURNAL.UPDATE_DATE instead of UpdateDate field from the main table - PERF_SUMMARY.UPDATE_DATE. It allows to select changes reflected in journal table only.
Load interface will be added later.
Files changed:
eagle-vocab-enumerations.json
eagledb-inventory.json
vault\eagle-vault-model.json
eagle-vocab-wh.json
definition/eagle-vocab-definition-wh.json
warehouseperformancesummarystatus.json
warehouseperformancesummarystatus-models.json
SDP-86216 Required fields mapped in Generic Transform Workflow
Generic Transform Workflow is updated for the Generic SMF. Filemask for incoming csv files is
...
/eagle_ml-2-0_workflows/eagle_wrf_csv_smf_generic.wrf
/eagle_ml-2-0_workflows/eagle_wrf_csv_smf_generic.map
/eis/ejmtsk/eagle_wrf_csv_smf_generic_tsk/eagle_wrf_csv_smf_generic_tsk.ejmstr
/eis/ejmwf/eagle_wrf_csv_smf_generic.ejmwf
/pyrules/custom/eagle_wrf_csv_smf_generic_tsk/eagle_wrf_csv_smf_generic_tsk.py
/eagle_wrf_csv_smf_generic_tsk.pkg
SDP-85599 EagleML Global Tax Rate interface was enhanced with the doubleTaxReclaimRate element for both Load and Extract
New element doubleTaxReclaimRate supported within the Global Tax interface for load - GlobalTaxRate and extract - GLOBALTAXRATEEXTRACT.
...
Files changed:
eagleml/schema/eagleml-sec-shared-2-0.xsd
eagle_default/in/xml/xml-ref_global_tax_rate.xml
eagle_ml-2-0_cm/out/xml/t_globaltaxrate_streaming.inc
eagle_ml-2-0_cm/out/tagvalue/extract_globaltaxrate.inc
SDP-87774 Data Rules Security Resolution Service was Enhanced
The logic for default asset resolution mode ALL and for INVESTMENT_TYPE option was fixed.
Files changed:
metadata/core/ontology/templates/includes/defaultassetresolution.json
metadata/core/ontology/eagle-resolution.json
SDP-87658 Support of SHARE_CLASS Added for WarehouseTrade resource
Support of the field TRADE_DETAIL.SHARE_CLASS was added for Eagle DB Model version >= '2017.2.44.0'.
XSD name is: shareClass.
Files changed:
warehousetrade-models.json
SDP-87458 Update generic load workflow to be able to control Processing statuses message limit
procstatusmsgsize - parameter was added to the all generic load steps, in order to be able to control processing status message limit. It can be useful for troubleshooting tasks, when error message is too big and there is a need to extend it.
Files Changed:
estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/set_eds_params.inc
estar/tpe/dynamic/msgcenter/eagle_ml-2-0_workflows/eagle_wrf_generic_load.wrf
SDP-86848 Data Rules Profile Templates for Conversion and Cloud Workflows for New Resources
Added Data Rules profile templates for the Conversion and Cloud Workflows for warehousetradecharges and warehouseperformancesummarystatus resources.
...
Files changed:
eagle/estar/EAGLE_EXTRACTSERVICE.pkg
eagle/estar/eagle_default_workflows.pkg
SDP-87458 Update generic load workflow to be able to control Processing statuses message limit
Added Data Rules profile templates for the Conversion and Cloud Workflows for warehousetradecharges and warehouseperformancesummarystatus resources.
...
Files changed:
eagle/estar/EAGLE_EXTRACTSERVICE.pkg
eagle/estar/eagle_default_workflows.pkg
SDP-87771 EagleML Entity History outbound interface was enhanced to support delta mode
The EagleML DeltaBased ENTITYEXTRACT in history mode is now supported.
Files changed:
eagle_ml-2-0_cm/out/tagvalue/extract_delta_based_param.inc
SDP-87546 EagleML MultilegSMF load updates to support accurate load of xreference identifiers for all legs
Previously, the xreference identifiers were not mapped into XMLDBAPI for Pay and Receive legs and incorrectly reset before processing Pay and Receive legs.
...
Files changed:
eagle_default/in/xml/xml-smf_multileg_swap.xml
SDP-87502 EagleML Voluntary Election inbound interface was enhanced with Entity Bank relationship resolution for update and delete operations
The EagleML Voluntary Election inbound interface was enhanced with the Entity Bank relationship resolution for update and delete operations.
...
Files changed:
eagle_default/in/xml/xml-ref_voluntarycaelections.xml
eagle_default/in/xml/t_eagle_ml-2-0_default_in_xml_delete_voluntary_ca_election.xml
SDP-87160 EagleML Warehouse Open Lot outbound interface was enhanced with custodian bank related elements
Custodian related elements were added to the EagleML Warehouse Open Lot - WRHSOPENLOTEXTRACT outbound interface:
...
Files changed:
eagle_ml-2-0_cm/out/tagvalue/extract_warehouse_openlot.inc
eagle_ml-2-0_cm/out/xml/t_warehouse_openlot_streaming.inc
SDP-88254 EagleML Working Trial Balance outbound interface was enhanced with new date parameters
Four new date parameters have been added to comply with the Eagle Standard Report for the Working Trial Balance - WORKINGTRIALBALANCEEXTRACT:
...
Files changed:
dynamic/msgcenter/eagle_ml-2-0_cm/out/tagvalue/extract_acct_working_trial_balance.inc
dynamic/eagleml/swagger/swagger-extracts.json
SDP-88126 Data Rules resource vendorcashflow was updated to support UpdateDate filter
The UpdateDate filter is supported now for the Data Rules vendorcashflow resource and the Delta process is operational now.
Additional supported parameters are todate and fromdate.
Files changed:
vendorcashflow.json
SDP-87194 Data Rules Security Resolution Service was Enhanced
The logic for the tagNochangecase element and CASE_INSENSITIVE asset resolution option was synchronized to act the same way as for EagleML.
For the tagNochangecase element, a user can specify tags that are case sensitive and should be used as is in the asset resolution process.
The CASE_INSENSITIVE option is applied to Xreference Ids only. With this option, all Xreference Ids will be converted to uppercase regardless of the tagNochangecase element.
Files changed:
src/eagleinvsys/etl/core_etl/resolution_service.py
src/eagleinvsys/etl/core_etl/resolution_service_enum.py
metadata/core/ontology/templates/includes/defaultassetresolution.json
metadata/core/ontology/eagle-resolution.json
SDP-86331 Improve logic for mode alwayscommit=N
The logic for the alwayscommit = N mode has been enhanced to rollback committed records in case a validation issue is detected during the pre-load stage. Previously, these records were still loaded despite failing validation.
...
Files Changed:
common_core/descriptor/dbdescriptor.py
SDP-86240 Metadata for entityshareclass resource was updated
The metadata synched with the Eagle Core database as the additional fields below are supported for load and extract:
...
metadata/core/ontology/definition/eagle-vocab-definition-entity-shared.json
metadata/core/ontology/eagle-vocab-entity-shared.json
metadata/core/ontology/entity/entityshareclass-models.json
SDP-85678 genericsmf resource metadata was updated to correct field type differences between source and target
The checksum functionality was raising an alert due to a field type mismatch between Eagle and Vault. The metadata for the genericsmf resource was corrected. The field type was change from Integer to Float for the following fields:
...
Files changed:
ontology/reference/genericsmf-models.json
SDP-86952 PACE object updated to support eHashLogin mode
New functionality is added for the Pace object: it now supports both the eLiteLogin mode and eHashLogin mode.
...
Files changed:
eagleinvsys/vendor/pace.py
SDP-85066 Data Rules support for warehousetradecharges resource
Data Rules warehousetradecharges resource was created to support data load into Oracle using core stored procedure - TRADESDBO.EGL_GEN_TRADE.TRADE_CHARGES_INSUPD
Resource also supports Eagle - Vault pipeline, extract data from Eagle and upload to Vault.
...
Files added:
metadata/core/ontology/templates/db_oper/snowflake/warehousetradecharges.reinit_batch_many.sql
metadata/core/ontology/templates/eagle_wrhs_warehousetradecharges_insertupdate.txt
metadata/core/ontology/templates/eagle_wrhs_warehousetradecharges_reinitbatch.oracle.txt
metadata/core/ontology/templates/eagle_wrhs_warehousetradecharges_reinitbatch.snowflake.txt
metadata/core/ontology/warehouse/warehousetradecharges_in.json
SDP-86236 Added New Fields for Data Rules warehouseopenlot Resource
Additional fields have been added into the Data Rules Ontology to synchronize with the core Eagle Database.
...
Files changed:
eagle-vocab-wh-shared.json
eagle-vocab-definition-wh-shared.json
warehouseopenlot_in.json
warehouseopenlot-models.json
Production Bugs
SDP-85314 Multileg SMF Support In Composite And History Mode For Additional Elements
New security elements typeOfBond - Tag 18565 and armInitFixedPeriodMonths - Tag 18566 are supported within the MultilegSMF interface for both load - GenericSMF and extract - SMFEXTRACT in composite and history mode.
...
Files changed:
eagle_default/in/xml/include/contract_mapping.inc
eagle_default/in/xml/include/contract_leg_alliases.inc
eagle_default/in/xml/include/pay_mapping.inc
eagle_default/in/xml/include/pay_leg_alliases.inc
eagle_default/in/xml/include/receive_leg_alliases.inc
eagle_default/in/xml/include/receive_mapping.inc
eagle_default/in/xml/xml-smf_multileg_swap.xml
eagle_default/in/xml/include/ins_upd_smf_req.inc
SDP-87379 Fixed SMF extract extension mapping issue
Added missing include references to correct extensions mapping in extract
Files changed:
estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/out/xml/t_smf_streaming.inc
SDP-87251 HTTP SOAP request Calls all MC2 instances if the localhost returns "Connection refused" Error
If MC2 SOAP request to localhost returns “Connection refused“ error, then on the next try the request will be sent to all MC2 instances based on the existing configuration from the estar/tpe/cfg/eaglemc2s/mc2-nodes.txt. All nodes will be used one by one until a success status is returned. The mc2 instances are only used if the localhost returns “Connection refused“ error.
...