...
Held filter is Fixed for Zero Balance Securities
The InsuranceVal Extract was returning securities with zero balance despite Held filter with the 'non-zero' balance parameter being used.
If for example two different had positions in the same security, and one had a zero balance, the InsuranceVal extract would have returned both accounts. Thanks to the changes made, the account with a zero balance no longer makes the extract data.
The link between accounts and securities is added into the extract SQL in order to make the functionality work as expected:
inner join TMP_HELD_SECURITY on
TMP_HELD_SECURITY.SECURITY_ALIAS = ISTAR_LOT.ASSET_ID AND
TMP_HELD_SECURITY.PORTFOLIO_ACCT = ISTAR_LOT.PORTFOLIO_ACCT.
Files changed:
- extract_warehouse_istarlot.inc
- extract_filter_held.inc.
...
<COL TAG="varDescr_result" EXPRESSION="replace(:varDescr_result:,'|=|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
...
Adjusted EagleML Header Generating Logic
After a transformation the EagleML headers were being generated with empty values in some nodes.
Logic was updated, to work as expected. The EagleML header are now generated with all expected values filled in.
Files changed:
\eagle_ml-2-0_cm\extract_upd_header.inc
...