Support #7382
[SCP ID :##3789##] : ZS Armin Sdn Bhd Approver Unable to view Account and Banking
| Status: | Closed - End of life cycle | Start date: | April 11, 2017 | |
|---|---|---|---|---|
| Priority: | High | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | BIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
Kindly need your assistance to check on this issue, Approver unable to view account and banking. When vb want to allow account and banking services to the approver, error showed "ERROR WHILE PERFORMING YOUR REQUEST"
Below are the user detail:
User ID:
2625
?
Username:
approver02
?
Full Name:
NURFITRI LIYANA BT SHAMSHUDIN
?
Tel No:
0389432923
?
Office Ext. No:
?
?
Mobile No:
60135971245
?
ID No:
900504146008
?
Address:
NO.23,JALAN BS7/1B, KAWASAN
PERINDUSTRIAN BUKIT SERDANG,
?
City:
Sri Kembangan
?
State:
Selangor
?
Postcode:
43300
?
Email Address:
nurfitriliyana@zsarmin.com
?
Role:
Approver
?
Approver Group :
A
?
User Status:
ACTIVE
?
FTL Completed:
Yes
?
Updated By:
?
?
Updated Date:
?
?
SMS Sent By:
?
?
SMS Sent Date:
-
? ? ?
?
History
#1
Updated by Yap Kah Yan over 7 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
This issue is related to [Request ID :##3177##] : VB CHECKER UNABLE TO APPROVED CREATE BIB USER
Found that there is duplicate account number in the database, will need to do data patching and delete 1 of the duplicate account numbers.
select script:
select company_name FROM BIB_COMPANY where company_id in (select COMPANY_ID from BIB_ACCOUNT where ACCOUNT_NO in (
select ACCOUNT_NO from BIB_ACCOUNT
group by ACCOUNT_NO
having count (ACCOUNT_NO) > 1
));
select ACCOUNT_NO from BIB_ACCOUNT
group by ACCOUNT_NO
having count (ACCOUNT_NO) > 1;
delete script
delete from BIB_ACCOUNT where oid in ('<acc_oid>');
replace <acc_oid> with oid of account to be deleted.
#2
Updated by Zahir Abd Latif over 7 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
Issue closed in SCP.