My Oracle Support Banner

PAXTREPE Expenditure Review Form Errors Adding Expenditure Items To Batch - ORA-01403: no data found FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01400 (Doc ID 2708951.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

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

Symptoms

Unable to add expenditures items to existing pre-approved batch.

ORA-01403: no data found

--------------------------------------------------------------
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01400.

Steps:

1. Create new Pre-Approved batch.
2. Navigate to Review form
3. Query batch
4. Press Open button
5. Press Expenditures button
6. Enter New Expenditure line
7. Enter expenditure item details
8. Save - error

However if you query the batch via navigating Expenditures -> Pre Approved
Batches -> Enter you can add a new expenditure without error.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.