My Oracle Support Banner

Using API ASO_QUOTE_PUB.UPDATE_QUOTE to add multiple quote lines and cannot determine which line caused failure (Doc ID 2300997.1)

Last updated on DECEMBER 12, 2023

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).





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

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