Execute getOrderByKey Web Service For a Product Type of LINEDIR and Receive Error "Exception thrown during Order API execution. Message:" (Doc ID 3012657.1)

Last updated on APRIL 08, 2024

Applies to:

Symptoms

This issue was reported as a problem with the getOrderByKey Web Service not being able to export a product type of LINEDIR.  The issues is caused by createOrderRequest Web Service causing data corruption by placing zero (0) in the DIR_LIST_SRSI table columns TTY_TTD_CD and DO_NOT_ABBREV when NOT populating the <ord2:ttyttdCd>ttTDDOnly</ord2:ttyttdCd> and <ord2:doNotAbbrev>dnaListedName</ord2:doNotAbbrev> in the <ord1:LineDir>/<ord2:lineDirectory>/<ord2:addlInfo> structures.

Do not populate the  <ord2:ttyttdCd> and/or <ord2:doNotAbbrev> in the following LineDir structure for the crateOrderRequest Web Service and it will cause a zero (0) to be placed in the DIR_LIST_SRSI table columns TTY_TTD_CD and DO_NOT_ABBREV then causing the getOrderByKey to fail as this is not a valid ENUM value.

The subsequent getOrderByKey Web Service invocation receives the following error:

    <S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
       <S:Body>
          <ns0:Fault xmlns:ns0="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.w3.org/2003/05/soap-envelope">
             <faultcode>ns0:Server</faultcode>
             <faultstring>Exception thrown during Order API execution.
     Message:</faultstring>
             <detail>
                <ns0:WSException xmlns:ns0=" http://www.openuri.org /">
                   <message>Exception thrown during Order API execution.
     Message:</message>
                </ns0:WSException>
             </detail>
          </ns0:Fault>
       </S:Body>
    </S:Envelope>

Changes

Cause

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