OWB Mapping Upgraded From 10g to 11.2.0.2 Fails to Deploy With VLD-1800 And RTC-5325 (Doc ID 1308411.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Oracle Warehouse Builder 10gR2 has been migrated to Warehouse Builder 11.2.0.2.
The deployment of some mappings fails at validation step with following error :

RTC-5325: The generator was unable to produce any valid objects, please correct the source object(s) before trying to deploy again.


The deployment log shows :

VLD-1800 illegal use of sequence operator ["MY_SEQ"] in a complex mapping.
Sequence operator ["MY_SEQ"] are used in a complex mapping which requires generation using a nested subquery (typically a map with aggregation or order by, or complex operations followed by a join). Sequences are not allowed to be used in nested subqueries. Please reorganize the map.
Hint: move the sequence operator as close to the target as possible

Looking at the mapping, the sequence Operator is directly connected to the target table.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms