My Oracle Support Banner

OE_ORDER_PUB.PROCESS_ORDER Is Updating Calculate Price Flag Value Even With Pricing Error Being Thrown (Doc ID 1433276.1)

Last updated on DECEMBER 30, 2024

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.

Goal


Is there a method in the sales order form and/or the process_order public API
that when an error message of any kind is encountered upon making an update
to the calculate price flag, that the update to the calculate price flag is reverted?

Go to Sales Order form in Order Management Responsibility.
Change the Calculate Price Flag value from "Freeze Price" to "Calculate Price" and Save the Record.
In the sales order form, If there are any Pricing Error(formula error etc) then Oracle is displaying that error message yet also saved the change for Calculate Price Flag to "Calculate Price".

Using oe_order_pub.process_line API it returns status as "Success",
even though it would encounter a Pricing Error message.

Customers' expected behavior is that in case of error it should return "Fail" as a return status.


Solution

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
Goal
Solution
References


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