Accessing an ODI 12c Reusable Mapping from Mapping Link does not Allow Editing
(Doc ID 2707475.1)
Last updated on SEPTEMBER 03, 2020
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.200618 [Release 12c]
Information in this document applies to any platform.
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:
- Have a Mapping that is defined with one or more Reusable Mappings as source Datastores.
- Edit the Mapping. On the "Logical" tab, right-click and edit one of the Reusable Mappings.
- 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.
- 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.
- In the Reusable Mapping window, try to add some new Datastores, Filers, Joins, etc, and observe that this succeeds.
- 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.
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