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