EagleML Release Notes - June 2nd, 2021

Owned by Olga Galis (Deactivated)
Jun 02, 2021
3 min read

Enhancements

SDP-50662 The Warehouse Position Inbound and Outbound interfaces were enhanced to support an additional field

The Warehouse Position Interface was updated to support an additional field on the inbound and outbound interfaces:

HOLDINGDBO.POSITION_COST_DETAIL.TAX_EXPENSE_BASE (tag 15709)

Xpath:
EagleML/warehouseTransaction/warehousePosition/taxExpenseBase

Files changed:
eagle_default/in/xml/xslt/wrh_egl_gen_interface3.xsl
eagle_ml-2-0_cm/out/xml/t_warehouse_position_streaming.inc
eagle_ml-2-0_cm/out/xml/t_warehouse_position_xmldbapi_streaming.inc

SDP-50530 The list of supported EJM errors was expanded to correct discrepancies displayed in case of loopback failures

The list of supported errors via the EagleML rule was enhanced to avoid inconsistency between the EJM and the Automation Center corresponding events statuses.

The handling of the following error was added: ‘Checking the loopback\[XMLDBAPI] completion status. Failure.’

Files changed:
eagle_ml-2-0_cm/get_sched_event_detailed_log.inc
eagle_ml-2-0_cm/get_sched_event_log.inc

SDP-50485 The Warehouse Trade Inbound interface was enhanced to support additional user_char and user_float fields on load

The Warehouse Trade interface was updated to support below fields on load:

XPath:
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar4
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar5
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar6
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar7
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar8
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar9
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar10
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar11
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar12
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar13
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar14
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar15
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar16
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar17
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar18
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar19
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar20
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar21
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar22
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar23
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar24
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar25
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar26
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar27
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar28
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar29
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar30
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat4
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat5
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat6
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat7
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat8
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat9
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat10
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat11
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat12
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat13
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat14
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat15
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat16
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat17
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat18
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat19
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat20
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat21
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat22
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat23
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat24
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat25
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat26
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat27
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat28
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat29
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat30

File changed:
eagle_default/in/xml/xslt/wrh_egl_gen_interface3.xsl

SDP-50310 Created new Inbound interface - Double Sided Ledger Entry

Added the ability to load a double-sided ledger entry. The new interface LedgerPostingDualEntry enables the user to load to both the general ledger credit and debit accounts in a single request. It provides the ability to post to a specific security by setting the resolveSecurityForPostingFlag to Y.

Sample Message:

<EagleML eaglemlVersion="2-0" eaglemlType="AccountingTransactionMessage" eaglemlRevision="370" xsi:schemaLocation="<<http://www.eagleinvsys.com/2011/EagleML-2-0 >> eagleml-main-2-0.xsd" xsi:type="AccountingTransactionMessage" xmlns:xsi="<<http://www.w3.org/2001/XMLSchema-instance%22 >> xmlns="<<http://www.eagleinvsys.com/2011/EagleML-2-0%22 >>>
<header>
<messageId>UVLBGHI3BKMBBFMD</messageId>
<sentBy><<<http://www.eagleinvsys.com/%3C/sentBy%3E%3E%3E%3E
<sendTo><<<
<creationTimestamp>2021-05-10T12:14:17-04:00</creationTimestamp>
</header>
<taskIdentifier>
<correlationId>TEST_DOUBLE_{GUID}</correlationId>
<businessTaskId>Test_DOUBLE</businessTaskId>
<sequenceNumber>1</sequenceNumber>
</taskIdentifier>
<accountingTransaction>
<header>
<objectType>LedgerPostingDualEntry</objectType>
</header>
<ledgerPostingDualEntry>
<entityId>SDP50310</entityId>
<resolveSecurityForPosting>N</resolveSecurityForPosting>
<primaryAssetId>SDP50310A</primaryAssetId>
<primaryAssetType>CUSIP</primaryAssetType>
<longShortIndicator>L</longShortIndicator>
<accountingBasis>USTAX</accountingBasis>
<effectiveDate>20180526</effectiveDate>
<accountingDate>20180526</accountingDate>
<glDebitAccount>1007000500</glDebitAccount>
<glCreditAccount>4001000100</glCreditAccount>
<units>51.00</units>
<ledgerNoteDescription>NOY</ledgerNoteDescription>
</ledgerPostingDualEntry>
</accountingTransaction>
</EagleML>

