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.

Symptoms

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.


API ERROR
-----------------------




BUSINESS IMPACT
-----------------------
Due to this issue, the system is essentially unusable

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!


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