Task #5704

IBSCR078 - FTT and RENTAS Store Procedures

Added by Lizahwati Basirun almost 9 years ago. Updated about 4 years ago.

Status:Work Completed-End life cycleStart date:November 19, 2015
Priority:NormalDue 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

Store Procedures.zip (4.9 KB) Lizahwati Basirun, November 19, 2015 18:48

bib.sql (6.36 KB) Hafizudin MD, November 23, 2015 09:52

bibl.sql (1.43 KB) Hafizudin MD, November 23, 2015 09:52

cib.sql (2.51 KB) Hafizudin MD, November 23, 2015 09:52

History

#1 Updated by Lizahwati Basirun almost 9 years ago

Dear Hafiz,

Kindly assist to test as per Kahyan's email. Thank you.

#2 Updated by Hafizudin MD almost 9 years ago

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

Also available in: Atom PDF