My Oracle Support Banner

"Too Many Objects Match The Primary Key" Error When Adding The Same Supplier With Different Sites (Doc ID 2420861.1)

Last updated on JULY 09, 2018

Applies to:

Oracle Procurement Contracts - Version 12.2.4 and later
Information in this document applies to any platform.


The customer is having an issue trying to create a contract for the same Supplier (vendor_id), but from different sites (vendor_site_id). We need to include 2 different sites in the same contract but the system shows the error below. The error occurs in any contract when the customer tries to include the same Supplier with different sites.

oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[23274 SUPPLIER_ORG 3422 ]

The issue can be reproduced at will with the following steps:
1. Attempt to add 2 different supplier sites to a contract
2. Receive the error




To view full details, 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 a vibrant support community of peers and Oracle experts.