My Oracle Support Banner

Create Organization Contact Gets Message Column Relationship_Type Must Have A Value For Certain Steps Only (Doc ID 1473815.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Customer Care - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Contact Center

When attempting to create a customer and a contact in Contact Center but the customer is created using a customer type different than the one in the Contact Center header, the customer is created without error but the contact creation fails with the following errors:

Error

Column relationship_type must have a value.

Click "Ok" button and another error is displayed:

Column address1 must have a value.

After click ok the contact is not saved.

Steps to Reproduce

1. Open Contact Center form and customer type is defaulted to Person.
2. Click "Create Cust" button.
3. In the Create Customer form the "Type" is defaulted as Person.
4. Change that to "Organization".
5. Enter all the mandatory info and save. The new organization is created and populated back in Contact Center.
6. In Contact Center header click "Create Contact" button.
7. Create Contact form pop-up with the Customer Info section completed with the info from the organization that was just created.
8. In the Contact Info region the Relation field is autocompleted as Employee Of. The Address Usage, Country and Address fields are completed with the organization info which is correct.
9. Enter first, last name and click save. The following error is displayed:

Column relationship_type must have a value.

10. Click "Ok" button and another error is displayed:

      Column address1 must have a value.

11. After click ok the contact is not saved.

12. If above steps are repeated, except that in Contact Center form you choose Type ORGANIZATION right away before clicking "Create Cust" button, the error messages doesn't occur and the contact is created without error.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.