My Oracle Support Banner

FILE_DEC_SEP Selector Used in ODI 12c LKM odiRef.GetSrcTablesList () Returns [FILE_DEC_SEP] (Doc ID 2585490.1)

Last updated on JUNE 12, 2023

Applies to:

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

Symptoms

In an Oracle Data Integrator (ODI) 12c File Datastore, if the decimal separator is not defined, the following substitution method returns the selector name surrounded by [] brackets instead of an empty / null string:

<%=odiRef.getSrcTablesList ("", "[FILE_DEC_SEP]", ", ", "")%>

Returns: [FILE_DEC_SEP]

If a decimal separator is not defined on the File Datastore, it is expected for ODI to return empty / nothing / null.

For reproducing the behavior:

  1. Create a File Datastore. Do not set a decimal separator.
  2. Create a Mapping that uses that Datastore as source.
  3. Create a LKM task that implements <%=odiRef.getSrcTablesList ("", "[FILE_DEC_SEP]", ", ", "")%>
  4. Run the Mapping, and observe the code ODI generates for the above LKM task.

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.