My Oracle Support Banner

ODI Substitution API 'getInfo("SRC_SCHEMA")' in KM Step Target Command Displays File Description if FILE Technology (Doc ID 2628045.1)

Last updated on JANUARY 14, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.4.0, a customized Knowledge Module (KM) loading data into a file target and having a step with <%=odiRef.getInfo("SRC_SCHEMA")%> returns the source schema correctly. However, it also returns the description of the target file in cases where the command is used in target. It is expected to only return the source schema.

The following is an example of what is seen, where only <SRC_SCHEMA_NAME> should be returned:

<SRC_SCHEMA_NAME>
/*$$SNPS_START_KEYSNP$CRDWG_TABLESNP$CRTABLE_NAME=<FILE_DESCRIPTION_OF_TARGET>$$SNPS_
END_KEY*/

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

  1. Create a mapping with Oracle as source and file as target
  2. Create a customized IKM
  3. Add a step similar to the following:
    Name: <STEP_NAME>
    target command: <%=odiRef.getInfo("SRC_SCHEMA")%>
  4. Execute the mapping in simulation mode with level 6

The issue only occurs when using <%=odiRef.getInfo("SRC_SCHEMA")%> as target command. When using in source command, only the Oracle schema is returned as expected.

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!


In this Document
Symptoms
Cause
Solution
References


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