My Oracle Support Banner

"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:

Oracle Data Integrator - Version to [Release 12c]
Oracle Data Integrator on Marketplace - Version to
Information in this document applies to any platform.


Using Oracle Data Integrator, 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.