My Oracle Support Banner

In Oracle Sourcing, Error Occurs When Changing the Setup Value for the Default Category - JBO-25013 on UNSOL_LINE_CAT_OVERRIDING (Doc ID 2802262.1)

Last updated on AUGUST 25, 2021

Applies to:

Oracle Sourcing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

In Oracle Sourcing, Release 12.2.9, an error occurs when the sourcing administrator is trying to change the setup value for the Default Category related to alternate lines.


Error

Error
oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[1021 PON UNSOL_LINE_CAT_OVERRIDING ].


Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Navigate to Sourcing Super User responsibility > Sourcing > Sourcing Home Page > Administration tab.
2. On the Negotiations Administration page, click the Negotiations Configuration link.
3. On the Negotiations Configuration page, in the "Should Award Approval be required for Auctions/RFQs?" region, the option "Yes, award approval is required before the negotiation is completed" is currently selected. Change the selection to "No, award approval is not required before the negotiation is completed".
4. Click the Apply button. An error message appears:

Error
Default Category for Alternate lines cannot be null when suppliers are not allowed to update the category when creating response.

5. Click Cancel and then navigate back to the Negotiations Configuration page again.
6. On the Negotiations Configuration page, scroll to the bottom of the page.
In the "Alternate Lines in Supplier Responses" region, enter the Default Category value and click the Apply button. An error message appears:

Error
oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[1021 PON UNSOL_LINE_CAT_OVERRIDING ].




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


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