createOrderByValueRequest XML API When Passing Negative Decimal for User Data Receives Error "User Data Must Be Decimal" (Doc ID 1409830.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.

Symptoms

Execute createOrderByValueRequest XML API and populate the metaSolvUserDataValue structure with a User Data value defined as DECIMAL and pass in a negative number as follows:


<mip:metaSolvUserDataValue>
  <mip:userData>
    <mip:actionCd>A</mip:actionCd>
    <mip:tableNm>PSR_USER_DATA</mip:tableNm>
    <mip:keyColumnNm>DOCUMENT_NUMBER</mip:keyColumnNm>
    <mip:keyValue>0</mip:keyValue>
    <mip:nameValuePairValues>
      <mip:column>ESTIMATED_REVENUEE</mip:column>
      <mip:value>-40.0</mip:value>
      <mip:dataType>DECIMAL</mip:dataType>
    </mip:nameValuePairValues>
  </mip:userData>
</mip:metaSolvUserDataValue>


Receive the following error:

External Service Failure: [WLI-Core:489214]ProcessControl invocation failed[Exception Thrown Updating User Data.
Message: java.lang.Exception: Unable to validate the User Data for Customer Account Key : 12345
Error Code 95213:Value -40.00 in user data must be decimal for column ESTIMATED_REVENUE.]

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