My Oracle Support Banner

ODI 12c Generates Cascading Analytic Functions Which Result in ORA-30483 Error when Used in More than One Expression (Doc ID 2411438.1)

Last updated on JULY 30, 2024

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) user is attempting to create a mapping with two expressions where the first expression creates an attribute with an analytic expression (database function) and the second expression uses this to create another attribute with an analytic database function.

The following error occurs when attempting to execute the mapping:

 

Changes

 

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!

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