ORA-01400: cannot insert NULL into ("ASAP"."NOTES"."DATE_ENTERED") error creating PSR ORDER via XML API (Doc ID 739196.1)

Last updated on MAY 28, 2014

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.
*** Article reviewed for currency on December 29th, 2011 ***


Symptoms

Unable to create an order with the XML API createOrderByValueRequest method. An Oracle error is
received in the application log indicating a NULL value cannot be inserted into the DATE_ENTERED
column of the NOTES table. The inability to create PSR orders using the XML API is critical to
business operations.

Error in captured in the ${SERVER}.mss.log

<Jul 31, 2008 3:10:19 PM GMT-04:30> <Warning> <WLW> <000000>
<Id=orderManagement; Method=com.metasolv.ejb.order.PSROrderManager.importPSROrder();
Failure=com.metasolv.common.MSLVXMLApiException: Exception Thrown Importing Order.
Message: Invalid order information, please verify. Error Code 39990:Miscellaneous Error:
ORA-01400: cannot insert NULL into ("ASAP"."NOTES"."DATE_ENTERED")
.
Error Code 30741:Miscellaneous Error: Unable to update notes.
Error Code 39990:Miscellaneous Error: ORA-01400: cannot insert NULL into
("ASAP"."NOTES"."DATE_ENTERED")

Changes

Customers migrating database from Oracle 9i to 10g.  Applies to Oracle 11g.

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