Support #13118

[SCP ID :##6366##] : iGFMAS Second Validation

Added by Zahir Abd Latif about 2 years ago. Updated 29 days ago.

Status:Closed - End of life cycleStart date:July 25, 2022
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:System EnhancementSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

CDB required to do second validation to iGFMAS data file (HR512).
There will be no changes on the HR512 file.

Validate B2B Bulk Payment file with web service SA1IK001. If error W33, set sub code 9999.

JANM_1.JPG (58.2 KB) Zahir Abd Latif, July 25, 2022 16:02

JANM_2.JPG (74 KB) Zahir Abd Latif, July 25, 2022 16:02

unnamed.jpg - B2B setup (18.4 KB) Najmi Pasarudin, August 15, 2022 09:12

result1.png (17.1 KB) Najmi Pasarudin, August 25, 2022 15:07

History

#1 Updated by Nurul Athira Abdul Rahim about 2 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Najmi Pasarudin about 2 years ago

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

#3 Updated by Najmi Pasarudin about 2 years ago

  • Status changed from Development / Work In Progress to Pending Customer Feedback

28/07/2022: Najmi requested sample of B2B setup for iGFMAS. No reply yet.

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

  • Category set to System Enhancement

#5 Updated by Najmi Pasarudin about 2 years ago

  • File unnamed.jpg added
  • Status changed from Pending Customer Feedback to Development / Work In Progress

#6 Updated by Najmi Pasarudin about 2 years ago

  • % Done changed from 0 to 50

#7 Updated by Najmi Pasarudin about 2 years ago

Reply from Asrul

Salam Najmi,

Refer green colour font for the reply.

1. Is the validation based on BSN account and IC number?

-Yes

2. Is the validation only for the HR512 file only?

-Yes, currently only for HR512 file only

3. Do I only reject the invalid file lines only?

-Yes, rejection indicator will be indicate at SubCode(64-67) column in bulk payment file to ICBS with value 9999

4. Is there any other requirement?

-Use service SA1IK001 to validate the account no and IC

#8 Updated by Najmi Pasarudin about 2 years ago

  • % Done changed from 50 to 90

#9 Updated by Najmi Pasarudin about 2 years ago

  • Status changed from Development / Work In Progress to Pending SIT Deployment

#10 Updated by Najmi Pasarudin about 2 years ago

  • Status changed from Pending SIT Deployment to Finished Development

#11 Updated by Najmi Pasarudin about 2 years ago

  • Status changed from Finished Development to Internal Testing

#12 Updated by Najmi Pasarudin about 2 years ago

#13 Updated by Najmi Pasarudin about 2 years ago

Issue:
BSN request to add account and IC validation for HR512 B2B bulk payment file

Solution:
Update batch program to validate HR512 B2B bulk payment file.
Invalid account and IC will have sub code 9999. Refer result1.png

Test steps:
  1. Testing need to be done by JTM BSN
  2. Configure B2B setup via IBAM>CBE>Org Setup>Company>B2B setup
  3. Set filename search value to HR512
  4. Prepare HR512 bulk payment file and copy to B2B directory. Either FTP or Batch server.
  5. Make sure file contain valid and invalid account/IC
  6. Once batch program pickup HR512, access IBAM>File Processing>Details
  7. Expected result, for invalid account/IC, the sub code is 9999. Refer result1.png
  8. Submit EOD and send EOD file to ICBS for testing.
  9. ICBS should provide SPP report for sub code 9999 status.
  10. Expected result, sub code 9999 status should be failed.

#14 Updated by Najmi Pasarudin about 2 years ago

  • Assignee changed from Najmi Pasarudin to Binti Marobi Athirah Umairah

#15 Updated by Binti Marobi Athirah Umairah about 2 years ago

  • Status changed from Internal Testing to System Integration Test
  • Assignee changed from Binti Marobi Athirah Umairah to Nurul Athira Abdul Rahim

#16 Updated by Najmi Pasarudin about 2 years ago

  • Description updated (diff)

Email from Asrul on 15/09/2022

Salam En Najmi,

Regarding CDB iGFMAS 2nd validation change, we will maintain to use SA1IK001 service.
And update the sub code value with ‘9999’ only if received W33. Other than that, please send null value at the sub code field.
ICBS will reject if the account is invalid, closed or dormant and respond with valid rejection in SPP400 report.

Thank you

#17 Updated by Najmi Pasarudin about 2 years ago

  • Description updated (diff)

#18 Updated by Binti Marobi Athirah Umairah almost 2 years ago

  • Status changed from System Integration Test to User Acceptance Test

Tested and passed by Asrul on 11/11/22

#19 Updated by Binti Marobi Athirah Umairah 8 months ago

  • Status changed from User Acceptance Test to Pending Prod Deployment

17/1/24 [Aznil] - Proceed to Pending Deployment

#20 Updated by Najmi Pasarudin about 1 month ago

Deployment steps:
  1. Access Batch server
  2. Update MainProgram.jar
  3. Copy AGValidation.sh to BatchJobs folder
  4. Update settings.properties, add parameter b2b.ag.validation.search.name=HR512
  5. Test AGValidation.sh by executing the AGValidation.sh file
  6. If runs successfully, set crontab using command crontab -e
  7. Verify the crontab is running
  8. Example for every minute between 6pm to 10pm, refer below
  9. * 18-21 * * * /home/cdbadmin/solo -port=2021 /batch/BSN/BatchJobs/AGValidation.sh

#21 Updated by Binti Marobi Athirah Umairah about 1 month ago

  • Status changed from Pending Prod Deployment to Pending Review

Deployed to prod on 13/8/24 (ID0086).

#22 Updated by Binti Marobi Athirah Umairah about 1 month ago

  • Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif

#23 Updated by Zahir Abd Latif 29 days ago

  • Status changed from Pending Review to Closed - End of life cycle
  • % Done changed from 90 to 100

Issue closed in SCP.

Also available in: Atom PDF