My Oracle Support Banner

After Applying Patch 36200839, "CUSTOM_TEMPLATE" Queries of "Extract Options" in Physical Tab of Mappings Are not Displayed (Doc ID 3011924.1)

Last updated on MARCH 22, 2024

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Oracle Data Integrator on Marketplace - Version to
Information in this document applies to any platform.


After having applied Oracle Data Integrator (ODI) Bundle Patch and applying one-off Patch 36200839, any values set in Extract Options "CUSTOM_TEMPLATE" are no longer visible and appear to be empty even though there are values. When executing mappings, there are no issues, and the invisible SQL statements are executed. in the option

To reproduce:

  1. Open Mapping
  2. Go to "Physical" Tab
  3. Select the Source Data Store
  4. In Properties, expand "Extract Options"
  5. Under "Options" notice the "CUSTOM_TEMPLATE"

    => In, there is no value seen
    => In, the value is seen




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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