Support #10820

[SCP ID :##5363##] : Bulk Payment rpt file issue

Added by Zahir Abd Latif over 4 years ago. Updated almost 4 years ago.

Status:Work Completed-End life cycleStart date:June 02, 2020
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

90%

Category:-Spent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

1. No report dated 8 & 9 May for user M6048800.
2. No customer's old IC & code bank in the report in bulk payment rpt file.

Re FW Amendments in CDB.msg (218 KB) Zahir Abd Latif, June 02, 2020 15:02

rpt_bank code.jpg (311 KB) Nurul Athira Abdul Rahim, June 22, 2020 10:19

rpt_IC.jpg (309 KB) Nurul Athira Abdul Rahim, June 22, 2020 10:19

sgb - report.jpg (210 KB) Nurul Athira Abdul Rahim, June 25, 2020 10:16

ibg - report.jpg (211 KB) Nurul Athira Abdul Rahim, June 25, 2020 10:16

History

#1 Updated by Nurul Athira Abdul Rahim over 4 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Najmi Pasarudin over 4 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#3 Updated by Najmi Pasarudin over 4 years ago

  • Description updated (diff)

#4 Updated by Najmi Pasarudin over 4 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
  • % Done changed from 0 to 50

Issue 1:
No report dated 8 & 9 May for user M6048800.

Finding:
SPP batch job on 9 May did not run correctly. Fixes were made on the next day.
Also, no SPP raw file from ICBS were given with date 8 May.

Solution:
Copy SPP date D09052020
FROM: /batch/BSN/BatchFiles/OutgoingArc
TO: /batch/BSN/BatchFiles/ICBSReports/SPP

DB2 Script
select FILE_NAME,CREATION_DATE from DBO.BIB_SPP_REPORT
where FILE_NAME like '%SPP%09052020%';

update DBO.BIB_SPP_REPORT set CREATION_DATE='2020-05-09'
where FILE_NAME like '%SPP%09052020%';

#5 Updated by Najmi Pasarudin over 4 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#6 Updated by Najmi Pasarudin over 4 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
  • % Done changed from 50 to 90

Issue:
Bulk Payment RPT file has missing column and data for IBG file format.

Finding:
Bulk Payment RPT file only support column and data for non-IBG file format.

Solution:
Add column and data for non-IBG file format to Bulk Payment RPT file.

#7 Updated by Nurul Athira Abdul Rahim over 4 years ago

  • Status changed from Internal Testing to System Integration Test

#8 Updated by Nurul Athira Abdul Rahim over 4 years ago

  • Status changed from System Integration Test to User Acceptance Test
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

16/06/20- Tested and passed by Azyan

Kindly update the changes to UAT environment.

#9 Updated by Najmi Pasarudin over 4 years ago

  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Deployed to UAT on 17/06/2020

#10 Updated by Nurul Athira Abdul Rahim about 4 years ago

19/06/20

Reported by Mazni failed, but I do retesting on UAT the fixes is there and successful.

Asking JTM to liase with user on testing.

#11 Updated by Najmi Pasarudin about 4 years ago

  • Status changed from User Acceptance Test to Internal Testing

Requested by Mazni/Azyan, to change Header Code according to selected file format.
Deployed to SIT on 24/06/2020.

#12 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Status changed from Internal Testing to System Integration Test

Tested and passed on rpt header.

Change status to SIT

#14 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Status changed from System Integration Test to User Acceptance Test
  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

26/06/20 Tested and passed by Azyan on header issue

#15 Updated by Nurul Athira Abdul Rahim about 4 years ago

  • Status changed from User Acceptance Test to Pending Prod Deployment

Tested and passe by kak mazni

#16 Updated by Najmi Pasarudin about 4 years ago

  • Status changed from Pending Prod Deployment to Pending Review
  • Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Production deployed on 09/07/2020

#17 Updated by Nurul Athira Abdul Rahim almost 4 years ago

  • Status changed from Pending Review to Work Completed-End life cycle
  • Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif

Also available in: Atom PDF