Manikanta Vusakoyila

Services used by Merit FTT system   FTT Service Name Tax Authority SENDEMAILS Common MSGS Common ALTRADES Common BACKPOP Common INVCALC Common ADPIMP FR TRADESIMP FR DWIMP FR S...

Scotia processes Dividend claims only.  IT – jonathan.smith@scotiabank.com, tom.koumarelas@scotiabank.com Project Manager - nelson.paiva@scotiabank.com Cognizant Sales :  Jim Dore   Web or D...

SELECT MRTID,MRTCMJREF,MRTTIMESTAMP,MRTNLINES,MRTPOSTTYPE,MRTPOSTID,MRTPOSTINF,MRTORDER,MRTEXTRVSJTEXT,MRTPOSTCAT,MRTRLSTIMESTAMP,MRT_LASTUPDATE FROM MRT_SNCLAIMSJOURNALWHERE MRTTIMESTAMP='20220804...

Instructions Setup the tool to download the local script (This step is required only once) Go to the path M:\ci_releases\Mer_builds\dev\mer.extract.local.scripts\1.0.0\latest. Copy the zip file pr...

SELECT * FROM MRT_DBCLAIMSJOURNALWHERE MRTTIMESTAMP IN ('20210824:10414804:sangmrua','20210824:08283204:sangmrua','20210824:11344504:sangmrua','20210824:11400504:sangmrua','20210824:11482704:sangmr...

FI Feed in DB Interest Claims system has an exclusion rule which excludes all claims that has PAY_SETTL_AMNT < 5000PAY_SETTL_AMNT is the name of the column in the source file. The standard name for...

Make sure below line is added in the beginning just after value for nls_length_semantics is set alter session set current_schema= ICLAIMAPP; Find an replace below one by one. ALTER TABLE MRT_CMC...

BBH currently process Interest claims data in Merit. System went live in 2021 April.  Main IT contacts : john.minnock@bbh.com and chiranth.bymana@bbh.com IT manager : colin.ballantyne@bbh.com BBH P...

Barclays process both Dividend and Coupon claims.  Barclays Project Manager - Raghavendra Bagalkoti : raghavendra.bagalkoti@barclays.com IT – Kirtan Patel - kirtan.patel@barclays.com IT Escalation ...

Scenario: the payment is still not processed duplicate payment Anything related to payment, once the payment is initiated trhough, Claims → payment + settlement → Pay Items button click Refer for...