Java Development Tools

Getting the following problem trying to do a findByKey for the purpose of updating a record (see below).

The findByKey throws a JBO-25013 for a key that I can guarantee 110% is unique.

FACILITYENTITYFEEPKGMBRKEY on FACILITYENTITYFEEPKGMBRTB is specified as a primary key in the DB, in the Entity, and in the view...it would be impossible to even insert a record with a duplicate primary key...so why am I getting a 25013 on findByKey trying to do a fetch?

If I run the query with the specified key in sqlplus I get a single record.

Any advice or solutions?

I'm running JDev 10.1.2.1.0 (Build 1913) with associated BC4J runtime along with JDK 1.5.10 and OC4J 10g (9.0.4.0.0) (build 040317.1838).

=======================JBO DEBUGOUTPUT BELOW==============

07/03/23 09:21:43 [179169] Bind params for ViewObject: FacilityentityfeepkgmbrtbFetchView
07/03/23 09:21:43 [179170] Clearing VO cache for FacilityentityfeepkgmbrtbView
07/03/23 09:21:43 [179171] Clear QueryCollection in cache for VO FacilityentityfeepkgmbrtbView
07/03/23 09:21:43 [179172] Column count: 20
07/03/23 09:21:43 [179173] OracleSQLBuilder Executing Select on: FACILITYENTITYFEEPKGMBRTB (false)
07/03/23 09:21:43 [179174] Built select: 'SELECT FACILITYENTITYFEEPKGMBRKEY, FACILITYENTITYFEEPKGKEY, RATEFEEBASEKEY, FEEPACKAGEGROUPIDENT, EQUALIZATIONPERIODOFFSET, EQUALIZATIONPERIODOFFSETCODE, APPLYASCONTRACTFEEIND, APPLYASTRANSACTIONCOSTIND, MATCHRATEFEEORGIND, EFFECTIVEDATETIME, EFFDTTIMEZONE, EXPIRYDATETIME, EXPDTTIMEZONE, BASETIMEZONE, CREATEBY, CREATEDATETIME, RECORDSTATUS, LASTMODBY, LASTMODDATETIME, VDBTAG FROM FACILITYENTITYFEEPKGMBRTB Facilityentityfeepkgmbrtb'
07/03/23 09:21:43 [179175] Executing FAULT-IN...SELECT FACILITYENTITYFEEPKGMBRKEY, FACILITYENTITYFEEPKGKEY, RATEFEEBASEKEY, FEEPACKAGEGROUPIDENT, EQUALIZATIONPERIODOFFSET, EQUALIZATIONPERIODOFFSETCODE, APPLYASCONTRACTFEEIND, APPLYASTRANSACTIONCOSTIND, MATCHRATEFEEORGIND, EFFECTIVEDATETIME, EFFDTTIMEZONE, EXPIRYDATETIME, EXPDTTIMEZONE, BASETIMEZONE, CREATEBY, CREATEDATETIME, RECORDSTATUS, LASTMODBY, LASTMODDATETIME, VDBTAG FROM FACILITYENTITYFEEPKGMBRTB Facilityentityfeepkgmbrtb WHERE FACILITYENTITYFEEPKGMBRKEY=:1
07/03/23 09:21:43 [179176] EntityCache:add ERROR - **more than one new rows with same primary key**
Mar 23, 2007 9:21:43 AM com.palmtreebusiness.edms.common.baseclasses.business.BaseErrorHandler handleError
SEVERE: An unknown error occured in AdvancedDataManager.save:JBO-25013: Too many objects match the primary key oracle.jbo.Key[15009 ].
oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[15009 ].
at oracle.jbo.server.EntityCache.add(EntityCache.java:579)
at oracle.jbo.server.EntityDefImpl.findFromDatabase(EntityDefImpl.java:1107)
at oracle.jbo.server.EntityDefImpl.findByPrimaryKey(EntityDefImpl.java:1136)
at oracle.jbo.server.QueryCollection.findByKey(QueryCollection.java:2899)