ESP-358: STAR v2017 EagleML - Inbound Cash Tender, Cash Dividend and PIK Bond Corporate Action Announcement failing with required To Security Alias Tag302
...
The parameters for transType, cpStatus, clientSpecificCAId, cpReason, sweepdate, fromsweepdate, and tosweepdate were all added to the core rules to enable the filters to be used in the extract.
Example of RTR
Example of RTR:
<EagleML xsi:type="RunTaskRequestSync" eaglemlType="RunTaskRequest" eaglemlVersion="2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
...
Files changed:
- extract_acct_rejection.inc
ESP-1420: EagleML - GLACTIVITYEXTRACT - @RecordCount on the GLACTIVITYEXTRACT is not matching the DB count
When ExtractNamePatternEx parameter is included in the RTR used to kick of the generic extract workflow the record count on the GLACTIVITYEXTRACT would not match the DB count.
This issue was introduced as part of the May2018 release and changes were rolled back to correct the logic for the :totalCount: variable which is responsible for the record count. These changes allowed the record count to once again match the DB count.
List of files changed:
eagle_ml-2-0_cm/extract_filter_gl_activity.inc
eagle_ml-2-0_cm/out/xml/t_acct_gl_activity.xml
eagle_ml-2-0_cm/out/xml/t_acct_gl_activity_streaming.inc
ESP-1426: allow to provide xrefId and xrefIdType instead of entityId in KEY files for warehouse objects
...
estar\tpe\dynamic\msgcenter\eagle_default\in\xml\ xml-dbdirect_invar_rollup.xml
ESP-1427: @recordCount in filename not matching test bed records for the WRHSOPENLOTEXTRACT when passing the <IncludeAccrualRate> task parameter
ESP-1543: Totalcount in extract file name mismatch the real records count
The AccrualIncome sub-query logic was changed to return only one value for any OPEN_EVENT_ID or TRADE_DT. This value will be derived by taking the larger value from the ESTAR_INCOME_ACTIVITY.TRADE_DT and ESTAR_INCOME_ACTIVITY.OPEN_EVENT_ID fields. This logic is triggered when the IncludeAccrualRate parameter is included.
<taskParameter>
<name>IncludeAccrualRate</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
This change hindered performance slightly since neither one of the queried fields are indexed. If custom indexes for these fields are added the performance will be improved.
Before:
left outer join (SELECT COUPON,OPEN_EVENT_ID,TRADE_DT FROM ESTAR.ESTAR_INCOME_ACTIVITY
WHERE INSTANCE NOT IN (SELECT INSTANCE FROM ESTAR.ESTAR_CXL_INCOME_ACTIVITY) GROUP BY OPEN_EVENT_ID, TRADE_DT,COUPON ) ESTAR_INCOME_ACTIVITY
on LOT_LEVEL_POSITION.ORIG_LOT_NUMBER = ESTAR_INCOME_ACTIVITY.OPEN_EVENT_ID AND
LOT_LEVEL_POSITION.EFFECTIVE_DATE = ESTAR_INCOME_ACTIVITY.TRADE_DT
After:
left outer join (SELECT COUPON,OPEN_EVENT_ID,TRADE_DT FROM ESTAR.ESTAR_INCOME_ACTIVITY,
( SELECT max(INSTANCE) INSTANCE FROM ESTAR.ESTAR_INCOME_ACTIVITY
WHERE INSTANCE NOT IN (SELECT INSTANCE FROM ESTAR.ESTAR_CXL_INCOME_ACTIVITY)
GROUP BY OPEN_EVENT_ID, TRADE_DT) SUB_ESTAR_INCOME_ACTIVITY WHERE ESTAR.ESTAR_INCOME_ACTIVITY.INSTANCE = SUB_ESTAR_INCOME_ACTIVITY.INSTANCE) ESTAR_INCOME_ACTIVITY
on LOT_LEVEL_POSITION.ORIG_LOT_NUMBER = ESTAR_INCOME_ACTIVITY.OPEN_EVENT_ID AND
LOT_LEVEL_POSITION.EFFECTIVE_DATE = ESTAR_INCOME_ACTIVITY.TRADE_DT
ESP 1554: EagleM: Issue with logic for the tag3931/tag11/tag14/tag1432/85/961 in the underlying_smf_ins_upd.
...
All changes were made in the file:
generate_sp_on_fly.inc
ESP-1616: Add Newly Created Decryption Code to the Core EML Stream
Added decryption to the logic in the eagle_ml-2-0_default_cm_ndfa_exec stream. The stream is now capable of decrypting all files with gpg and pgp extensions.
By default this functionality is only applied to files that are using extensions but this can be controlled with the W_NDFA_INCOMING_ENCRYPTED global variable. The following values have the corresponding behaviors:
* EXTENSION BASED or no value - extensions only. This enables mode when only files with .gpg or .pgp extension (case insensitive) are considered as encrypted files and decryption is performed on files with this kind of extension. Type of decryption utility to use (gpg or pgp) is determined based on the file extension.
* ALL - handle all files as encrypted. The type of decryption is determined by region configuration.
* NONE - disable decryption of all incoming files.
...
The following columns were requested as additions to the WRHSTRADEEXTRACT: from the TRADESDBO.TRADE_EXT table:
ElementName | DBField | Field Type / Length |
stGainSecLocal | ST_GAIN_SEC_L | NUMBER(38,12) |
stLossSecLocal | ST_LOSS_SEC_L | NUMBER(38,12) |
stGainSecBase | ST_GAIN_SEC_B | NUMBER(38,12) |
stLossSecBase | ST_LOSS_SEC_B | NUMBER(38,12) |
stGain | ST_GAIN | NUMBER(38,12) |
stLoss | ST_LOSS | NUMBER(38,12) |
stGainCurrency | ST_GAIN_CRRCY | NUMBER(38,12) |
stLossCurrency | ST_LOSS_CRRCY | NUMBER(38,12) |
ltGainSecLocal | LT_GAIN_SEC_L | NUMBER(38,12) |
ltLossSecLocal | LT_LOSS_SEC_L | NUMBER(38,12) |
ltGainSecBase | LT_GAIN_SEC_B | NUMBER(38,12) |
ltLossSecBase | LT_LOSS_SEC_B | NUMBER(38,12) |
ltGain | LT_GAIN | NUMBER(38,12) |
ltLoss | LT_LOSS | NUMBER(38,12) |
ltGainCurrency | LT_GAIN_CRRCY | NUMBER(38,12) |
ltLossCurrency | LT_LOSS_CRRCY | NUMBER(38,12) |
clsAmortLocal | CLS_AMORT_LOCAL | NUMBER(38,12) |
clsAmortBase | CLS_AMORT_BASE | NUMBER(38,12) |
clsOidLocal | CLS_OID_L | NUMBER(38,12) |
clsOidBase | CLS_OID_B | NUMBER(38,12) |
clsIlbIncLtdLocal | CLS_ILB_INC_LTD_LOCAL | NUMBER(38,12) |
clsIlbIncLtdBase | CLS_ILB_INC_LTD_BASE | NUMBER(38,12) |
gainCurrency988 | GAIN_CRRCY_988 | NUMBER(38,12) |
lossCurrency988 | LOSS_CRRCY_988 | NUMBER(38,12) |
gainLossCurrency988 | GAIN_LOSS_CRRCY_988 | NUMBER(38,12) |
washsaleDisallowedReversalLocal | WS_DISALLOW_REV_L | NUMBER(38,12) |
washsaleDisallowedReversalBase | WS_DISALLOW_REV_B | NUMBER(38,12) |
impairmentLtdLocalExt | IMPAIRMENT_LTD_LOCAL | NUMBER(38,12) |
impairmentLtdBaseExt | IMPAIRMENT_LTD_BASE | NUMBER(38,12) |
impairmentFxLtd | IMPAIRMENT_FX_LTD | NUMBER(38,12) |
...
Files changed:
extract_warehouse_trade.inc
...