Getting the last data update time of a specific table in Oracle
You should change the order of MAX and SCN_TO_TIMESTAMP

SELECT SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN)) from mytablename;


This might still fail if it has been long time since table has been modified, but should work for active tables.