I have an issue. I sometimes have resource managers fail to enter all financial information in for their Resources or Roles.
The issue is that this sometimes causes the Rate Matrix Extraction job to fail. Is there a query or way to find the missing value from a Resource or Role?
If you can provide the exact error message when the job fails, it will help to find any existing tec docs we have.
It all depends on what financial info you are trying to find.
pac_mnt_resources and pac_mnt_projects are the 2 tables holding the financial values of the resource and projects. Note: This table will have a record of the project/resource only if they are financially enabled atleast once.
prteam - to check for the project role
prassignment - to check for the assignment role.
Depending on what info you are looking for, I can give you more tables.
This error does not give much detail. I would like to find a query that would give me some detail about what is missing. My customers do not always remember what was missed and as a system admin, it would be helpful to be able to find any missing data and direct them to fix it.
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in CMN_JOB_RATE_MATRIX_SP - ORA-20000: Error in NBI_PROJ_RATES_AND_COSTS_SP - Calling PPA_GETRATE_WITHROLE: ORA-01403: no data foundORA-06512: at "NIKU.CMN_JOB_RATE_MATRIX_SP", line 15ORA-06512: at line 1
I can see a bug reported against this error message - DE33410
This BUG is fixed in the upcoming PPM version(15.3).
If you are already on 15.1 or 15.2 and if you feel this issue is critical to your business, I would request you to please log a Support case and Engineering will decide if they can backport this to 15.1 or 15.2.