TooManyObjectsException Raised Inconsistently When Entering An Existing Key Value
Last updated on AUGUST 04, 2016
Applies to:Oracle JDeveloper - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
***Checked for relevance on 22-FEB-2013***
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
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:
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