Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
Oracle Warehouse Builder 10gR2 has been migrated to Warehouse Builder 184.108.40.206.
The deployment of some mappings fails at validation step with following error :
The deployment log shows :
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms