Manikanta Vusakoyila

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...

M:\temp\rgeorge\documents\Barclay_ICM_payment message.xlsx Daily imp Stage Stage desc Depends on Custom Function/Import rule Scope/Activity Details. How/Where to check MSGS 100 Housekeeping   ...

ICM Auto pay – how to implement How to  Refer Manual :   M:\WWW\Manual_reviewed\P_550_Payment_and_Settlement\P100_Adding_Payment_and_Settlement\P980_Adding_Auto_Payment\P980_Adding_Auto_Payment.htm...