Skip to main content
Solved

After oracle 12c to 19c upgrade PLSQL Access Provider is red


Rusiiiru
Sidekick (Partner)
Forum|alt.badge.img+8

Hi Team,

 

after oracle 12c to 19c upgrade we are getting below error from PLSQL Access provider

ORA-20105: PlsqlapServer.ERRINV: Failure while obtaining result: javax.ejb.EJBException: EJB Exception: : java.lang.IllegalStateException: Unmatched calls to mark/reset on ResetableMap.
  at ifs.fnd.util.ResetableListMap.reset(ResetableListMap.java:161)
  at ifs.fnd.sf.storage.FndFilterMap.reset(FndFilterMap.java:171)
  at ifs.fnd.sf.storage.FndAbstractHandler.afterCall(FndAbstractHandler.java:196)
  at ifs.application.fndconnectframework.FndConnectHandlerWrapper.invokeBizApi(FndConnectHandlerWrapper.java:95)
  at ifs.application.fndconnectframework.FndConnectHandlerBean.invokeBizApi(FndConnectHandlerBean.java:110)
  at sun.reflect.GeneratedMethodAccessor355.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)
  at ifs.fnd.sf.j2ee.FndAbstractBean.aroundInvoke(FndAbstractBean.java:148)
  at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:94)
  at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationConte
ORA-06512: at "IFSAPP.PLSQLAP_SERVER_API", line 815

 

Can someone from community help us to resolve this? This is Apps 10

 

Best Regards,

Rusiru
 

Best answer by Rusiiiru

This issue is resolved by IFS Instance re-creating by clone backup.

 

Thanks ​@Shehan Chandrasekara 

View original
Did this topic help you find an answer to your question?

4 replies

ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • 219 replies
  • March 13, 2025

Hello ​@Rusiiiru 

 

Check that your ORACLE path is well set up to the the newest Oracle version. 

 

I kind remember having the same issue you have and I believe I fixed this way.

 

It is something with your Oracle path pointing to the 19c version you just upgraded.

 

Thanks,


Rusiiiru
Sidekick (Partner)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • 39 replies
  • March 13, 2025

Hi ​@ZTC ZTC JGOTA 

 

i have updated that as well. yet no luck

 

Best Regards,

Rusiru


ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • Hero (Customer)
  • 219 replies
  • March 13, 2025

What about any Oracle Wallet?


Rusiiiru
Sidekick (Partner)
Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • 39 replies
  • Answer
  • March 14, 2025

This issue is resolved by IFS Instance re-creating by clone backup.

 

Thanks ​@Shehan Chandrasekara 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings