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

Question

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

Page 1 / 1

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,

Hi @ZTC ZTC JGOTA

i have updated that as well. yet no luck

Best Regards,

Rusiru

What about any Oracle Wallet?

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

Thanks @Shehan Chandrasekara

Reply

Rusiiiru · Accepted Answer

This issue is resolved by IFS Instance re-creating by clone backup.Thanks ​@Shehan Chandrasekara

ZTC ZTC JGOTA · Answer

Hello ​@RusiiiruCheck 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,

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded