ODI 11g Smart Import does not Handle KM Options (Doc ID 2526623.1)

Last updated on APRIL 14, 2021

Applies to:

Symptoms

When Smart Importing an Interface into an Oracle Data Integrator (ODI) 11g environment, the values of the Knowledge Module (KM) options are not taken into account.

For reproducing the behavior:

1. In ODI environment <ODI 1>, have an Integration Interface that uses a Knowledge Module where options are set to values other then **Default**.
   
   For example:
   
        - INTERVAL_COMMIT:   true
        - ALLOW_DELETE:   false
           
2. Smart Export the Integration Interface above, and Smart Import into a new ODI 11g environment, <ODI 2>, where the Interface and used KMs do not exist yet.
   
   Observe the KM options are keeping their original values:
   
        - INTERVAL_COMMIT:   true
        - ALLOW_DELETE:   false
              
3. Edit the Integration Interface in <ODI 2>, and change the value of one of options:
   
        - INTERVAL_COMMIT:   true
        - ALLOW_DELETE:   true
   
   Apply the changes.
      
4. Re-smart Import into <ODI 2> the Interface exported at point #2 above.
   
   Observe that post import, the values of KM options above remain unchanged:
   
        - INTERVAL_COMMIT:   true
        - ALLOW_DELETE:   true
   
   ... while ODI should have imported / updated the KM options to the values it has in the environment from where the smart export has been extracted:
   
        - INTERVAL_COMMIT:   true
        - ALLOW_DELETE:   false

Changes

Cause

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