My Oracle Support Banner

Unable To Create Quote Header-Only (Without Lines) Using ASO_QUOTE_PUB (Doc ID 2343754.1)

Last updated on APRIL 25, 2023

Applies to:

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

Symptoms

On Test:  12.2.5 version, API

You are able to create Quote Header without line details on Quoting UI.
However, you are getting error while creating quote header without lines using API.

This was working prior to applying Patch 25740605 (WRONG TAB APPEARS AS SELECTED IN FORMS QUOTING)

Error (From debug log)

ASO Update Quote
ASO Before call to the second overloaded create_quote procedure.
ASO Exception in package : ASO_QUOTE_PUB
ASO Exception in API : CREATE_QUOTE
ASO SQLCODE : 100
ASO SQLERRM : ORA-01403: no data found
30-OCT-2017 06:54:36 ASO After call to the second overloaded create_quote procedure: x_return_status: U



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a wrapper code to call ASO_QUOTE_PUB to create only the quote header.
2. Run script after enabling debug
3. ASO log shows ORA-01403: no data found

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to create quotes via API after recent ASO Patch.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.