Support #7940
SCP ID :##4166##] : UNLOCK CA doesn't appeared in BIB Authorization
Status: | Closed - End of life cycle | Start date: | October 09, 2017 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | IBAM | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:
UNLOCK CA doesn't appeared in BIB Authorization. Please check.
History
#1 Updated by Yap Kah Yan almost 7 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
Provided script as below:
select * from ADMIN_PERMISSION where ACTION_ID = '2046' and user_id = (select user_id from ib_user where user_alias = '<user_alias>');
Please replace values of <user_alias>
Check if the changes is in DB and not showing on screen
select * from MK_TRNX_MASTER where DESCRIPTION like '%pgbyram%';
Update pending flag for bib user
update bib_user set MK_PENDING = '0' where USER_ALIAS = 'pgbyram';
Pending user feedback if able to unlock CA
Root Cause:
No data in MK_TRNX_MASTER, but MK_PENDING flag is 1 (pending) in BIB_USER
Due to no data in MK_TRNX_MASTER, IBAM did not display
Solution:
Update MK_PENDING flag to 0 (not pending) in BIB_USER
#2 Updated by Zahir Abd Latif almost 7 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
- % Done changed from 0 to 100
Issue closed in SCP.