Support #4226
[SCP ID :##2083##] : Corus CMS Registration Error
Status: | Work Completed-End life cycle | Start date: | March 19, 2014 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Nor Shuhaida Subri | % Done: | 0% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Please refer attached doc for details
History
#1 Updated by Nor Shuhaida Subri over 10 years ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
This cause by the data issue in database.
Suppose when user approve the transaction in corus.
Application will delete the data in the temporary table.
Its manage to delete the data inside the MK_ACCOUNT table
But not in MK_TRNX_MASTER
Our iterim solution is to manually delete the data from MK_TRNX_MASTER
Here's the script to implement under BIB schema production:-
select * from MK_TRNX_MASTER where mk_id='20140311030487';
delete from MK_TRNX_MASTER where mk_id='20140311030487';
commit;
No server restart required for this action.
To test the application.
User may edit the company account in corus
And then approve the transaction
DBA Reply (Tahir)
Execution DONE , Kindly verify
before execute
MK_ID RIM_NO DESCRIPTION
20140311030487 75663 Sara Nadeea Rahim has edited current account of company ZETRO SERVICES SDN BHD
after execute
1 rows deleted
MK_ID RIM_NO DESCRIPTION
---------------- ---------------- -----------
User Reply (Chooi)
Just tested and we managed to edit and approve the pending item in Corus for this particular company now.
Please assist to close case HD00014955.