Support #4027

[Real SCP ID 1761] SCP ID# 1773 : Unable to create corporate ID

Added by William Gozali Tan almost 11 years ago. Updated over 10 years ago.

Status:Closed - End of life cycleStart date:December 18, 2013
Priority:NormalDue date:
Assignee:Avatar?id=1733&size=14Ahmad 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 Avatar?id=1733&size=24 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 Avatar?id=1733&size=24 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

Also available in: Atom PDF