Change #4251
SCP ID # 2118 : EDW report from M2U
| Status: | Closed - End of life cycle | Start date: | March 25, 2014 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | June 18, 2014 | |
| Assignee: | % Done: | 100% | ||
| Category: | - | Spent time: | 7.00 hours | |
| Target version: | - |
Description
1. Incorrect padding character X in the last field. This problem found in these file:
a. M2UTHRDPRTYTX
b. M2UCUSTPROF
c. M2UTELEGRAPH
d. M2UBILLPYMT
e. M2UREMITTANCE
f. M2UTMDP
g. M2UOWNACCTX
h. M2UADMINPROF
For field Host_IP_ADDR It should be :
2. No data in these file:
a. M2UMOBILERLD
b. M2UINTERBANKTX
3. file M2UEDWSTAT over 1 character, it should be 160 char not 161 char (remove space in the last field)
History
#1
Updated by William Gozali Tan over 10 years ago
- Assignee set to Rayvandy Gabbytian
#2
Updated by Rayvandy Gabbytian over 10 years ago
- Due date set to March 26, 2014
- Assignee changed from Rayvandy Gabbytian to Ngoh Chee Ping
Chee Ping,
Kindly assist to look into this EDW report as well:
Additonal note for item 2a.:
Everyday when program tries to generate mobile reload report, let say after 100 records being written, the record 101th only contains half (sometimes it stopped after writing mobile number, etc). Then the next record would not be generated.
#3
Updated by Ngoh Chee Ping over 10 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 60
Fixed issue no 1.
For issue no 2, M2UINTERBANKTX and M2UMOBILERLD should have records, need to confirm with bank. I suspect on their side do not have records in database.
For issue no 3, M2UEDWSTAT is 160 char, not like what they reported 161 char. Need confirm with bank.
#4
Updated by Ngoh Chee Ping over 10 years ago
- Assignee changed from Ngoh Chee Ping to Rayvandy Gabbytian
Assign back to Gabby to confirm the issue no 2 and no 3.
#5
Updated by Ngoh Chee Ping over 10 years ago
For issue 1 should consider as CR, because in the technical doc written as below.
8. Each record ends with 'X' sign
#6
Updated by Norhaidah Md Dasuki over 10 years ago
- Tracker changed from Support to Change
#7
Updated by Rayvandy Gabbytian over 10 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
Item 2a & 2b are pending for customer feedback (log). Wahyu will provide.
#8
Updated by Rayvandy Gabbytian over 10 years ago
- Due date changed from March 26, 2014 to June 16, 2014
- Status changed from Pending Customer Feedback to Development / Work In Progress
- % Done changed from 60 to 100
Changes that we have delivered on 16th June 2014 (based on request by Pak Wahyu & EDW team) :
1. Remove non financial activity to EDW Statistic
2. Bill Payment Report:
- Order the column (“From Currency Code”) inside document to match with the EDW report,
- Change the field length of Status from 24 to 25.
3. Statistic Report:
- Remove “Number of Click” Activity as they are not required to display in statistic.
4. Interbank Online Report:
- Change the field length of Status from 24 to 25.
5. Mobile Reload Report:
- Change the field length of Status from 24 to 25.
6. Own Account Transfer Report:
- Change the field length of Status from 24 to 25.
7. Remittance/ Western Union Transaction Report:
- Change the field length of Status from 24 to 25.
8. Telegraphic Transfer Report (SKN, RTGS, and FCR):
- Add field Telegraphic Type to differentiate between Valas, SKN, or RTGS,
- Change the field length of Beneficiary Bank Name from 70 to 255.
- Change the field length of To Acc No from 25 to 50.
9. Third Party Transfer Report :
- Change the field length of Status from 24 to 25.
10. Time Deposit Report :
- Change the field length of Status from 24 to 25.
11. Add Admin Profile Report
12. Add Customer Profile Report
13. Add Customer Activity Report
#9
Updated by Rayvandy Gabbytian over 10 years ago
- File BII M2U EDW Format v1.3.docx added
Attach is the updated EDW Report format.
#10
Updated by Rayvandy Gabbytian over 10 years ago
- File bii-edw-report.zip added
Attach is the result of EDW report based on SIT data.
#11
Updated by Rayvandy Gabbytian over 10 years ago
- Due date changed from June 16, 2014 to June 18, 2014
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Rayvandy Gabbytian to Saputra Febhy Toomy
- % Done changed from 100 to 0
Dear Toomy,
Kindly assist to perform testing for EDW report result. Things / area to test:
1. To grab all the data. You can customize the date range in app config.
2. Compare the result vs. the spec inside BII M2U EDW Format v1.3.docx document (as attached above). By comparing, it means that:
- make sure the length of particular field match with the doc,
- to see possible null, empty data,
- make sure all the data are shown properly, no field is too long (exceed the length of field mentioned in document)
- no report is cut (stop generating in the middle, just like the issue reported by Pak Wahyu)
3. Make sure that the log is generated properly (bii-edw-report.log)
#12
Updated by Rayvandy Gabbytian over 10 years ago
Dear Toomy,
Kindly update on the result and let me know if there is any issue on the report length.
Thanks.
#13
Updated by Rayvandy Gabbytian over 10 years ago
- File bii-edw-report.zip added
Dear Toomy,
There was update on TELEGRAPHIC report. Kindly download the file attached.
#14
Updated by Saputra Febhy Toomy over 10 years ago
- File BII RIB SIT Test Script 23th June 2014.doc added
- Assignee changed from Saputra Febhy Toomy to Rayvandy Gabbytian
- % Done changed from 0 to 100
Dear Gabby,
This is the latest result test script include EDW Report (file attach). I already combine all test script in one word document.
Thanks
#15
Updated by Zahir Abd Latif about 10 years ago
Dear Gabbytian,
What the status on this case? please help to follow up with to see we closed this case or update
the status.
#16
Updated by Zahir Abd Latif almost 10 years ago
- Status changed from Internal Testing to Closed - End of life cycle