Hi,

Recently i created a Management Agent for Oracle, this MA used an Updatable View, when i run a FI all works fine but when i run an export the MA throws an error, the error is:

Oracle ROW-00009: Cannot update row  Ora-ORA-01446

I have doubt if FIM 2010 R2 supports Oracle updatable views or not?.

I tested with SQL Server and works fine using an updatable view.

Regards

I assume you Oracle MA Account has the right access?

Hi Nosh,

Yes the rights are correct, i tested from PLSQL Developer and the update works.

Regards.

Well, Materialized (or updatable) Views are supported. I have done that in the past

Could you try to run an update directly using SQLPLUS?

Maybe you have a simple data issue.