Using API ASO_QUOTE_PUB.UPDATE_QUOTE to add many quote lines and cannot determine which line caused failure
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