Support #4637
[SCP ID :##2360##] : Wrong CORP id Created
| Status: | Closed - End of life cycle | Start date: | August 18, 2014 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  William Gozali Tan | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Kindly attend to issue below:
Kindly help to provide stub to change Corp Id from MYMYHHOLDS to MYHHOLDS.
From our checking MYHHOLDS corp id was created earlier in RCAS database. Kinldy help to check whether this Corp Id valid.
History
#1
Updated by Yap Kah Yan about 10 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Yap Kah Yan to William Gozali Tan
Root Cause: Bank created 3 ids, MYMYHHOLDS, MYHHOLDS and MYHHOLD.
In DB, all 3 corporate id was created but the only 2 CIF number mapping was created.
This happens because the code first checked for corporate id in DB, if not exists, create.
Then will check for CIF number in DB, if not exists, create.
Fix: to rename all 3 corp ids and CIF number to dummy for bank to recreate the company.
update prl_party set name = 'dummyMYMYHHOLDS' where name = 'MYMYHHOLDS';
update tb_am_company set company_id = 'dummy020409826' where company_id = '020409826';
update prl_party set name = 'dummyMYHHOLDS' where name = 'MYHHOLDS';
update prl_party set name = 'dummyMYHHOLD' where name = 'MYHHOLD';
update tb_am_company set company_id = 'dummy020409829' where company_id = '020409829';
commit;
#2
Updated by Zahir Abd Latif almost 10 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
Refer email : Re: [Request ID :##2360##] : Wrong CORP id Created
No response from customer within 3 days, closed.