My Oracle Support Banner

Unable to Update Transactions in Review Transactions (PAXTRIMP) - ORA-01403: no data found FRM-40735: WHEN-VALIDATE-RECORD trigger raised unhandled exception ORA-04062 (Doc ID 1613518.1)

Last updated on OCTOBER 29, 2018

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

There are several transactions stuck in Projects interface that will not process.
Project Cost Super User -> Expenditures -> Transaction Import -> Review Transactions
The error says, "The item date is not within the task active dates," but the project/task it is open for the transaction date.
When trying to initiate a change to the record so it would get picked up again for processing, the following error is returned:
"ORA-01403: no data found FRM-40735: WHEN-VALIDATE-RECORD trigger raised unhandled exception ORA-04062."

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.