Payload For Estimated Compensation Webservice Is Erroring With Mandatory Fields (Doc ID 2016376.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Incentive Compensation - Version 11.1.9.2.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

Sample payload for Oracle Fusion Incentive Compensation's Estimated Compensation webservice to create transaction.

https://myinstance/external-IncentiveCompensationApp-IcCnTpEstimatedCompPublicService/EstimatedCompensationServiceService
 

REQUEST SUBMITTED:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/incentiveCompensation/cn/transactionProcessing/estimatedCompensation/publicService/types/" xmlns:pub="http://xmlns.oracle.com/apps/incentiveCompensation/cn/transactionProcessing/estimatedCompensation/publicService/" xmlns:est="http://xmlns.oracle.com/apps/flex/incentiveCompensation/cn/transactionProcessing/estimatedCompensation/EstimatedCompTransDFF/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:estimateCompensation>
         <typ:personInformation>
                 <pub:ParticipantName>Jones Lisa</pub:ParticipantName>
                 <pub:PersonNumber>26</pub:PersonNumber>
         </typ:personInformation>
         <typ:transactionList>
                  <pub:TransactionName>Test_SC_27May_EC_1</pub:TransactionName>           
                  <pub:SourceEventDate>2015-05-27</pub:SourceEventDate>
                  <pub:TransactionAmountSourceCurrency>1234</pub:TransactionAmountSourceCurrency>
                  <pub:EstimatedCompTransDFF>
                       <est:_Country>US</est:_Country>
                  </pub:EstimatedCompTransDFF>
         </typ:transactionList>
      </typ:estimateCompensation>
   </soapenv:Body>
</soapenv:Envelope>

 

 

RESPONSE ERROR:

<faultstring>

JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000002381882 ] in EstimatedCompTransactionEOJBO-27027: Missing mandatory attributes for a row with key oracle.jbo.Key[300000002381882 ] of type EstimatedCompTransactionEOJBO-27014: Attribute ParticipantId in EstimatedCompTransactionEO is required.JBO-27014: Attribute OrgId in EstimatedCompTransactionEO is required.JBO-27027: Missing mandatory attributes for a row with key oracle.jbo.Key[300000002381882 ] of type EstimatedCompTransactionEOJBO-27014: Attribute ParticipantId in EstimatedCompTransactionEO is required.JBO-27014: Attribute OrgId in EstimatedCompTransactionEO is required.

</faultstring>

 

OR

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
   <env:Header/>
   <env:Body>
      <env:Fault>
         <faultcode>env:Server</faultcode>
         <faultstring>JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-26041. Please contact service provider on details.</faultstring>
         <detail>
            <tns:ServiceErrorMessage xsi:type="tns:ServiceDMLErrorMessage" xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
               <tns:code>26041</tns:code>
               <tns:message>JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-26041. Please contact service provider on details.</tns:message>
               <tns:severity>SEVERITY_ERROR</tns:severity>
               <tns:detail xsi:type="tns:ServiceErrorMessage">
                  <tns:message>ORA-01400: cannot insert NULL into ("FUSION"."CN_EST_CMP_TRANSACTIONS_ALL"."ORG_ID")</tns:message>
                  <tns:severity>SEVERITY_ERROR</tns:severity>
                  <tns:exceptionClassName>java.sql.SQLIntegrityConstraintViolationException</tns:exceptionClassName>
               </tns:detail>
               <tns:exceptionClassName>oracle.jbo.DMLException</tns:exceptionClassName>
               <tns:operation>DML_INSERT</tns:operation>
               <tns:statement>JBO-56012: SQLException from preparing or executing sql statement with original Jbo error code JBO-26041. Please contact service provider on details.</tns:statement>
            </tns:ServiceErrorMessage>
         </detail>
      </env:Fault>
   </env:Body>
</env:Envelope>

 

Solution

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