Support #12873
[SCP ID :##6207##] : IBG Recovery - 18/03/2022
| Status: | Closed - End of life cycle | Start date: | March 19, 2022 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY IBG | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Kindly advise on IBG recovery for
OFI--> W4 & W5
RFI W3,W4 & W5
History
#1
Updated by Zahir Abd Latif over 2 years ago
- Status changed from New - Begin Life Cycle to Closed - End of life cycle
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Hafiz, Mar 21, 2022:-
Step to execute IBG RFI window 3,4 and 5 (18/03/2022)
RFI Window 3
1) execute RFI nacha (already execute 19/03/2022)
- To check inserted record
Select a.receive_trnx_id, a.creation_date, a.rfi_trace_no, a.originator_name, a.ofi_identification,
b.BANK_NAME, a.TO_ACCOUNT_NO, a.TO_ACCOUNT_NAME, a.AMOUNT, a.ORIGIN_TRACE_NO, a.STATUS, a.PAYMENT_DESCRIPTION,
a.PAYMENT_REFERENCE_NO, a.RETURN_CODE, a.RETURN_DESCRIPTION, a.TRANSACTION_CODE
From IBG_RFI a Inner Join IBG_ROUTE_BANK b On b.ROUTE_NO = a.OFI_IDENTIFICATION
Inner Join IBG_NACHA_MASTER c ON c.MASTER_ID = a.MASTER_ID
Where a.creation_date between to_date('19032022', 'ddmmyyyy') and to_date('20032022', 'ddmmyyyy')
And c.window = '3' order by to_number(a.receive_trnx_id) asc;
2) Execute crediting. use 19032022 as date
- To check Crediting
select rfi.rfi_trace_no, rfi.transaction_code, rfi.to_account_no, rfi.to_account_name, rfi.amount,
rfi.ofi_identification, credit.credit_status, rfi.originator_name, credit.trnx_id, rfi.segment_code, credit.reject_return_code
from ibg_rfi rfi inner join ibg_credit credit on rfi.receive_trnx_id = credit.receive_trnx_id and
credit.credit_status in ('F','S','CE') and rfi.creation_date between to_date('19032022', 'ddmmyyyy') and to_date('19032022', 'ddmmyyyy')
and credit.credit_window='3' order by credit.credit_status asc, rfi.receive_trnx_id asc
RFI Window 4 (18/03/2022) - Please backup all today nacha and report file
1) execute RFI nacha
- To check inserted record
Select a.receive_trnx_id, a.creation_date, a.rfi_trace_no, a.originator_name, a.ofi_identification,
b.BANK_NAME, a.TO_ACCOUNT_NO, a.TO_ACCOUNT_NAME, a.AMOUNT, a.ORIGIN_TRACE_NO, a.STATUS, a.PAYMENT_DESCRIPTION,
a.PAYMENT_REFERENCE_NO, a.RETURN_CODE, a.RETURN_DESCRIPTION, a.TRANSACTION_CODE
From IBG_RFI a Inner Join IBG_ROUTE_BANK b On b.ROUTE_NO = a.OFI_IDENTIFICATION
Inner Join IBG_NACHA_MASTER c ON c.MASTER_ID = a.MASTER_ID
Where a.creation_date between to_date('21032022', 'ddmmyyyy') and to_date('22032022', 'ddmmyyyy')
And c.window = '4' order by to_number(a.receive_trnx_id) asc;
2) will credit with next RFI Creding
RFI Window 5 (18/03/2022) - Please backup all today nacha and report file
1) execute RFI nacha
- To check inserted record
Select a.receive_trnx_id, a.creation_date, a.rfi_trace_no, a.originator_name, a.ofi_identification,
b.BANK_NAME, a.TO_ACCOUNT_NO, a.TO_ACCOUNT_NAME, a.AMOUNT, a.ORIGIN_TRACE_NO, a.STATUS, a.PAYMENT_DESCRIPTION,
a.PAYMENT_REFERENCE_NO, a.RETURN_CODE, a.RETURN_DESCRIPTION, a.TRANSACTION_CODE
From IBG_RFI a Inner Join IBG_ROUTE_BANK b On b.ROUTE_NO = a.OFI_IDENTIFICATION
Inner Join IBG_NACHA_MASTER c ON c.MASTER_ID = a.MASTER_ID
Where a.creation_date between to_date('21032022', 'ddmmyyyy') and to_date('22032022', 'ddmmyyyy')
And c.window = '5' order by to_number(a.receive_trnx_id) asc;
2) Will credit with next RFI Creding
Recon window 3,4,5 (18/03/2022)
1) execute Recon file
Adhamudin, Mar 21, 2022 :-
RFI Crediting W3 (21032022) completed.
Issue closed in SCP.