ISSUE 1
=======
We have upgraded 11.5.9 application to 12.1.3 ,we are experiencing that many OAF pages are giving exception "FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE =
oracle.jbo.InvalidObjAccessException: JBO-25036: An invalid object operation was invoked on type View Object with name FndApplicationVO_20;"
There are no specific OAF page having this issue and also when this issue is happening the other page from different or same application is opening .
The issue disappears after bouncing the middle tier(OPMN services)
We need a permrnent fix to this solution as we are going to have QA and production on this setup.
We have 2 node Apps tier (Shared APPL Top) and two node database (in 11gR2 RAC)
The detail exception details are as follow:
Exception Details.
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.InvalidObjAccessException: JBO-25036: An
invalid object operation was invoked on type View Object with name FndApplicationVO_20;
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1247)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2195)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
at _OA._jspService(_OA.java:212)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
at _RF._jspService(_RF.java:225)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClien
SOLUTION 1
===========
A) How To Resolve Error JBO-25036 Invalid Object with FndApplicationVO_1627? [ID 786062.1]
1. List the current status:
$INST_TOP/admin/scripts/adopmnctl.sh status
2. Bounce OACore:
$INST_TOP/admin/scripts/adoarorectl.sh stop
$INST_TOP/admin/scripts/adoarorectl.sh start
3. Bounce Apache:
$INST_TOP/admin/scripts/adapcctl.sh stop
$INST_TOP/admin/scripts/adapcctl.sh start
<< NOT ACCEPTABLE as can not bounce middle tier each and every time>>
FROM Oracle ADF Business Components Error Messages [ID 137422.1] >>
"JBO-25036: InvalidObjAccessException
Cause: An application invoked an object operation that is not supported in the object's current state.
Action: Remove the invalid operation invocation or provide exception handling logic."
"This means that you're trying to work with a ViewObject that has been removed (through a call to remove()).
In other words, the VO that you're trying to access is dead.
This may occur if you hold onto a VO and try to work with it after the AM is checked into the AM pool."
Earlier similar bugs without solution >>
Bug 9844155: OPENING FUNCTION IN FORMS CAUSING ORACLE.JBO.INVALIDOBJACCESSEXCEPTION:JBO-25036
A Stateless Session Bean Using EJB 3.0 and ADF Business Components Returns "null" upon second invocation. [ID 1078326.1]
ISSUE 2
=======
ORA-03113 "end-of-file on communication channel" Issues
Observing frequent "ORA-03113 "end-of-file on communication channel" errors for client sessions.
This behaviour is observed from client session from TOAD or Oracle Apps Form session.
SOLUTION 2
=========
I'd like for you to try to workaround this issue with the SQLNET.EXPIRE_TIME setting at the server.
This parameter will enable a feature where a 10 byte probe packet will be sent from server to client after <n> minutes of idle time.
The probe packet appears as traffic on the wire and can act as a keepalive mechanism for long standing idle connections.
Here's a reference on the subject:
Resolving Problems with Connection Idle Timeout With Firewall (Doc ID 257650.1)
This is a sqlnet.ora file parameter. You can create a sqlnet.ora file using any text editor.
First we have to establish where the listener is referencing .ora files.
If you're using a $TNS_ADMIN directory for the listener, that's where the sqlnet.ora file should be created.
Else, create it in $ORACLE_HOME/network/admin. That would be the GRID home if that's where the listeners are running.
1) Add this parameter:
SQLNET.EXPIRE_TIME=10
2) Once this is in place, issue:
LSNRCTL>set current_listener <listener_name>
LSNRCTL>reload
Do this for ALL listeners that service connections to the databases so that the parameter is referenced.
3) Once these steps are complete, try the connection that sits idle for an hour and report the result.
4) If the failure persists, please provide this output:
LSNRCTL>set current_listener LISTENER_SCAN<n>
LSNRCTL>set displaymode verbose
LSNRCTL>services
Do this for listeners SCAN1 through SCAN3.
ISSUE 3
=======
Delay in new responsibility to appear in the R12 Navigator Page
In our R12.1.13 system when we add a new responsibilty to a user it is taking long time to appear in the R12 Navigator Page.
- Responsibility is added by standard process (FNDSCAUS –Security-->Users-->Define))
- Responsibility can be accessed if we go into some other responsibility and then use 'switch responsibility' BUT new responsibility is not visisble on the R12 home page navigation for approx 1.5 to 2 hrs.
SOLUTION 3
=========
SR 3-5491236961
After Clearing the middle tier cache by following steps and logoff-logn again we can see the new responsibility in the home page.
---------------------------------
- go to "Functional Administrator" responsibility
- select Core Services => Caching Framework => Global Configuration => Clear all cache
-----------------------------------
Other observations :
===============
A. In 12.1.1 you do not have to run the 'Synchronize WF Local Tables' any more - all of the user roles and changes via the functional process - is processed by a business event in WF Java Deferred the Workflow Agent listeners process them and all of the user role information is stored in the Workflow Directory Services tables now.
B. The 'Workflow Directory Services User Role Validation' - syncs the users back if a date is not updated or does not match the master table.
You DO NOT have to run this on a reoccuring basis.
C. Sync responsibility role data into the WF table >>>> obsoleted in R12 (Concurrent Processing - Concurrent Program "Sync Responsibility Role Data Into The WF Table" errors: Cannot Find File affurg02.sql [ID 727534.1])
Oracle Support - 23 March 2012 20:50:55 GMT+05:30 [Notes]
Please do the following simple test
This will determine if this is a WF even not firing fast enough or a caching issue
Please add a new resp to a user
Please get output of WFDS Data Collection Script (Doc ID 742062.1) for the user with the new resp
Also, please provide your current Oracle Application Server version
ISSUE 4
=======
SOLUTION 4
=========
ISSUE 5
=======
SOLUTION 5
=========
ISSUE 6
=======
SOLUTION 6
=========
ISSUE 7
=======
SOLUTION 7
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========
ISSUE
=======
SOLUTION
=========