My Oracle Support Banner

ORA-01400: Cannot Insert NULL Into ("ASAP"."NOTES"."DATE_ENTERED") error when importing a PSR order using the createOrderByValueRequest XML API (Doc ID 1638550.1)

Last updated on MAY 06, 2014

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.


When attempting to import a PSR order using the createOrderByValueRequest XML API, an ORA-01400: cannot insert NULL into ("ASAP"."NOTES"."DATE_ENTERED") error is thrown. Removing the orderNotes structure allows the order to be created. However, assigning a Provisioning Plan to the order using the assignProvisionPlanProcedureRequest XML API throws a ORA-01400: cannot insert NULL into ("ASAP"."TASK"."ASSIGNED_FROM_DATE") error. Creating a new note on a PSR order in the GUI throws the same error as well as random popup errors converting SYSDATE to GMT DATE throughout the GUI.


Due to this issue, the system is essentially unusable


To view full details, 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 a vibrant support community of peers and Oracle experts.