Found the following on OTN samplecode for data integration but the link is broken (404 error), can it be fixed?
Metadata synchronization expert 2010-10-01
Expert to synchronize an object with its dependent usages. For example a table to the mappings that use it, or a pluggable mapping to the mappings that use it.
[Metadata synchronization expert|http://download.oracle.com/otn/samplecode/owb_11gR2_synchronize.mdl]