Error Occurs While Updating Active Quote With Alternate Lines

(Doc ID 2360567.1)

Last updated on FEBRUARY 13, 2018

Applies to:

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

Symptoms

When supplier is attempting to update existed main line in active quote, the following error occurs.

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[1 42114 1 10 ].
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1256)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1444)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2961)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2060)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:582)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:470)
at _pages.__oa._jspService(__oa.java:233)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
...........
## Detail 0 ##
oracle.apps.fnd.framework.OAException: oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[1 42114 1 10 ].
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1178)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1444)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2961)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2060)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:582)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:470)
at _pages.__oa._jspService(__oa.java:233)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)



-- Log File --

.
.
wf.plsql.WF_BES_CACHE.CacheValid.Check 1 Last upload time {} Last cache time {2017/09/28 16:58:54}
wf.plsql.WF_BES_CACHE.GetEventByName.Begin 2 Getting event details for {oracle.apps.fnd.framework.OAFatalError}
wf.plsql.WF_EVENT.dispatch.Begin 2 Dispatching event oracle.apps.fnd.framework.OAFatalError
wf.plsql.WF_EVENT.raise3.Begin 2 Event Name:oracle.apps.fnd.framework.OAFatalError Event Key:281506Maximum nested raise count:100Nested raise count: 0
wf.plsql.WF_EVENT.raise2.Begin 2 Event Name:oracle.apps.fnd.framework.OAFatalError Event Key:281506
fnd.framework.OAException 5 oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[1 26069 1 10 ].
fnd.framework.OAException 5 oracle.jbo.TooManyObjectsException: JBO-25013: Too many objects match the primary key oracle.jbo.Key[1 26069 1 10 ].
fnd.profiles.Profiles 2 getProfileOptionValue: name=FND_DIAGNOSTICS; levelID=10001; levelValue=0; levelValueApplID=0
fnd.profiles.Profiles 2 getProfileOptionValue: name=FND_DIAGNOSTICS; levelID=10002; levelValue=396; levelValueApplID=0
fnd.profiles.Profiles 2 getProfileOptionValue: name=FND_DIAGNOSTICS; levelID=10003; levelValue=51093; levelValueApplID=396
fnd.profiles.Profiles 2 getProfileOptionValue: name=FND_DIAGNOSTICS; levelID=10004; levelValue=17164; levelValueApplID=0
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): BEGIN
fnd.common.WebAppsContext 2 oracle.apps.fnd.common.WebAppsContext.getFNDGlobal(): END
.
.
fnd.profiles.Profiles 2 getProfileOptionValue: name=ICX_ACCESSIBILITY_FEATURES; levelID=10004; levelValue=17164; levelValueApplID=0
Exitoracle.apps.pon.util.SourcingCommonUtil.initPayTypePoplist 4 MessageText = null or '', Could not write message.
Enteroracle.apps.pon.util.SourcingCommonUtil.initPayTypePoplist 4 MessageText = null or '', Could not write message.
Exitoracle.apps.pon.response.creation.server.ResponseAMImpl.setupPayments 4 MessageText = null or '', Could not write message.
Exitoracle.apps.pon.util.SourcingCommonUtil.getPaymentRateTypeEnabled 4 MessageText = null or '', Could not write message.
Enteroracle.apps.pon.util.SourcingCommonUtil.getPaymentRateTypeEnabled 4 MessageText = null or '', Could not write message.
Enteroracle.apps.pon.response.creation.server.ResponseAMImpl.setupPayments 4 MessageText = null or '', Could not write message.
pon.response.creation.webui.BidPaymentsTableCO 3 OAF LOG: Event : Call Process Request, in: oracle.apps.pon.response.creation.webui.BidPaymentsTableCO: Entering Process Request
fnd.profiles.Profiles 2 getProfileOptionValue: name=FND_BRANDING_SIZE; levelID=10001; levelValue=0; levelValueApplID=0



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Supplier’s actions:
2. Find created RFQ
3. create quote: create line, create additional line ( Relation = alternate )
4. submit created quote.
5. While quote's status is 'Active' try to update existed main line in active quote:6. Push the “update” button.
6. A error occurs


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