Error When Trying To Include Headquarters And Branch Supplier In The Same Contract(different Sites)

(Doc ID 2383501.1)

Last updated on APRIL 06, 2018

Applies to:

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

Symptoms

On : 12.2.4 version, Contract Expert

Error when trying to include Headquarters and Branch Supplier in the same contract(different sites)

We are 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:

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

Evidence of the issue are attached. The error occurs in any contract we try to include the same Supplier with different sites.
 

ERROR
-----------------------

oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. attempt to add 2 different supplier sites to a contract
2. receive error: oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key
 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add 2 supplier sites on the same contract

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