Thank you for writing to us.
The job might have just displayed the error message in the jobstep log. But if you check the applimation log for the same job, it would have executed a query like below in order to validate if the table exists in the database or not:
SELECT * FROM HIST."TESTMAINDATA" WHERE 1=2
If this validation query fails, the job will fail with "ORA-00942: table or view does not exist".
Please get back to us if you have any queries on the above.
Karthik Raja V