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: Invalid Transactions for Application Stuck at New

book

Article ID: 212736

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Some xogged transactions for applications are stuck in Invalid Transactions with 'New' status.

Logs are not showing any errors.

The PAC_IMP_TRANSIMPORT_HEADER table shows error 9010  with ERROR_CODE ORA-20878.

 

 

Cause

This normally means there is a null value somewhere.


Environment

All

Resolution

Check to make sure there is a valid Department and Location on the investment or if something else is missing in table
pac_mnt_projects.

The easiest way to compare a valid investment with on that is failing it to compare the two investments in pac_mnt_projects.

Additional Information

If the job is failing or the above does not resolve the issue also check article:

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



https://knowledge.broadcom.com/external/article?articleId=130919