"Object 'AGG_STG' Does Not Exist." Error when Testing an ODI Scenario with UD Flag (Doc ID 2721082.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Symptoms

Using Oracle Data Integrator 12.2.1.4.0, there is a Mapping has Source and Target mapped to an Aggregate Transformation. On the Target table there is a column called "<COLUMN_NAME>". This Column has "Active"flag and "UD" Flag set. When this Mapping is executed, it failed with the below error :

When the UD flag is unchecked, the mapping succeeds. The code is generated without  "AGG_STG"."<COLUMN_NAME>" when the above flags are set.

The mapping uses a customized Knowledge Module (KM). This KM uses substitution methods such as getTargetColList and getColList
     e.g.  <%=odiRef.getColList("", "[COL_NAME]\t[DEST_WRI_DT] null", ",\n\t", "","(UD1 or UD2 or UD3 or PK or UK or INS)")%>

Some of the target columns use UD2 flag checked and no other Key, Insert, Update flags checked.

Changes

Cause