inconsistent datatypes: expected - got - | IFS Community

inconsistent datatypes: expected - got -

  • 22 October 2021
  • 5 replies

Badge +12

Hi 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 23 October 2021, 00:09

View original

5 replies

Userlevel 7
Badge +14

Hi @MitDenukN,

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.




Badge +12

Hi @Manoj Ruwanhewa , Thank you very much for your opinion.
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 :blush:

Badge +12

Hi @Manoj Ruwanhewa, I have created a absence request for the same user by logged in as IFSAPP.
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. 

Badge +12

Hi @Manoj Ruwanhewa , finally we could solve the issue. The user has manually inserted ‘Annual’ for On Demand Absence Type ID even though LOV doesn’t contain any data for this field. When we remove those values from her records, we were able to approve records without any errors.


Userlevel 3
Badge +7

Thank you so much @Manoj Ruwanhewa