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.
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