Using API ASO_QUOTE_PUB.UPDATE_QUOTE to add many quote lines and cannot determine which line caused failure

(Doc ID 2300997.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Order Capture - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Quote APIs and Architecture

While adding new lines in a quote using API: aso_quote_pub.update_quote - 

Using the API aso_quote_pub.update_quote to insert a larger number of lines to a quote in a single call.
 If during this call an error occurs, the error message doesn't specify what line actually caused the error and thus the entire call fails and there is no way for the user to know which line failed.
The only way to see more info is to enable quoting debug and find the information in the logs, but the users won't have access to that.

Expect a more detailed error for the problem line number(s).

The issue has the following business impact:
Due to this issue, users cannot know what lines fail when adding large quotes impacting generation of sales orders.




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