Highlighted
Absent Member.. Absent Member..
Absent Member..
166 views

PPM Support Tip: Change Currency View within Financial Summary is not possible

KCS article: KM00713329


There is a problem with changing the currency code in some projects. These projects are created by an approved proposal. The Region of the proposal and the project is US. In these projects it is not possible to change the currency view in the financial summary.
Normally they should have the possibility to change the view between Euro (Standard currency) and in this case United States Dollar. But only the view Euro is available.
Tests performed on other environments shows there is no problem with this functionality for other projects.


Please run the following query to fix the problem:

update fm_financial_summary fs
set fs.currency_code =
(select currency_code
from kcst_currencies
where c.CURRENCY_ID =
(select R.CURRENCY_ID
from knta_regions r
where r.region_id = (select P.REGION_ID
from PFM_LIFECYCLE_PARENT_ENTITY plpe, pm_projects p
where PLPE.ACTIVE_ENTITY = 'Project' and PLPE.PROJECT_REQ_ID = P.PFM_REQUEST_ID
and PLPE.LIFECYCLE_ID = FS.PARENT_ID and P.PROJECT_NAME = 'Project for currencies')))
where FS.PARENT_ENTITY_ID = 526 and fs.PARENT_ID = (
select PLPE.LIFECYCLE_ID
from PFM_LIFECYCLE_PARENT_ENTITY plpe, pm_projects p
where PLPE.ACTIVE_ENTITY = 'Project' and PLPE.PROJECT_REQ_ID = P.PFM_REQUEST_ID
and P.PROJECT_NAME = '<project_name>'
);

replace <project_name> with issue project name.

Labels (1)
0 Likes
0 Replies
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.