Note : Already checked forum, it is not answered there in any of the threads.
https://forums.oracle.com/ords/apexds/domain/dev-community?s=odi-26211
Issue:
The package is not functioning with the mapping. Simple mapping can be run without adding it to the package, but I need to save it with a different name every time. If I use the same mapping in the package, an error message appears saying that the mapping name is not unique.
I have altered the name of the mapping as well.
Error:
java.lang.RuntimeException: oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access.
ODI-10182: Uncategorized exception during repository access.
ODI-26211: Mapping name is not unique.
Temporary workaround:
This is not a proper way to fix this; it's only a temporary solution. I have found that if we delete the old repository and create new repositories(Master/work) with the same DBA username and schema, the error will go away. Then changing names is not necessary to save mappings. The package is able to run without any mapping name errors
Need a proper solution to this.