My Oracle Support Banner

Data Management : EPMAgent Extracts are failing if Data Type having as CLOB or BLOB (Doc ID 2693363.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A to N/A [Release 11.1]
Information in this document applies to any platform.

Symptoms

On : NA version, Data Integration using EPMAgent

When attempting to extract data using EPMAgent from SQL Server , Data Load are failing with JavaNullPoint errors.

Observed that , EPMAgent query to extract the data from SQL Server and SQL Query having  LISTAGG function and it transforms values from a group of rows into a list of values that are delimited by a configurable separator.
LISTAGG is typically used to denormalize rows into a string of comma-separated values (CSV).

When Extracting data from SQL Query , the return type of LISTAGGis either VARCHAR or CLOB . Using the LISTAGG function in the SQL Query and list of values more than one , they Extract gets failed.
Means whenever LISTAGG converts data to CLOB then EPMAgent Extracts getting failed.

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!


In this Document
Symptoms
Changes
Cause
Solution


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