Support #13117

[SCP ID :##6365##] : Company Records failed to Upload and Core Banking Real Time inquiry didn;t populate correctly.

Added by Zahir Abd Latif about 2 years ago. Updated 8 months ago.

Status:Work Completed-End life cycleStart date:July 22, 2022
Priority:HighDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:-Spent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

1) Company record issue in the logs

2) Core Banking Screenshot

ecustody-production-fix-2022-07-27.zip (5.7 KB) Siti Nursyahira Suhaimi, August 03, 2022 10:06

History

#1 Updated by Tan Lee Yong about 2 years ago

  • Assignee changed from Najmi Pasarudin to Siti Nursyahira Suhaimi

Yaya, please try to look into this issue

#2 Updated by Siti Nursyahira Suhaimi about 2 years ago

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

#3 Updated by Siti Nursyahira Suhaimi about 2 years ago

  • Status changed from Development / Work In Progress to Finished Development
  • % Done changed from 0 to 90

1) Company record

Root Cause:
On CUSTODY.STOCK_COMPANY table we found a unique constraint on the COUNTER column.
First 20 characters each line that will be used as COUNTER column, but those first 20 characters have been detected BLANK and Duplicates on certain lines.

Findings:
Based on, company.txt file that attempt to upload, I found 37 BLANK and 1 Duplicate data on the first 20 characters on the COUNTER column.

These are the lines of the data that you can refer to:
BLANK - 4011,4048,4049,4084,4110,4123,4125,4127,4129,4156,4157,4164,4168,4184,4214,4216,4217,4230,4274,
4278,4279,4315,4338,4363,4481,4483,4506,4539,4878,5299,5705,5855,5941,5964,6118,8202,8203.

Duplicates - 9596,14190

image.png

2) Core Banking

Root Cause:
The host response code should return a 3 digit value in form 001 - 025 for Source Code and 001 - 006 for Post Status
But based on log, the host returns blank.

Findings:
Refer to custody_1.out log provided, on line 260271, the <SrCode> and <PostStat>, the response values are empty and '...' value.

#4 Updated by Siti Nursyahira Suhaimi about 2 years ago

Patch adding condition, if null or empty the whole row is not to be displayed.

#5 Updated by Najmi Pasarudin 8 months ago

  • Status changed from Finished Development to Development / Work In Progress

#6 Updated by Najmi Pasarudin 8 months ago

  • Status changed from Development / Work In Progress to Work Completed-End life cycle
  • Assignee changed from Siti Nursyahira Suhaimi to Zahir Abd Latif

Patch given to client. Last email on 27/7/2023 titled : Company Records failed to Upload and Core Banking Real Time inquiry didn;t populate correctly.

Also available in: Atom PDF