Incorrect PL/SQL Generated in OWB 11.2.0.2 When Using a Pluggable Mapping (Doc ID 1329808.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

An OWB 11.2.0.2 Pluggable Mapping takes data from a view (STG_TEAM_V) and does a MINUS against a table (STG_TEAM_ERR).
When this Pluggable Mapping is used in a mapping, the generated mapping code is not correct.
It takes data from the view (STG_TEAM_V) and does a MINUS against the same view (STG_TEAM_V) instead of the table (STG_TEAM_ERR).

See below the incorrect part of the generated code:

SELECT
/* Z_TEST_PM.STG_TEAM_V.INOUTGRP1 */
"STG_TEAM_V"."ID" "ID",
.........
FROM
"STG_TEAM_V" "STG_TEAM_V"
MINUS /* OPERATOR Z_TEST_PM.SET_OPERATION */
SELECT
/* Z_TEST_PM.STG_TEAM_ERR.ERR_GROUP */
"STG_TEAM_ERR"."ID" "ID",
.........
FROM
"STG_TEAM_V" "STG_TEAM_ERR") ) "SET_OPERATION" ; <

Code should be like:

SELECT
/* Z_TEST_PM.STG_TEAM_V.INOUTGRP1 */
"STG_TEAM_V"."ID" "ID",
.........
FROM
"STG_TEAM_V" "STG_TEAM_V"
MINUS /* OPERATOR Z_TEST_PM.SET_OPERATION */
SELECT
/* Z_TEST_PM.STG_TEAM_ERR.ERR_GROUP */
"STG_TEAM_ERR"."ID" "ID",
.........
FROM
"STG_TEAM_ERR" "STG_TEAM_ERR") ) "SET_OPERATION" ;

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