"Object 'AGG_STG' Does Not Exist." Error when Testing an ODI Scenario With UD Flag
(Doc ID 2721082.1)
Last updated on OCTOBER 19, 2020
Applies to:Oracle Data Integrator - Version 220.127.116.11.200413 and later
Information in this document applies to any platform.
Using Oracle Data Integrator 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document