My Oracle Support Banner

Unable To Create Contact For Integration (Doc ID 2460979.1)

Last updated on NOVEMBER 03, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.02.0 version, Accounts, Contacts, Households

The createContact operation of the ContactService web service is resulting in error

ERROR
-----------------------
<tns:code>27024</tns:code>
<tns:message>JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000902034533 ] in PersonDEO</tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:detail xsi:type = "tns:ServiceErrorMessage">
<tns:code/>
<tns:message>Please enter Email address to create Contact</tns:message>
<tns:severity>SEVERITY_ERROR</tns:severity>
<tns:exceptionClassName>oracle.jbo.ValidationException</tns:exceptionClassName>
</tns:detail>
<tns:exceptionClassName>oracle.jbo.RowValException</tns:exceptionClassName>
<tns:objectName>PersonDEO</tns:objectName>

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. With an insert trigger script:
if(nvl(PrimaryEmailAddress,"") != ""){
}
else {
throw new oracle.jbo.ValidationException('Please enter Email address to create Contact')
}

2. Send request
<typ:createContact>
<typ:contact>
<con:AccountPartyId>999999999999999</con:AccountPartyId>
<con:FirstName>XXXXXXXXXX</con:FirstName>
<con:LastName>XXXXXXXXXX</con:LastName>
<con:EmailAddress>XXXXXXXXXX</con:EmailAddress>
<con:CreatedByModule>HZ_WS</con:CreatedByModule>
</typ:contact>
</typ:createContact>

3. The error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create a contact through the web service.

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
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.