I am able to resolve this issue. In Our new DB "View Merging" was turned off by DBA as we were getting error "ORA-00979: not a group by expression" while executing one of our stored proc. In oracle debug log I saw "SELECT FOR UPDATE" query was translated into the following update statement and which is eventually using a temp table/view.
update (select rowid as "__Oracle_JDBC_interal_ROWID__", STATUS from mySchema.myTable where run_id = 1 ) set STATUS = 'PENDING' WHERE ROWID = 'AAAjyeACgAAAAVvAAA';
Just for reference
Oracle 12c Bug : ORA-00979
Learning something new everyday.
Fixed by turning "View Merging" On..