TooManyObjectsException Raised Inconsistently When Entering An Existing Key Value (Doc ID 1285493.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle JDeveloper - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 22-FEB-2013***

Symptoms

Suppose Master / Detail View Objects, eg Departments and Employees.

Suppose Department 10 includes Employee 200, and Department 20 includes Employee 201
(as in the HR demo schema).

When you navigate to Department 10 and enter an existing Employee in that Department, eg 200, you get a validation error

(oracle.jbo.TooManyObjectsException) JBO-25013: Too many objects match the primary key oracle.jbo.Key[200 ].

as soon as you leave the Employee Id field.
However, if you enter an Employee employed in another Department (eg Employee 201 from Department 20), you can leave the field without any error.

It's only when committing your changes that you are prompted with an error saying this Employee already exists:

(oracle.jbo.DMLConstraintException) JBO-26048: Constraint "DEPT_ID_PK" is violated during post operation "Insert" using SQL statement "INSERT INTO DEPARTMENTS(DEPARTMENT_ID,DEPARTMENT_NAME) VALUES (:1,:2)".

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms