Project and Portfolio Management Practitioners Forum
cancel

can not see a closed proposal's financial summary

Highlighted
riznad
Super Contributor.

can not see a closed proposal's financial summary

Hello;

I as admin can see financial summary on some projects and can not see at some others.

They are all the same kind of proposal and they are all closed

Here screen shots:

here the error:

 

second one with no error

 

do you have any idea how can I enable viewing financial summary for all proposals?

1 REPLY
Oscar_Pereira
Honored Contributor.

Re: can not see a closed proposal's financial summary

Hi,

 

Check the following table to make sure it has both financial summary name and financial summary id:

 

Select PRJ_FINANCIAL_SUMMARY_NAME , PRJ_FINANCIAL_SUMMARY_ID from KCRT_FG_PFM_PROJECT where PRJ_PROJECT_ID = <Project id shown in the browser URL>

 

We have seeing issues if one of those values are missing

 

Run this other SQL to verify the access related tables:

select *
from FM_FINANCIAL_SUMMARY fs, ITG_SECURABLE_ENTITIES ise, ITG_SECURITY_ACES isa,
ITG_ACCESS_CONTROL_ENTRIES iace
where fs.FS_ACL_ID = ise.SECURABLE_ENTITY_ID
and ise.ENTITY_TYPE_CODE = 'FINANCIAL_SUMMARY_ACL'
and isa.SECURABLE_ENTITY_ID = ise.SECURABLE_ENTITY_ID
and isa.ELT = iace.ACCESS_CONTROL_ENTRY_ID
and financial_summary_id = <>

 

There was one scenario that after upgrade the security related tables were empty... hence users did not have access to view the Financial summary

 

Regards

Oscar Pereira