Call API to create new customer e-mail at party site level but error contact_point_id must be uniqu.
I want to create new e-mail at party site level. I call API hz_contact_point_v2pub.create_email_contact_point but got error that "Value for contact_point_id must be unique."
l_contact_point_rec.contact_point_type := 'EMAIL';
l_contact_point_rec.owner_table_name := 'HZ_PARTY_SITES';
l_contact_point_rec.status := 'A';
l_contact_point_rec.owner_table_id := l_owner_table_id;
l_contact_point_rec.primary_flag := 'Y';
l_contact_point_rec.content_source_type := 'USER_ENTERED';
l_contact_point_rec.contact_point_purpose := 'INVOICE';
l_contact_point_rec.primary_by_purpose := 'N';