ORA-01400: Cannot Insert NULL Into ("ASAP"."NOTES"."DATE_ENTERED") error when importing a PSR order using the createOrderByValueRequest XML API
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
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 hundreds of Community platforms