Task #5704
IBSCR078 - FTT and RENTAS Store Procedures
Status: | Work Completed-End life cycle | Start date: | November 19, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Lizahwati Basirun | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Change Request:
To provide Store Procedure to retrieve list of transactions and to update the status for FTT and RENTAS transactions
Scope of works:
1. Get based on status
2. Update user trnx history + company trnx history + si history
3. For si check to get from date = today
History
#1 Updated by Lizahwati Basirun almost 9 years ago
- File Store Procedures.zip added
Dear Hafiz,
Kindly assist to test as per Kahyan's email. Thank you.
#2 Updated by Hafizudin MD almost 9 years ago
- File bib.sql added
- File bibl.sql added
- File cib.sql added
- Assignee changed from Hafizudin MD to Yap Kah Yan
fix and tested.
kah yan please check gain
#3 Updated by Hafizudin MD almost 9 years ago
- File Task#5704 - FTT and RENTAS Store Procedures.docx added
add test script
#4 Updated by Yap Kah Yan almost 9 years ago
- Assignee changed from Yap Kah Yan to Hafizudin MD
Dear Hafiz,
1. Which one do you want to use?
I see 2 types of trunc date. Can standardize for all?
and trunc(si.TRNX_DATE) = trunc(sysdate);
and trunc(rtg.TRNX_DATE) = to_date(sysdate, 'YYYY-MM-DD');
2. I don't think we need to include the test query for them.
If you tested ok at your side, just release.
Thank you.
#5 Updated by Hafizudin MD almost 9 years ago
- Assignee changed from Hafizudin MD to Yap Kah Yan
both.. i change that because sql throw error
#6 Updated by Yap Kah Yan almost 9 years ago
- Assignee changed from Yap Kah Yan to Hafizudin MD
Dear Hafiz,
I just read the test result document.
Have you fix the part Error: Check compiler log ?
If already fix, please update the screenshots and release to bank.
Thank you.
#7 Updated by Hafizudin MD almost 9 years ago
- File deleted (
Task#5704 - FTT and RENTAS Store Procedures.docx)
#8 Updated by Hafizudin MD over 8 years ago
- Assignee changed from Hafizudin MD to Lizahwati Basirun
#9 Updated by Lizahwati Basirun over 8 years ago
- Status changed from Internal Testing to User Acceptance Test
#10 Updated by Lizahwati Basirun over 6 years ago
- Status changed from User Acceptance Test to Pending Prod Deployment
Migrated to Production on 2nd Nov 2017 but only for RENTAS
#11 Updated by Lizahwati Basirun about 4 years ago
- Status changed from Pending Prod Deployment to Work Completed-End life cycle
- % Done changed from 90 to 100