Interface Trip Stop Errors with Ora-06512: At "Apps.Oe_order_adj_pvt", This Attribute is defined as numeric but passed as non-numeric/Errored

(Doc ID 1302352.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 to 12.2.4 [Release 11.5.10 to 12.2]
Oracle Shipping Execution - Version 11.5.10.0 to 12.2.4 [Release 11.5.10 to 12.2]
Oracle Advanced Pricing - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Executable:WSHINTERFACE - Interface Trip Stop
ConcurrentProgram:WSHINVIAS - Interface All Trip Stops - SRS


Symptoms


On : 11.5.10.2 version, Pricing, Discounting & Charges

When attempting to run Interface Trip Stop
the following error occurs.

ERROR
-----------------------
l_status_text Exception in QP_PREQ_GRP.PRICE_REQUEST This Attribute( with Context: PRICING ATTRIBUTE and Attribute: Additional Order XX ) is defined as numeric but passed as non-numeric/Errored
Exception in QP_PREQ_GRP.PRICE_REQUEST This Attribute( with Context: PRICING ATTRIBUTE and Attribute: Additional Order XX ) is defined as numeric but passed as non-numeric/Errored
Exception Price Request GRP: Exception in QP_PREQ_GRP.PRICE_REQUEST This Attribute( with Context: PRICING ATTRIBUTE and Attribute: Additional Order Discount ) is defined as numeric but passed as non-numeric/Errored
Exception Price Request: User-Defined Exception


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run interface trip stop
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
They are not able to interface the orders as a result all the records are stuck in Interface , we need to clear the records
Most of the orders are having this Problem

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