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 SEPTEMBER 15, 2022

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.


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.




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

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