ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Clarity PPM: XOG Transactions not being processed by the Post Transactions to Financials Job
Article ID: 130919
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
The Post Transactions to Financials job is failing on XOG transactions with the following generic error message in the BG logs:
ERROR 2019-04-15 15:28:51,492 [Dispatch Post Transactions to Financial : [email protected] (tenant=clarity)] niku.njs (clarity:admin:9689463__2840D314-1574-442B-AAC3-E6ED08DF2474:Post Transactions to Financial) Error executing job: 5031099 error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20878: -20669 - ORA-20669: -20669 - ORA-20669:
ORA-06512: at "SCHEMA.PAC_IMP_NPMTRANSIMPORT_SP", line 101
ERROR 2019-04-15 15:28:51,492 [Dispatch Post Transactions to Financial : [email protected] (tenant=clarity)] niku.njs (clarity:admin:9689463__2840D314-1574-442B-AAC3-E6ED08DF2474:Post Transactions to Financial) Error executing job: 5031099 error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20878: -20669 - ORA-20669: -20669 - ORA-20669:
ORA-06512: at "SCHEMA.PAC_IMP_NPMTRANSIMPORT_SP", line 101
Cause
The job fails because there is not a matching row in rate matrix associated with the project.
Environment
Release:
Component: ODTMM
Component: ODTMM
Resolution
1. Go to the Administration > Finance > Manage Matrix page
2. Select the matrix
3. Use the filter to check the resource or property needing to be validated for a matching rate.
If one does not exist, add a catchall row, a row denoted by selecting all * asterisks for the value.
4. Run the Post Transactions to Financials job.
Feedback
Yes
No
Powered by
