The TF (MSSQL) Upsert destination transform has the ability to pass error rows to (for instance) a flat file for error handling. The Oracle Upsert destination, however, appears to lack this functionality.
It would be really great to have the ability to redirect error rows from the Oracle upsert destination, giving us the ability to handle errors.