Data not fetching in tOracleInput component

Data not fetching in tOracleInput component

I am trying to move data from a oracle table to its archive table using talend. In tOracleInput component, i have included the query which fetches the data to be archived. I am moving data which are older than 2 months to archive based on date column in parent table. In child table, data is moved by linking parent table with foreign key relationship and and based on date. If i execute the query in sql developer data is fetching. Same query is used in talend, but it is not fetching data and job runs with no error. if i remove where condition it is fetching data in talend.