Error Creating a Sales Order From a Quote :The Item Specified is Invalid or Does not Exist in the Warehouse You Specified (Doc ID 1072517.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Quoting - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 19-Apr-2013***

Symptoms

When creating a sales order from a quote an error is returned.  Note that a Sales Order can be successfully entered in Order Management, so  there is no problem with the setup of Oracle Order Management or Oracle Inventory.

Error returned in the Quoting screen is:
The item specified is invalid or does not exist in the warehouse you specified. Please enter a valid item - warehouse combination
The following is seen in the Quoting pl/sql debug log:
Return status before MACD Logic:E
    Not in 110510 - no MACD logic
    Return status after MACD Logic is:E
    Exit OE_VALIDATE_LINE.ENTITY E
    ENTER SET RECURSION MODE
    ENTITY CODE-5
    ENTRY-EXIT MODE -0
    RECURSION MODE AT ENTRY -N
    RECURSION MODE WITHOUT EXP AT ENTRY -N
    RECURSION MODE AT EXIT -N
    RECURSION MODE WITHOUT EXP AT EXIT -N
    PO: EXITING PROCESS ORDER WITH ERROR
    ENTER SET RECURSION MODE
    ENTITY CODE-1
    ENTRY-EXIT MODE -0
    RECURSION MODE AT ENTRY -N
    RECURSION MODE WITHOUT EXP AT ENTRY -N
    RECURSION MODE AT EXIT -N
    RECURSION MODE WITHOUT EXP AT EXIT -N
    DELETE REQUEST11
    Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt
    ENTERING DELETE_ATTRIBUTE_CHANGES -1
    ENTERING PROCEDURE CLEAR_GLOBAL_STRUCTURE
    IN CLEAR_FLOWSTART_GLOBALS
    LEAVING OE_MSG_PUB.COUNT_AND_GET 1
    ASO Create_Order: After Proc_Order: x_return_status: E
    LEAVING OE_MSG_PUB.COUNT_AND_GET 1
    ASO before updating the processing messages table
    ASO before calling oe_msg_pub.get
    ASO before calling get_msg_context l_msg_index:1
    ASO after calling get_msg_context
    ASO In index.message_text is null
    ASO l_msg_orig_sys_line_ref
    ASO The item specified is invalid or does not exist in the warehouse you specified. Please enter a
    valid item-warehouse combination.
    ASO Exception in package : ASO_ORDER_INT

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