My Oracle Support Banner

FA: SCM: OM: Order Submission Failed With Error "JBO-29000: Unexpected exception caught: oracle.apps.scm.pricing.priceExecution.algorithms ..." (Doc ID 2657281.1)

Last updated on APRIL 28, 2020

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Symptoms

Draft order is imported into system from CPQ and while submitting the order getting below error on screen:

ERROR MESSAGES (ON-SCREEN AND IN LOGS)
----------
JBO-29000: Unexpected exception caught: oracle.apps.scm.pricing.priceExecution.algorithms.publicQuery.exception.SetQueryException, msg=An error occurred while sorting two incomparable values. java.lang.Integer cannot be cast to java.lang.Long

Also in the error payload, found below error:

<PriceRequestInternal:PricingMessage>
     <PriceRequestInternal:HeaderId>300000154848115</PriceRequestInternal:HeaderId>
     <PriceRequestInternal:MessageName>QP_PDP_CALC_TAX</PriceRequestInternal:MessageName>
     <PriceRequestInternal:MessageText>An error occurred while calculating tax. A tax exempt transaction line is entered without entering the tax exempt reason. Enter a tax exempt reason for this transaction line.</PriceRequestInternal:MessageText>
     <PriceRequestInternal:MessageTypeCode>ERROR</PriceRequestInternal:MessageTypeCode>
     <PriceRequestInternal:ParentEntityCode>LINE</PriceRequestInternal:ParentEntityCode>
     <PriceRequestInternal:ParentEntityId>300000154848111</PriceRequestInternal:ParentEntityId>
     <PriceRequestInternal:PricingMessageId>300000154139317</PriceRequestInternal:PricingMessageId>
  </PriceRequestInternal:PricingMessage>
  
Complete payload can be accessed in finest logs of UI server log. Enable the finest log for the log in user with AFLOG_MODULE = oracle.apps.scm.pricing.%

Changes

 

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
Changes
Cause
Solution


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