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

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