TeleService - Error Creating a Service Request : ORA-01400: Cannot insert NULL into ("CS".CS_HZ_SR_CONTACT_POINTS".CONTACT_TYPE")
Last updated on MARCH 23, 2017
Applies to:Oracle Teleservice - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
When creating a contact on the Service Request form after entering a Serial Number, the following error appears when saving the record:
ORA-01400: Cannot insert NULL into ("CS".CS_HZ_SR_CONTACT_POINTS".CONTACT_TYPE") in Package CS_ServicesRequest_PVT Procedure Create_ServiceRequest
Steps To Reproduce:
(N) Service Requests > Create Service Requests
- Enter Customer and Contact information
- Enter a Serial Number.
- Navigate to the Contacts / Addresses tab
- Create a Contact.
- Try to save the record
=> Error appears.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms