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 AUGUST 11, 2022

Applies to:

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

Symptoms

The customer is having an issue trying to create a Repository Contract for the same Supplier (vendor_id), but from different sites (vendor_site_id). They want to include two different sites in the same contract, but the system shows the error below. 

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

Steps
1. Attempt to add two different supplier sites to a Repository Contract.
2. Receive the error.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.