Accessing an ODI 12c Reusable Mapping from Mapping Link does not Allow Editing (Doc ID 2707475.1)

Last updated on APRIL 09, 2021

Applies to:

Symptoms

Consider an Oracle Data integrator (ODI) 12c Mapping having one or more Reusable Mappings used as source Datastores.

When editing the Mapping, ODI gives the possibility to right-click on the Reusable Mapping, and edit it...

... which is very useful, especially in huge Projects and Folders, that contain many Reusable Mappings, and given this direct access, one avoids searching for the Reusable Mapping one wants to edit.

However, the Reusable Mapping accessed this way is only partially editable:

• One can add new Datastores and Components ( Filters, Aggregates, etc ) to the Reusable Mapping...
• But one can neither delete nor change / modify any of the existing Datastores, Attributes and Components ( Filters, Aggregates, etc )

Note that, in a similar way, objects can be directly accessed from Package steps.

However, editing one objects in such a way gives full **edit** control to the respective object.

Which appears not to be the case for Reusable Mappings.

The issue can be reproduced at will with the following steps:

1. Have a Mapping that is defined with one or more Reusable Mappings as source Datastores.
2. Edit the Mapping. On the "Logical" tab, right-click and edit one of the Reusable Mappings.
3. In the Reusable Mapping window, try to modify any or the existing Datastore Attributes, Filers, Joins, etc, and observe all are in **read-only** mode.
4. In the Reusable Mapping window, try to delete any or the existing Datastores, Datastore Attributes, Filers, Joins, etc, and observe all are in **read-only** mode.
5. In the Reusable Mapping window, try to add some new Datastores, Filers, Joins, etc, and observe that this succeeds.
6. Edit the same Reusable Mapping from the Project view > Folder > Reusable Mappings, and observe that each and all of actions attempted at steps #3, #4 and #5 above do succeed.

Cause

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