+15Hi All,
An user has tried to approve a leave request in My Absence Calendar window.
But he is getting an error
Exception : ORA-00932: inconsistent datatypes: expected - got -
Failed executing statement (ORA-00932: inconsistent datatypes: expected - got -
ORA-06512: at line 16)
Any idea why we getting this error?
This is in IFS Apps 9 UPD 8.
Thank you.
Best answer by Manoj Ruwanhewa
Hi
The most common cause of this Oracle error occurs when you attempt to execute an operation of two different data types that are incompatible.
In addition, it may have occurred because the user tried to perform an operation on a database object that is not intended for normal use.
Can you try to disable any configurations associated with this screen including custom fields and custom events for that logical unit.
If this is issue cannot be recreated for IFSAPP, please try to restore the user profile and base profile for that particular user.
Regards
Manoj
+15Hi
The most common cause of this Oracle error occurs when you attempt to execute an operation of two different data types that are incompatible.
In addition, it may have occurred because the user tried to perform an operation on a database object that is not intended for normal use.
Can you try to disable any configurations associated with this screen including custom fields and custom events for that logical unit.
If this is issue cannot be recreated for IFSAPP, please try to restore the user profile and base profile for that particular user.
Regards
Manoj
+15Hi
I could recreate the error with IFSAPP for the same record when I try to approve. But when I create another absence request from a different user and try to approve it with IFSAPP, I was able to approve it without any error. However I will try all your suggestions.
Thanks again 
+15Hi
Then I was able to approve the request, without errors. There are custom fields in the header of My Absence Calendar window but there are no custom fields in line level. Those custom fields working fine for other users as well. So do I still need to worry about the custom fields.
+15Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
