ORA 1410 "invalid ROWID"

Explanation:
This error is raised when an operation refers to a ROWID in a table
for which there is no such row.

The reference to a ROWID may be implicit from a WHERE CURRENT OF
clause or directly from a WHERE ROWID=... clause.

ORA 1410 indicates the ROWID is for a BLOCK that is not part of this
table. If you update a rowid where the BLOCK is valid but the slot
within the block is invalid you just get ZERO rows processed/returned.
This can be a source of confusion as it is inconsistent.

In my case , it is due to the index was rebuild at end of data (direct path) loading , while another select statement was running & caused the problem.

Solution:

Add dependency to the job for operational schedule.