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 OCTOBER 19, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.4.200413 and later
Information in this document applies to any platform.

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.

Cause

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
Symptoms
Cause
Solution
References


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