My Oracle Support Banner

PAXURVPS_R120: Unable to Export Huge Amount of Data: FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-01403 (Doc ID 2869189.1)

Last updated on MAY 16, 2022

Applies to:

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

Symptoms

When attempting to export a large amount of data from a Projects form(eg.Project Status Inquiry, PAXURVPS_R120), the form errors out.  The exporting is working for fewer data, but when trying to export multiple values the following error message appears:

ERROR
-----------------------

FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-01403

 

Reproducible steps:

  1. Go in Project Responsibility
  2. Navigate to Project Status Inquiry > Project Status Inquiry
  3. Enter criteria and click the button 'Enter'
  4. After data is displayed go in File > Export
  5. The error appears

 

Note: This may affect also other forms from Projects.

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


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