Invalid Identifier

[vas_y]

Hi,

I am getting below error from target where REFRESH_DATE column and data type as 'datetime' and mapped to 'sysdate()'. Can you please share your thoughts where I can fix the issue.

				SQL submitted to Oracle Server <(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT
				= 1521)))(CONNECT_DATA =(SID=CDWD)))> resulted in error <ORA-00904: "REFRESH_DATE": invalid identifier

[former_member205887 · Accepted solution]

Hi Sri,

Describe your Target table and check the columns structure of it.

[vas_y · Accepted solution]

Thanks for Balakrishna. I checked target tables one of the column is not available in the table.

Once again thanks for sharing details.