My Oracle Support Banner

Someone Is Working on This Object Error When Modify Redline BOM Item in Parallel for 2 ECO (Doc ID 2259677.1)

Last updated on SEPTEMBER 05, 2024

Applies to:

Oracle Agile Product Collaboration - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
Error occurs when modify redline BOM item for 2 different ECO at parallel even when Affected Items Item is different.
Only Redline BOM item records are the same for 2 ECOs.

Error
3 type of errors are observed :

Error 1:

This object has been modified, please refresh and try again.


Error 2:

Someone is working on this object. Please try again later.


Error 3 (When SDK/Process Extension (PX) program is used):

Error code : 60104
Error message : See multiple root causes.
Root Cause exception : com.agile.common.client.value.BatchException

at com.agile.api.pc.APIObject.createError(APIObject.java:131)
at com.agile.api.pc.Table$UpdateRowsAction.doSdkAction(Table.java:1261)
at com.agile.api.common.SDKAction.run(SDKAction.java:23)
at com.agile.api.common.Security.doAs(Security.java:59)
at com.agile.api.common.Security.doAs(Security.java:109)
at com.agile.api.common.Security.doAs(Security.java:124)
at com.agile.api.pc.Table.updateRows(Table.java:171)
at og.regulation.AbstractType.addBOM(AbstractType.java:452)
at og.regulation.FoodEuropeType.calculate(FoodEuropeType.java:439)
at og.PxAction_RegulationResultCalculate.exe(PxAction_RegulationResultCalculate.java:407)
at og.PxAction_RegulationResultCalculate.doAction(PxAction_RegulationResultCalculate.java:129)
at com.agile.px.Extensions2$PXEventActionNode.invoke(Extensions2.java:746)
at com.agile.px.Extensions2.doCustomPXEvent(Extensions2.java:541)
at com.agile.px.Extensions2.invokeAction(Extensions2.java:247)
at com.agile.px.PxSessionBean.invokeAction(PxSessionBean.java:117)
....
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:585)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:488)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:385)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)



Step

  1. Create a PX to perform the following logic:
    On Affected Item, clear Redline BOM item and add 100 item record as Redline BOM (Number: AN0000000100-AN0000000199)
  2. Create 2 Item and assign to different ECO.
  3. Run PX on step 1 and add REDLINE BOM with 100 records.
  4. Release ECO
  5. Perform the same step 3 and step 4 to different ECO
  6. Create 2 new ECO and assign each item for each ECO.
  7. On each ECO, run PX on step 1 in parallel

 

Changes

 

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
Changes
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.