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 12.2.1.4.231215 to 12.2.1.4.231215 [Release 12c]
Oracle Data Integrator on Marketplace - Version 12.2.1.4.231215 to 12.2.1.4.231215
Information in this document applies to any platform.

Symptoms

After having applied Oracle Data Integrator (ODI) Bundle Patch 12.2.1.4.231215 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 12.2.1.4.231215, there is no value seen
    => In 12.2.1.4.230919, the value is seen


Changes

 

Cause

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.