...
Problem:
Client facing the issue that insurer’s address is removed from saved (but un-finalized) certificates whenever a change to an insurer’s address is made.
Solution:See DOS 2419 for an appropriate solution
User complaining about insurer’s address is removed from saved (but un-finalized) certificates.
This is more of user training issue.
User blank out, insurer's and owner's name and addresses instead of deleting them.
Search for the Wreck Certificates and found many certificates where insurer's address were blank.
Looked into the database, in the TY002_PARTY and TY001_ADDRESS table some addresses are blank. But TY002_INSURER_CD and TY001_INSURER_ADDRESS_CD fields related to those blank addresses were there in UM001_Cerificate_Issued.
So went to the user in person, search specific insurer's address in the database and update the specific address which populate all the records for the in-progress certificates.
Train the user about how to delete the addresses and not blank out them.