Expected Results :- Report completes Successfully.
Actual Results :- Report fails with “error filling report”
Additional Information :
ERROR: column "amount" does not exist
Where: PL/pgSQL function dwh_euro_triangulation_fct(character varying,character varying,numeric,character varying,timestamp without time zone) line 31 at assignment
SQL statement "SELECT EXCHANGERATEID,
CONVRATE,
CONVERTEDAMOUNT
FROM DWH_EURO_TRIANGULATION_FCT(v_FROMCURRENCY,v_TOCURRENCYCODE,v_AMOUNT,v_EXCHANGERATETYPEP,v_EFFECTIVEDATE)"
This is caused by DE56505
Clarity PPM 15.8.0 and PPM 15.8.1 on PostgreSQL
The defect is currently being analyzed by Engineering