XOG Transactions not being processed by the Post Transactions to Financials Job

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:session: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
 

Environment

Release: All

 

Cause

The job fails because there is not a matching row in rate matrix associated with the project.

 

Resolution

Run query:
select * from IMP_TRANSACTIONIMPORT
where importstatus = 'N'
and transdate between 'DD-MMM-YYYY' and 'DD-MMM-YYYY
order by importdate desc

A. Review the project code and what type of resource(Labor, Material, Exp, Equip) and make sure a rate matrix exists for it.

B. Check if a rate row exists for the record:

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.