Support #4211

Avatar?id=2607&size=50

[Request ID :##2183##] : BII-RIB: SKN/RTGS: To Properly Sort The Bank List

Added by Rayvandy Gabbytian over 10 years ago. Updated almost 10 years ago.

Status:Closed - End of life cycleStart date:March 16, 2014
Priority:NormalDue date:March 16, 2014
Assignee:Avatar?id=2607&size=14Rayvandy Gabbytian % Done:

100%

Category:-Spent time:3.50 hours
Target version:-

Description

Reported by Pak Thomas/Bu Made that the bank list is not sorted properly. Report as attached.

FW M2U input on bank.pdf (311 KB) Rayvandy Gabbytian , March 13, 2014 17:52

4211 - Alter SKN_TOP_TEN inside IB_BANCNET_LIST from VARCHAR to DECIMAL.txt Magnifier (392 Bytes) Rayvandy Gabbytian , April 16, 2014 19:19

History

#1 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 10 years ago

  • Status changed from New - Begin Life Cycle to System Integration Test

#2 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 10 years ago

  • Due date set to March 13, 2014

#3 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 10 years ago

  • Due date changed from March 13, 2014 to March 16, 2014
  • Status changed from System Integration Test to Development / Work In Progress
  • Start date changed from March 13, 2014 to March 16, 2014
  • % Done changed from 0 to 100

Case re-opened based on report by Pak Wahyu via phone today:

Problem:
Bank list still not "naturally" sorted

Root cause:
System stores the sorting number based on varchar (string) not numeric (decimal)

Solution:
Change the sknTopTen inside DBO.IB_BANCNET_LIST to decimal with 3 digit length.

This changes affect:
- ibsscore
- bii-rib
- bii-admin

#4 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 10 years ago

  • Status changed from Development / Work In Progress to System Integration Test
  • % Done changed from 100 to 0

#5 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 10 years ago

This change also affect database. SQL script is as per attached.

#6 Avatar?id=1733&size=24 Updated by Ahmad Hazri over 10 years ago

  • Subject changed from BII-RIB: SKN/RTGS: To Properly Sort The Bank List to [Request ID :##2183##] : BII-RIB: SKN/RTGS: To Properly Sort The Bank List

#7 Avatar?id=1733&size=24 Updated by Ahmad Hazri over 10 years ago

  • Tracker changed from Task to Support

#8 Updated by Zahir Abd Latif about 10 years ago

Dear Gabbytian,

Any updates on this case? please help to follow up with to see we closed this case or update the status.

Thanks.

#9 Updated by Zahir Abd Latif almost 10 years ago

  • Status changed from System Integration Test to Closed - End of life cycle
  • % Done changed from 0 to 100

Also available in: Atom PDF