Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SDP-17628:  User was loaded with Disabled Status in EML User Stream

Object type User was loaded with disabled state when elements <accountState> or <active> (in case of SCIM load) were absent in incoming data file.

Logic was updated to load User with enabled state by default.

Files changed:
user_common.inc

SDP-10666:  Critical errors in "eagle_ml-2-0_default_in_xml_smf_mi" stream, but final status is SUCCESS

Streams eagle_ml-2-0_default_in_xml_smf_mi and eagle_ml-2-0_default_in_xml_issuer_mi had SUCCESS status although XSL-transformations inside them failed.

Added XSL-transformation errors handling to report correct status.

Files changed:
xml-ref_issuer.prf
xml-smf_generic_batch.prf

SDP-17749:  EntityList filter including Dynamic and Static filters creates incorrect sub query when EntityId contains: symbol

There was a problem with extracts when EntityList filter contained entities with special characters. As a result extract returned incorrect "no data" status.

Entity filter logic was enhanced to handle EntityId with special characters properly.

File changed:
eagle_ml-2-0_cm/extract_filter_entity.inc

SDP-14430:  IssuerOrg Delta extract can be run with historyonlyflag enabled

Incorrect query was generated for Issuer Organization extract when combination of parameters historyonlyflag = ‘Y’ and deltabased = ‘Y’ was used.

The logic was updated to use correct table (ISSUER_ORGANIZATION_HIST) in delta mode filters.

File changed:
\eagle_ml-2-0_cm\out\tagvalue\extract_delta_based_param.inc

SDP-10589 EJM:  Prevent multiple STAR Schedule executions during reprocess

Multiple star schedule executions were triggered when Message Center Processing resumed SDP-17628:  User was loaded with Disabled Status in EML User Stream

Object type User was loaded with disabled state when elements <accountState> or <active> (in case of SCIM load) were absent in incoming data file.

Logic was updated to load User with enabled state by default.

Files changed:
user_common.inc


SDP-10666:  Critical errors in "eagle_ml-2-0_default_in_xml_smf_mi" stream, but final status is SUCCESS

Streams eagle_ml-2-0_default_in_xml_smf_mi and eagle_ml-2-0_default_in_xml_issuer_mi had SUCCESS status although XSL-transformations inside them failed.

Added XSL-transformation errors handling to report correct status.

Files changed:
xml-ref_issuer.prf
xml-smf_generic_batch.prf


SDP-17749:  EntityList filter including Dynamic and Static filters creates incorrect sub query when EntityId contains: symbol

There was a problem with extracts when EntityList filter contained entities with special characters. As a result extract returned incorrect "no data" status.

Entity filter logic was enhanced to handle EntityId with special characters properly.

File changed:
eagle_ml-2-0_cm/extract_filter_entity.inc


SDP-14430:  IssuerOrg Delta extract can be run with historyonlyflag enabled

Incorrect query was generated for Issuer Organization extract when combination of parameters historyonlyflag = ‘Y’ and deltabased = ‘Y’ was used.

The logic was updated to use correct table (ISSUER_ORGANIZATION_HIST) in delta mode filters.

File changed:
\eagle_ml-2-0_cm\out\tagvalue\extract_delta_based_param.inc


SDP-10589 EJM:  Prevent multiple STAR Schedule executions during reprocess

Multiple star schedule executions were triggered when Message Center Processing resumed after interruptions in its execution.

...

EJM Logic was enhanced to let Users to set up parameters with names to make workflow schedules more user friendly.

Added handling for incoming parameters from automation center based on parameter name

Tags related to parameters:
:tagName: := '1166' – :paramName: := ProfileName
:tagName: := '1174' – :paramName: := WORKFLOWENGINE
:tagName: := '1176' – :paramName: :=  WorkflowName / PROFILEDWORKFLOW
:tagName: := '1177' –  :paramName: := corrIdPrefix.

Added handling for incoming parameters from automation center based on parameter name

Tags related to parameters:
:tagName: := '11781166' –   :paramName: := DataTaskEmailDistributionListProfileName
:tagName: := '11791174' –   :paramName: := EnableTimeoutCancel (Y/N)= WORKFLOWENGINE
:tagName: := '11801176' –   :paramName: := EJMRunTimeout

