I am able to solve it with
Execute Parameterised Query activity.
We need to write sql to execute function as below
select package_name.function_name ({1},{2},{3}) as COLUMN_NAME from dual;
we need to create non-persistent entity with member name same as COLUMN_NANE (should be in Caps).
and pass parameters to query .
return type will be list of Entity.