eagle_default/in/xml/xml-acct_ledgerposting.xml
eagle_default/in/xml/xml-acct_cash.rsf
eagle_ml-2-0_cm/resolve_inbound_stream_name.inc

SDP-49980 The Ontology was updated to contain logical database keys for Reference objects

The Ontology was updated to contain logical database keys for Reference objects (for objects have separate simple unique keys and complex logical DB keys).

Files changed:
core/ontology/reference/client.json
core/ontology/reference/genericca.json
core/ontology/reference/issuefxratedemand.json
core/ontology/reference/issueranalytic.json
core/ontology/reference/issuerorganization.json
core/ontology/reference/issuerrole.json
core/ontology/reference/rating.json
core/ontology/reference/reportdictionarylinkedasset.json
core/ontology/reference/reportdictionarysummary.json
core/ontology/reference/securitydefault.json
core/ontology/reference/securityoverrides.json
core/ontology/reference/targetfxrate.json
core/ontology/reference/tradequotes.json
core/ontology/reference/voluntarycaelection.json
core/ontology/reference/yieldcurve.json

SDP-49718 The Insert SQL block for the EDS Warehouse resource was improved

The Ontology was improved for the WarehousePosition resource. Two parameters, update_source and effective_date, were previously hardcoded as part of the Insert SQL block. The code was improved and the issue was corrected.

Files changed:
dynamic_template_processor.py

SDP-46767 The Xreference Identifiers logic during the load process was improved to skip duplicate xreferences in the incoming message

During a load with duplicated Xreference Identifiers, a deadlock error was produced during the GenericSMF load within the incoming message.
The logic for the xreference load was improved to allow checking and skipping the Xreference Identifies that have already been loaded in the current message.
The process is enabled and managed through the w_config_custom by setting the global flag W_DUP_XREF_CHECK set to Y.

File changed:
eagle_default/in/xml/include/ins_upd_xrefs.inc

Production Bugs

SDP-49772 The underlyingRetainBeginDateSwitch flag logic was corrected to resolve Underlying SMF update issues on Windows/MSSQL Server

Specific to the MSSQL Server database, there was an issue identified where the existing underlyingSMF could not be updated while loading a new underlyingSMF with the underlyingRetainBeginDateSwitch flag due to incorrectly resolving the begin_date. The logic for MSSQL was corrected to resolve the dates correctly.

Files changed:
eagle_default/in/xml/include/xml-smf_underling_common.inc

SDP-48701 The DeltaBased Warehouse Position and Openlot extracts did not load correctly in Windows/MSSQL

An Insert of position details list into temporary table failed with an arithmetic overflow error. This issue was caused by the type mismatch of fields used for the POSITION_DETAIL_ID in the temporary table. The issue was resolved by changing the temporary table where the field for storing POSITION_DETAIL_ID has the correct type.

File changed:
eagle_default/in/xml/include/xml-dbdirect_wrhs_delete_statement.inc

SDP-43712 The WarehouseOpenLot Inbound Interface was corrected to support the load into custom database extension table via the XPanels application

The WarehouseOpenLot inbound interface was fixed to correctly load data into the custom database extension table.
The key fields listed below are required to create a custom Extension table:

ENTITY_ID - CHAR(8)
EFFECTIVE_DATE - DATE
SRC_INTFC_INST - NUMBER
LOT_LEVEL_POSITION - NUMBER

Files changed:
eagle_default/in/xml/include/wrhs_ext_custom_fields.inc
eagle_default/in/xml/include/xml-warehouse_common.inc

Â