My Oracle Support Banner

Project - Key Members: Enter an Ex-Employee Within the Working Timeframe Errors: FRM-40735: ON-INSERT trigger raised unhandled ORA-01400 (Doc ID 2962423.1)

Last updated on AUGUST 04, 2023

Applies to:

Oracle Project Foundation - Version 12.0.0 and later
Information in this document applies to any platform.


When attempting to add to a Project a Key Member which is an ex-employee, the following error occurs on the form. The period selected for the Project assignment matches the timeframe when the employee was active and working, still the error is displayed.

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

1. Project responsibility > Projects, Templates Summary > Project, Templates

2. Query for a Project Number > Key Members

3. Try to add an ex-employee as a Key Member to the Project, being aware he/she was active and working for the whole 2022 year (example)

4. Select the period of time between 01-MAR-2022 - 30-MAR-2022 (example)

5. Observe error on the form

Note: you can verify the working period for the employee by using this query:


 Attempting to add new Key-Members to the Project as ex-employees for old periods of time.


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.