My Oracle Support Banner

MetaSolv API Receives the Following Error When Creating PSR Order "ORA-01400: cannot insert NULL into ("ASAP"."NOTES"."DATE_ENTERED")" (Doc ID 739196.1)

Last updated on FEBRUARY 17, 2019

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


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


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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.