My Oracle Support Banner

PAXINEAG: When Creating A New Agreement, The Form Gives The Error: ORA-01403 No Data Found Error FRM-40735: ON INSERT Trigger Raised Unhandled (Doc ID 2846250.1)

Last updated on FEBRUARY 07, 2024

Applies to:

Oracle Project Billing - Version 12.2.10 and later
Information in this document applies to any platform.


When a new agreement is created in the Agreement form an error is encountered when saving.
The error happens after having searched for an existing agreement and the query does not find an existing one.

Steps to Reproduce

  1. Log into a Projects responsibility
  2. Navigate to Billing > Agreement
  3. Enter query mode using F11 or the Spyglass button on the form
  4. Enter an agreement number or another value on the form
  5. Execute the query with Ctrl-F11 or the spyglass on the form
  6. The form returns no results
  7. Create a new record
  8. Enter the new agreement information
  9. Save
  10. Error is encountered.




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

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