Financial reports failing in PostgreSQL DB when EUR currency is used

Article Id: 196084
Status: Published
Updated On: 29-07-2020 08:46
Products:
Clarity PPM SaaS
Issue/Introduction:

Financial Management Reports are failing when the Default system currency is EUR and the Report Currency is EUR
 
Steps to replicate:
  1. Create a Clarity System with EUR Currency as default.
  2. Financially enable the system.
  3. Configure the entity in System Options.
  4. Create a Project.
  5. Create cost plan, and populate cost plan with data.
  6. Submit the cost plan for Approval and approve the Cost Plan to get a budget plan.
  7. Run DWH Full Load.
  8. Run DWH Access Rights Job.
  9. After job completes, Navigate to Advanced Reporting.
  10. Navigate to View -> Repository -> CA PPM -> Reports -> Financial Management -> Financial Budget vs. Forecast by Period.
  11. Select the project created in step 4, select the Reporting currency as EUR.
  12. Run the Report.

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)"

 
 
Affected Financial management reports.

 
 
 

Cause:

This is caused by DE56505

Environment:

Clarity PPM 15.8.0 and PPM 15.8.1 on PostgreSQL

Resolution:

The defect is currently being analyzed by Engineering