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

(Doc ID 2343754.1)

Last updated on DECEMBER 28, 2017

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 only 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

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