Sales Orders form: ORA-01400 Cannot Insert Null Into Ont.OE_ORDER_HEADERS_ALL.ORDER_NUMBER (Doc ID 1208783.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Jul-2013***

OEXOEORD, ORA-01400 OE_ORDER_HEADERS_ALL OE_Header_Util


Symptoms

In 12.1.2 in Production:

When attempting to enter the Order Number in the Sales Order form ( for a manual Order Type), the Order Number field is grayed out. When saving the Sales Order, the following error message is displayed.

ERROR
------------
ORA-01400: cannot insert NULL into
("ONT"."OE_ORDER_HEADERS_ALL"."ORDER_NUMBER") in Package OE_Header_Util Procedure Insert_Row


STEPS TO REPRODUCE
-----------------------------------
1.Via the Order Management (OM) responsibility.

2. Navigate: Setup > Transaction Types > Define

3. Create Transaction Type: <transaction type name>

    Order Category: Mixed
    Transaction Type Code: ORDER
    Fulfillment flow: Order Flow - Generic
    Negotiation Flow: Negotiation Flow - Generic
    Default Return Line type: Return (Receipt)
    Default Order Line Type: Standard (Line Invoicing)

4. Save the changes.

5. Assign a Document Sequence that is defined for order numbering to this Document Sequence Category.

6. In the Document Sequences form, Navigate: OM > Setup > Document > Define

7. Define a new Sequence:

    Name: <sequence name>
    Application: Order Management
    From: Today's Date
    Type: Manual

8. Save the changes.

9. Navigate: OM > Setup > Document > Assign

10. In the tab, Document:
  
     Application: Order Management
    Category: <the name of the transaction type>
    Set of Books: < your Set of Books >
    Method: Manual

11. In the tab, Assignment:

    Start date: today's date
    Sequence: Select from the List of Values (LOV) the Sequence that was defined in step 7 :
    <sequence    name>

12. Save the changes.

13. Go to the Sales Order (SO) form, and try to create a SO header with the Order Type  (Transaction
     Type defined previously).

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