"PLS-00201: Identifier GET_MODEL_NAME Must Be Declared" Error when Running an ODI 12c Mapping that Has Been Migrated from OWB
(Doc ID 2036794.1)
Last updated on JUNE 14, 2023
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 and later
Oracle Warehouse Builder - Version 22.214.171.124 and later
Information in this document applies to any platform.
In an OWB mapping the get_model_name variable is used in a pre-mapping to get the mapping name loaded into the target. When OWB generates PL/SQL, this variable get_model_name is substituted by the mapping name as expected.
This works fine in OWB. However, after migrating the mapping to ODI, running the map in ODI fails with:
Migration of OWB to ODI.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!