Error in update query

Error in update query

Dear community members,

I am getting this error at the time of update operation.

Error in advanced query UpdateIncome in Upload in FNMA in AWMClientDisplay (UPDATE {Income2}    SET {Income2}.[Overtime] = @Overtime,      {Income2}.[Bonuses] = @Bonuses,      {Income2}.[Commission] = @Commission,      {Income2}.[Dividends_Interest] = @Dividends_Interest,      {Income2}.[NetRent] = @NetRent,      {Income2}.[Other] = @Other,    WHERE {Income2}.[Id] = @Income2Id): ORA-01747: invalid user.table.column, table.column, or column specification

This error comes when we have given column name as a datatype. But nowhere I had done in my entity.

Please advice.


Anybody knows the cause of this problem?
Is that entity a external entity?

Did you use the snippet (from help page):
/* %LogicalDatabase%=GetLogicalDatabase({Entity Name}) */

Best regards,
Hi Pedro,

Yes that is an external entity.

I wrote that snippet but still not working.
Just a stupid question but you changed {Entity Name} with {Income2} correct? Best regards, PC
Yes. I did the same