Analytics Software

Hi Experts,

I have a Requirement in BI APPS Customization. Can you please explain anyone,how to use LISTAGG Function in odi mapping.

i have applied LISTAGGR function in odi mapping level,but i am getting below error.

ODI Mapping:ColumnName: ENAME      Expression: LISTAGG(EMP.ENAME,',')WITHIN GROUP(ORDER BY EMP.ENAME)

Error:

ODI-1240: Flow LIST_AGG_FUN_USAGE fails while performing a Integration operation. This flow loads target table EMP_BI.

ODI-1228: Task LIST_AGG_FUN_USAGE (Integration) fails on the target ORACLE connection scott_db.

Caused By: java.sql.SQLSyntaxErrorException: ORA-00937: not a single-group group function

Oracle Query:

If i used this sql query in Database its getting correct result.

SELECT DEPTNO,LISTAGG(ENAME,',')WITHIN GROUP(ORDER BY ENAME) FROM EMP GROUP BY EMP.DEPTNO;

Output:

Please give your valuable solutions,Thanks in advance.

Regards,

Raj