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


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

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References

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