Issue When Creating A Consumer Via Web Service With a Language

(Doc ID 1361753.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Trading Community Model Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Trading Community Model - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

 

 

 

Customer create Consumers -ie Parties of type Persons  by using webservices : salesPartiesService

<ns1:createPersonParty>
           <ns1:personParty xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/">
               <ns2:CreatedByModule>HZ_WS</ns2:CreatedByModule>
               <ns2:PartyUsageAssignment xmlns:ns3="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/">
                   <ns3:PartyUsageCode>SALES_PROSPECT</ns3:PartyUsageCode>
                   <ns3:EffectiveStartDate>2011-03-08</ns3:EffectiveStartDate>
                   <ns3:CreatedByModule>HZ_WS</ns3:CreatedByModule>
               </ns2:PartyUsageAssignment>
               <ns2:Salutation>Herr</ns2:Salutation>
               <ns2:PersonProfile>
                   <per:OrigSystemReference>1-12501</per:OrigSystemReference>
                   <ns2:PersonFirstName>Max002</ns2:PersonFirstName>
                   <ns2:PersonLastName>StepByStep002</ns2:PersonLastName>
   <ns2:PersonPreNameAdjunct>DR.</ns2:PersonPreNameAdjunct>
   <ns2:DateOfBirth>1988-02-08</ns2:DateOfBirth>
                   <ns2:Gender>MALE</ns2:Gender>
                   <ns2:CreatedByModule>HZ_WS</ns2:CreatedByModule>
   <per:Comments>Comment</per:Comments>
               </ns2:PersonProfile>
...

<per:PersonLanguage>
<par:LanguageName>GER</par:LanguageName>
<par:CreatedBy>HZ_WS</par:CreatedBy>
</per:PersonLanguage>


....

In a first step customer an error due to to a syntax error and replaced :

<par:CreatedBy>HZ_WS</par:CreatedBy>
by
<par:CreatedByModule>HZ_WS</par:CreatedByModule>

But now get a similar error due to the language which is not accepted



involved language part is :

<per:PersonLanguage>
<par:LanguageName>GER</par:LanguageName>
<par:CreatedBy>HZ_WS</par:CreatedBy>
</per:PersonLanguage>

....

Error is :

        <faultcode>env:Server</faultcode>

        <faultstring><![CDATA[JBO-27023: Failed to validate
all rows in a transaction.JBO-27024: Failed to validate a row with key
oracle.jbo.Key[100000037653788 ] in
PersonLanguageEOJBO-HZ:::HZ_PERSON_LANG_INVALID:
<MESSAGE><NUMBER>HZ-120550</NUMBER><TEXT>The
language specified for this person is
invalid.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>JBO-27014:
Attribute LanguageName in PersonLanguageEO is
required.]]></faultstring>
        <detail>
           <tns:ServiceErrorMessage xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
              <tns:code>27023</tns:code>
              <tns:message>JBO-27023: Failed to validate all rows in a transaction.</tns:message>
              <tns:severity>SEVERITY_ERROR</tns:severity>
              <tns:detail xsi:type="tns:ServiceRowValErrorMessage">
                 <tns:code>27024</tns:code>

                 <tns:message>JBO-27024: Failed to validate a row
with key oracle.jbo.Key[100000037653788 ] in
PersonLanguageEO</tns:message>
                 <tns:severity>SEVERITY_ERROR</tns:severity>
                 <tns:detail xsi:type="tns:ServiceAttrValErrorMessage">
                    <tns:code>HZ:::HZ_PERSON_LANG_INVALID</tns:code>


<tns:message><![CDATA[JBO-HZ:::HZ_PERSON_LANG_INVALID:
<MESSAGE><NUMBER>HZ-120550</NUMBER><TEXT>The
language specified for this person is

invalid.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>]]></tns:message>
                    <tns:severity>SEVERITY_RECOVERABLE_ERROR</tns:severity>
                    <tns:exceptionClassName>oracle.jbo.AttrSetValException</tns:exceptionClassName>
                    <tns:attributeName>LanguageName</tns:attributeName>
                    <tns:attributeValue>DE</tns:attributeValue>
                    <tns:objectName>PersonLanguageEO</tns:objectName>
                 </tns:detail>
                 <tns:detail xsi:type="tns:ServiceAttrValErrorMessage">
                    <tns:code>27014</tns:code>
                    <tns:message>JBO-27014: Attribute LanguageName in PersonLanguageEO is required.</tns:message>
                    <tns:severity>SEVERITY_ERROR</tns:severity>
                    <tns:exceptionClassName>oracle.jbo.AttrValException</tns:exceptionClassName>
                    <tns:attributeName>LanguageName</tns:attributeName>
                    <tns:objectName>PersonLanguageEO</tns:objectName>
                 </tns:detail>
                 <tns:exceptionClassName>oracle.jbo.RowValException</tns:exceptionClassName>
                 <tns:objectName>PersonLanguageEO</tns:objectName>
              </tns:detail>
              <tns:exceptionClassName>oracle.jbo.TxnValException</tns:exceptionClassName>
           </tns:ServiceErrorMessage>

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms