FA: SCM: OM: Submitting an Order Fails With: JBO-29000: JBO-29000: Unexpected exception caught: oracle.apps.scm.pricing.priceExecution.algorithms.publicQuery.exception.SetQueryException, msg=An error occurred while sorting two incomparable values. java.la
(Doc ID 2657281.1)
Last updated on JULY 14, 2020
Applies to:
Oracle Fusion Order Management Cloud Service - Version 11.13.20.01.0 and laterInformation in this document applies to any platform.
Symptoms
A Draft order is imported into system from an external order capture application, an error is reported when users submit the order:
NOTE: The Item is tax exempt.
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
Additional errors are reported in the SOA Trace which can be accessed by support engineers:
<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>
<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>
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 |
| Cause |
| Solution |