Using the Process_Order API for Update Is Not Working for Multiple Sales Orders. (Doc ID 2076760.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Using the OE_Order_PUB.Process_Order API for updating the price for multiple orders is not working. The code (within the Customer SQL Wrapper) to update the price for multiple orders in a loop and it is updating the price for first order in the loop and for the remaining orders it is giving the success as status but it is not updating the price.  Instead the following error is given:


ERROR

Please enter required information - Warehouse


STEPS

1.  Order Management Responsibility
2.  Custom SQL Wrapper -> Process_Order API



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