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 DECEMBER 03, 2019
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!
In this Document