ORA-00932: inconsistent datatypes: Expected DATE got NUMBER - While Saving SR (Doc ID 758728.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Customer Support - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Jan-2014***


Symptoms

When attempting to create/save a service request, the following error occurs:
'IEU_WR_PUB.CREATE_WR_ITEM reports error. A required parameter may be nul;l; PRIORITY_CODE' 
' ORA-OO932: inconsistent datatypes Expected DATE got NUMBER'

The issue can be reproduced at will with the following steps:
Customer Support-->Create Service request-->After filling all the required details at header
level > Click on workbench enter required field > trying to save the at any stage generates
error messages:
1. IEU_WR_PUB.CREATE_WR_ITEM reports error. A required parameter may be nul;l; PRIORITY_CODE
2. ORA-OO932: inconsistent datatypes Expected DATE got NUMBER

Even though messages pop up, the service request is saved.

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