Task #394

BCA-DDA-UAT-C006

Added by Chang Grace about 14 years ago. Updated almost 14 years ago.

Status:Closed - End of life cycleStart date:August 16, 2010
Priority:NormalDue date:August 25, 2010
Assignee:Siti Norahayu Mohd Desa % Done:

100%

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

Description

IB Ref # 5530 Accepted but not reflected in Application Enquiry screen.

Issue_Log_-_BCA-DDA-UAT-C006_-_BC_accepted_not_reflect_in_enquiry.doc (423 KB) Chang Grace, August 16, 2010 17:13

History

#1 Updated by Chang Grace about 14 years ago

  • Due date set to August 18, 2010
  • Assignee set to Siti Norahayu Mohd Desa

Currently is using SQL below to retrieve remittance application enquiry:

SELECT DISTINCT TBL_A.TRNX_ID, TBL_A.CREATION_DATE, TBL_A.TRNX_TYPE, TBL_A.FROM_ACCOUNT_NO, TBL_A.FROM_CURRENCY, TBL_A.AMOUNT, TBL_A.STATUS FROM IB_TRANSACTION_HISTORY TBL_A, IB_BANKERS_CHEQUE TBL_B, IB_DEMAND_DRAFT TBL_C WHERE TBL_A.USER_ID = 382 AND (TBL_A.TRNX_ID = TBL_B.TRNX_ID OR TBL_A.TRNX_ID = TBL_C.TRNX_ID) AND trunc(TBL_A.CREATION_DATE) > trunc(sysdate - 30)

There is 1 record in IB_BANKERS_CHEQUE table, but no records returned.
Please fix it.

#2 Updated by Chang Grace about 14 years ago

what is the status? Due date suppose is last Wednesday (18/08/2010).

#3 Updated by Chang Grace about 14 years ago

  • Due date changed from August 18, 2010 to August 25, 2010

#4 Updated by Siti Norahayu Mohd Desa about 14 years ago

  • Status changed from New - Begin Life Cycle to Work Completed-End life cycle
  • % Done changed from 0 to 100

Fixed the application enquiry records. data will appear even one of the table is empty

#5 Updated by Latipah Abdul Rashid almost 14 years ago

  • Status changed from Work Completed-End life cycle to Closed - End of life cycle

Issue closed by Chooi So Fun on 30.08.10

Also available in: Atom PDF