Files changed:
estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/schedule/workflow_restart.sch

SDP-15818:  New Feedtype to extract Warehouse Trade Charges data

A new outbound interface was added to the warehouseTradeCharges EagleML object.

Feed type: WRHSTRADECHARGESEXTRACT.

Supported filters:

  • Entity filters
  • User Groups filter
  • Date filters: updatedate, effectivedate, accountingdate, postdate, ledgereffdate, monthendaccountingdate, tradedate, settlementdate
  • Source filter
  • SMF filters
  • maxrows filter
  • CustomWhere filter

Files added:
extract_warehouse_trade_charges.inc
extract_warehouse_trade_charges.xml
t_warehouse_trade_charges_streaming.inc
t_warehouse_trade_charges_streaming.xml

Files changed:
extracts.rsf
t_eagleml-2-0_streaming.rsf
w_config.inc

SDP-15250:  Add concatenated values to calcMasterTransactionId on WRHSOPENLOTEXTRACT and WRHSCLOSELOTEXTRACT

New field 'calcMasterTransactionId' was added to Warehouse OpenLot and CloseLot Extracts. 
The field contains a concatenated value from 'acctBasis', 'entityId', 'securityAlias', 'longShortIndicator' and some others fields.

Files changed:
extract_warehouse_openlot.inc
t_warehouse_openlot_streaming.inc
extract_warehouse_closelot.inc
t_warehouse_close_lot_streaming.xml
t_warehouse_closelot_streaming.inc

SDP-16498:  Unable to load EagleML ‘accountingTrade’ feedtype with buySellIndicator=’REC’ or ‘DEL’

When Receive or Deliver Accounting Trade was loaded, there was an error about values of Cross Reference Identifiers were missing (tags 1233 and 1234).

Obsolete mapping was removed for all Accounting Trade types which was overwriting these tags with empty values.

Files changed:
eagle_default\in\xml\xml-accttrade_buy, xml-accttrade_cancel, xml-accttrade_capfundinvestments, xml-accttrade_conversion, xml-accttrade_deliver, xml-accttrade_fxfwd, xml-accttrade_fxspot, xml-accttrade_receive, xml-accttrade_sell, trd_sec_columns,
eagle_default\in\include\ csv-buy_columns, csv-capfundinvestments_columns, csv-conversion_columns, csv-deliver, csv-receive, csv-sell_columns.

SDP-10499: Redesign the ExchangePrice rule to include the logic from the RDC_PRICE_UPLOAD 

The Exchange Price loading rule has been updated to support the accountingValidationFlag with a value of Y and RDC loading process. The Issue PC Price load and Exchange Price load now use common logic for mapping and panel processing.

Files Changed:
eagle_default/in/xml/xml-ref_issuepcprice.xml 
eagle_default/in/xml/xml-ref_exchangeprice.xml
eagle_default/in/xml/xml-ref_objects.rsf

New Files:
eagle_default/in/xml/include/xml-ref_security_pricing_common.inc

 

SDP-18497: Change the workflow_restart logic similar to EJM Monitoring Tool to redirect the workflow execution to the correct engine
The workflow_restart logic was enhanced to redirect the execution of a workflow to either MC or MC2  based on the parameter WORKFLOWENGINE .

If the workflow profile has a parameter WORKFLOWENGINE with a value of Y then the workflow execution will be launched on the MC2 engine.

Files Changed:
eagle_ml-2-0_cm/out/tagvalue/workflow_restart.xml

...

A series of mapping for the following elements that were previously included were missing in the xml-ref_issuepcprice.xml: assetResolutionOption, battingOrder, securityAlias. The tagNochangecase was missing for the exchangePrice.

...

: :=  WorkflowName / PROFILEDWORKFLOW
:tagName: := '1177' –  :paramName: := corrIdPrefix
:tagName: := '1178' –  :paramName: := DataTaskEmailDistributionList
:tagName: := '1179' –  :paramName: := EnableTimeoutCancel (Y/N)
:tagName: := '1180' –  :paramName: := EJMRunTimeout

Files changed:
estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm/schedule/workflow_restart.sch


