OWB Mapping Upgraded From 10g to 220.127.116.11 Fails to Deploy With VLD-1800 And RTC-5325
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
Oracle Warehouse Builder 10gR2 has been migrated to Warehouse Builder 126.96.36.199.
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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms