Tuesday, September 13, 2011

Cash Positioning Issue

Hi All.


When attempting to Cash Positioning: Existing worksheet go button
the following error occurs an error:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122



Step to reproduce:
Go to CM responsibility --> Cash positioning



Press "Go" button

Got the following error: You have encountered an unexpected error. Please contact the System Administrator for assistance

After changing FND: Diagnostics profile to YES, I can see the full error:
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT WorksheetHeadersEO.WORKSHEET_HEADER_ID, 
WorksheetHeadersEO.WORKSHEET_NAME,
WorksheetHeadersEO.COLUMNS_DISPLAYED,
WorksheetHeadersEO.CREATED_BY,
decode(WorksheetHeadersEO.CREATED_BY,
1, 'DeleteDisabled',
'DeleteEnabled') DELETE_SWITCHER,
decode(WorksheetHeadersEO.CREATED_BY,
1, 'UpdateDisabled',
'UpdateEnabled') UPDATE_SWITCHER
FROM CE_CP_WORKSHEET_HEADERS WorksheetHeadersEO) QRSLT  WHERE (EXISTS (SELECT 1 FROM ((SELECT 1 FROM CE_CP_WS_BA_V WBA WHERE WBA.worksheet_header_id = QRSLT.worksheet_header_id AND WBA.xtr_user_flag = 'N')UNION ALL (SELECT 1 FROM CE_CP_WORKSHEET_LINES WL WHERE WL.CASHPOOL_ID IS NOT NULL)))) ORDER BY WORKSHEET_NAME
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:750)
at oracle.apps.ce.cashpositions.webui.WorksheetSearchCO.processFormRequest(WorksheetSearchCO.java:130)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:810)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1159)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2700)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
at _oa__html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:662)
## Detail 0 ##
java.sql.SQLException: ORA-00904: "QRSLT"."WORKSHEET_HEADER_ID": invalid identifier

Action plan:
1.  Please download and review the readme for Patch 4715697 .
2. Please apply Patch 4715697 in a TEST environment.
3. Please confirm the following file versions:
ce java/cashpositions/server WorksheetSummaryVOImpl.java 115.7
4. Restart apache server and clear the apache cash
5. Please retest the issue.

Good luck ...


2 comments:

  1. Quantum Binary Signals

    Professional trading signals sent to your mobile phone every day.

    Follow our signals NOW and gain up to 270% a day.

    ReplyDelete
  2. BlueHost is ultimately one of the best website hosting company for any hosting plans you need.

    ReplyDelete