SDP-15818:  New Feedtype to extract Warehouse Trade Charges data

A new outbound interface was added to the warehouseTradeCharges EagleML object.

Feed type: WRHSTRADECHARGESEXTRACT.

Supported filters:

  • Entity filters
  • User Groups filter
  • Date filters: updatedate, effectivedate, accountingdate, postdate, ledgereffdate, monthendaccountingdate, tradedate, settlementdate
  • Source filter
  • SMF filters
  • maxrows filter
  • CustomWhere filter

Files added:
extract_warehouse_trade_charges.inc
extract_warehouse_trade_charges.xml
t_warehouse_trade_charges_streaming.inc
t_warehouse_trade_charges_streaming.xml

Files changed:
extracts.rsf
t_eagleml-2-0_streaming.rsf
w_config.inc


SDP-15250:  Add concatenated values to calcMasterTransactionId on WRHSOPENLOTEXTRACT and WRHSCLOSELOTEXTRACT

New field 'calcMasterTransactionId' was added to Warehouse OpenLot and CloseLot Extracts. 
The field contains a concatenated value from 'acctBasis', 'entityId', 'securityAlias', 'longShortIndicator' and some others fields.

Files changed:
extract_warehouse_openlot.inc
t_warehouse_openlot_streaming.inc
extract_warehouse_closelot.inc
t_warehouse_close_lot_streaming.xml
t_warehouse_closelot_streaming.inc


SDP-16498:  Unable to load EagleML ‘accountingTrade’ feedtype with buySellIndicator=’REC’ or ‘DEL’

When Receive or Deliver Accounting Trade was loaded, there was an error about values of Cross Reference Identifiers were missing (tags 1233 and 1234).

Obsolete mapping was removed for all Accounting Trade types which was overwriting these tags with empty values.

Files changed:
eagle_default\in\xml\xml-accttrade_buy, xml-accttrade_cancel, xml-accttrade_capfundinvestments, xml-accttrade_conversion, xml-accttrade_deliver, xml-accttrade_fxfwd, xml-accttrade_fxspot, xml-accttrade_receive, xml-accttrade_sell, trd_sec_columns,
eagle_default\in\include\ csv-buy_columns, csv-capfundinvestments_columns, csv-conversion_columns, csv-deliver, csv-receive, csv-sell_columns.


SDP-10499: Redesign the ExchangePrice rule to include the logic from the RDC_PRICE_UPLOAD 

The Exchange Price loading rule has been updated to support the accountingValidationFlag with a value of Y and RDC loading process. The Issue PC Price load and Exchange Price load now use the common logic for mapping and the panel processing.  The missing elements have been restored. 

 

SDP-18770 EagleML User Inbound: Add the value EXACT for the switch (tag 989) to the qusersummary and qroles panel 

The error thrown while loading User and User Group when an Username is  part of another Username was fixed.

The panels to check for existing user was updated to check for EXACT matching instead of  'LIKE' in the SQL statement. 

Example: If an User 1 with Username 'EAGLEUSER123' already exists on the environment ,  it is possible to add to load User 2 with Username 'EAGLEUSER12'.

The same logic was added for the Center Role existence check.

Option to lookup users and center roles by exact match is supported in panels 2017R2.11 version only.

Files changed:

eagle_default\in\xml\include\user_common.inc
eagle_default\in\xml\include\user_group_common.inc
.

Files Changed:
eagle_default/in/xml/xml-ref_issuepcprice.xml 
eagle_default/in/xml/xml-ref_exchangeprice.xml
eagle_default/in/xml/xml-ref_objects.rsf

New Files:
eagle_default/in/xml/include/xml-ref_security_pricing_common.inc

 

SDP-18497: Change the workflow_restart logic similar to EJM Monitoring Tool to redirect the workflow execution to the correct engine
The workflow_restart logic was enhanced to redirect the execution of a workflow to either MC or MC2  based on the parameter WORKFLOWENGINE .

If the workflow profile has a parameter WORKFLOWENGINE with a value of Y then the workflow execution will be launched on the MC2 engine.

Files Changed:
eagle_ml-2-0_cm/out/tagvalue/workflow_restart.xml