OWB 11.2 is also certified for Oracle 10g (which is also indicated by my quote from the manual, that mentions 10g), Oracle provides a stand-alone version of OWB 11.2 for this purpose. Besides, row-based update-mappings are already a feature in OWB 10.1.
We're getting off-topic here, but allright. I read the page you referred to, and I can't find the text that supports you assertion. It says among others
"Compatibility with Oracle Database
Database Release Compatible Warehouse Builder Releases
DB10gR2 Warehouse Builder 10.2, 11.1, and 11.2
Enterprise Edition Certified for use of all OWB functionality including additional cost licenses" [this is our database version]
For me this implies that OWB 11.2 can be used on a 10.2 database.What other part of the text says or implies that OWB 11.2 is only certified for database 11.2?
Furthermore, In the "Oracle® Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) for Windows and Linux", chapter "Working with the Standalone Install Package" it reads:
"There are several situations when you must download and install the
OWB 11g Release 2 Standalone Install Package:
■ You are installing OWB 11.2 and hosting an OWB Repository on one of:
Oracle Database 10g Release 1, Oracle Database 10g Release 2, or
Oracle Database 11g Release 1
To get on-topic again: have you ever succeeded in generating an SET_BASED UPDATE-mapping on a configuration that is, to your opinion, certified?
I found the limiting factor. As mentioned before we are migrating from a previous version. Thios version deployed in a 9i database. To enable OWB 11gR2 to generate a SET_BASED mapping the module configuration property 'PL/SQL Generation Mode' has to be set to 'Oracle 10gR1' or higher. It was 'Oracle 9i', preventing OWB from generating the mapping SET_BASED. When I changed the property to 'ORAcle 10gR2' the mapping genreated SET_BASED without a problem.