ODI 11g Generate DDL Requires a Completely New Name or a Numeric Value at the End
(Doc ID 2493761.1)
Last updated on FEBRUARY 13, 2019
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 to 220.127.116.11.2 [Release 11gR1 to 12c]
Information in this document applies to any platform.
In Oracle Data Integrator (ODI) 11g, the following error occurs when attempting to generate a new DDL Procedure if the name is not completely changed, or a numeric value is not used at the end of the name.
The issue can be reproduced at will with the following steps:
- Create DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
- Change Procedure Name from 'DDL <NAME> 001' to 'DDL <NAME> PROD' Generation Folder: <NAME>_SVN.First Folder
- Generate the DDL
- Create new DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
- DDL UI does not appear and the error message pops up
The issue does not occur with the following names:
- 'DDL <NAME>'
- '<NAME> DDL'
- 'DDL <NAME> 234'
- 'DDL <NAME> PROD 009'
Each of the above names will increment the trailing numeric value by 1, except '<NAME> DDL' which will not have a Numeric value at the end.
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