Support #4027
[Real SCP ID 1761] SCP ID# 1773 : Unable to create corporate ID
Status: | Closed - End of life cycle | Start date: | December 18, 2013 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Ahmad Hazri | % Done: | 0% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Kindly help assist issue below.
There are 2 corporate ID involve for this issue and our BBO cannot continue to on board the customer in RCMS due to the error .Boths ID has been deleted in RCAS by BBO.
BBO need tu reused back CIF no to new Org ID.
Kindly provide the SQL to patch.
History
#1 Updated by Ahmad Hazri almost 11 years ago
- Subject changed from SCP ID# 1773 : Unable to create corporate ID to [Real SCP ID 1761] SCP ID# 1773 : Unable to create corporate ID
#2 Updated by Yap Kah Yan almost 11 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#3 Updated by Yap Kah Yan almost 11 years ago
- Status changed from Development / Work In Progress to Finished Development
Run the query:
To get the data:
select * from PRL_PARTY where ROW_ID in (select ROW_ID from TB_AM_COMPANY where COMPANY_ID in('020957196', '021273119') )
Update Company Name:
update PRL_PARTY set NAME = concat(NAME, '-D19122013') where ROW_ID in (select ROW_ID from TB_AM_COMPANY where COMPANY_ID in('020957196', '021273119') )
Update Company ID:
update TB_AM_COMPANY set COMPANY_ID = concat(COMPANY_ID, '-D19122013') where COMPANY_ID in('020957196', '021273119')
#4 Updated by Yap Kah Yan almost 11 years ago
Had tried to update the DB with following queries
application still do not allow user to recreate the companies.
For quick fix, directly updated the DB with the correct data.
Pending for source code compare.
#5 Updated by Yap Kah Yan almost 11 years ago
Already compare with the source code. No issue.
Pending for Maybank to restart the server and retest
#6 Updated by Yap Kah Yan over 10 years ago
- Assignee changed from Yap Kah Yan to Hartanto Boby
#7 Updated by Hartanto Boby over 10 years ago
- Assignee changed from Hartanto Boby to Ahmad Hazri
Pending customer feedback
#8 Updated by Ahmad Hazri over 10 years ago
- Status changed from Finished Development to Pending Prod Deployment
- Assignee changed from Ahmad Hazri to Hartanto Boby
#9 Updated by Hartanto Boby over 10 years ago
- Status changed from Pending Prod Deployment to Closed - End of life cycle
- Assignee changed from Hartanto Boby to Ahmad Hazri
script provided