10 Replies Latest reply on May 11, 2013 3:06 AM by 1008289

    Reprint/Republish Functionality Erroring out

    1008289
      Hi,

      I am getting the below error while trying to use the Reprint/Republish functionality for concurrent requests in my R12.1.3 system:-

      Error Page
      __________________________________________________________________________________________
      "You have encountered an unexpected error. Please contact the System Administrator for assistance. "


      Below are the steps to reproduce the issue:-

      1) Log into applications

      2) Navigate: Requests> View> Click Find Button

      3) Select the CM Request which has a viewer output available ie, Active Users Report

      4) Click on Tools, select Reprint/Republish

      Then it errors out instead of displaying the reprint/republish page. My EBS environment is R12.1.3 and DB version is 11.1.0.7 on RHEL 5.9. Any ideas on what's the issue is due to to fix it?

      Thanks
      bvp
        • 1. Re: Reprint/Republish Functionality Erroring out
          1008289
          I cleared the Java cache, temporary files, pop up blocker is disabled and checked in FireFox (my default browser is IE 9) but the issue persists.

          Thanks
          bvp
          • 2. Re: Reprint/Republish Functionality Erroring out
            shreevat
            Update the profile FND: Diagnostics to Yes at user level, reproduce the issue. You should get a link (click here) to view complete error stack. Post the error details then.

            Thanks
            Shree
            • 3. Re: Reprint/Republish Functionality Erroring out
              Hussein Sawwan-Oracle
              Can you find any errors in Apache/Database log files?

              Do you have any invalid objects in the database?

              Please see the following docs.

              Troubleshooting FNDREPRINT Framework in 11.5.10 [ID 330351.1]
              Reprint/Republish Page Not Functioning Correctly on All Desktops [ID 432691.1]
              The Reprint/Republish Functionality Does Not Work. [ID 436235.1]

              Thanks,
              Hussein
              • 4. Re: Reprint/Republish Functionality Erroring out
                1008289
                Thanks Shreevat for responding. I set the profile option FDN:Diagnostics to Yes and reproduced the problem but unfortunately it doesn't show any "click here" link.

                Thanks
                bvp
                • 5. Re: Reprint/Republish Functionality Erroring out
                  1008289
                  Thanks Hussein for responding. Other than file does not exist errors in the Apache log & Broken pipe errors in the oacore server log I don't see any errors. Yes there are invalids in the DB. Find below their list:-

                  OBJECT_NAME OBJECT_TYPE
                  ----------------------------------- --------------------
                  MSC_CL_PULL PACKAGE BODY
                  ASO_QUOTE_HEADERS_PVT PACKAGE BODY
                  FV_FACTS_TRANSACTIONS PACKAGE BODY
                  FV_FACTS_TBAL_TRANSACTIONS PACKAGE BODY
                  FV_BUDGET_DISTRIBUTION_HDR_V VIEW
                  ASO_OPP_QTE_PUB PACKAGE BODY
                  FII_AR_TRX_DIST_F_C PACKAGE BODY
                  ASO_SECURITY_INT PACKAGE BODY
                  ASO_QUOTE_PUB_W PACKAGE BODY
                  OKL_CONTRACT_BOOK_PVT PACKAGE BODY
                  FV_SF133_NOYEAR PACKAGE BODY
                  FV_SF133_ONEYEAR PACKAGE BODY
                  FV_FACTS_TBAL_TRX PACKAGE BODY
                  FV_FACTS_TRX_REGISTER PACKAGE BODY
                  ZX_TRX_DETAIL PACKAGE BODY
                  FV_SLA_AR_PROCESSING_PKG PACKAGE BODY
                  FV_SLA_CST_PROCESSING_PKG PACKAGE BODY
                  FV_SLA_PO_PROCESSING_PKG PACKAGE BODY

                  This invalids cropped up after the application Oracle recommended financials patches. I have a DEV environment from which the current environment was cloned and this functionality is working there. The above invalids are present in the DEV environment too. This is what has been done so far by me:-

                  1) Installed R12.1 and upgrade to R12.1.3 - DEV environment
                  2) Created a TEST environment from the DEV
                  3) Applied Oracle recommended Financials patches for CE,AP,GL,FA,IEX,ZX & IBY in both the environments.

                  I referred to the below documents:-

                  a) Display is set in the context_file to the same values (with the exception of hostname) in both the environments
                  b) Cleared cache/cookies and java cache and tried in a different browser but still doesn't work in TEST environment
                  c) W.r.t 330351.1 is it applicable to R12? I am not even able to get to the point of printing erroring out as the page itself is not coming up. All I am doing is this:-

                  1) Submit a Active users request
                  2) Navigate to Tools --> Reprint/Republish after the request completes.
                  3) Get an error page.

                  The Active users defintion is same in both the environments and both have the same printer set up.
                  • 6. Re: Reprint/Republish Functionality Erroring out
                    1008289
                    Shreevat,

                    After bouncing the managers I was able to get the "click Here" link. This is what it is showing:-

                    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select template_name, template_code,application_short_name, template_type_code from xdo_templates_vl where ds_app_short_name = :1 and data_source_code = :2 and template_status= 'E' and sysdate between start_date and nvl(end_date,sysdate)
                         at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
                         at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
                         at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3247)
                         at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)
                         at OA.jspService(_OA.java:228)
                         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 com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                         at java.lang.Thread.run(Thread.java:619)
                    ## Detail 0 ##
                    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
                         at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
                         at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
                         at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
                         at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
                         at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
                         at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
                         at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
                         at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
                         at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
                         at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
                         at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
                         at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
                         at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
                         at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
                    -------

                    Thanks
                    • 7. Re: Reprint/Republish Functionality Erroring out
                      Hussein Sawwan-Oracle
                      Please make sure you have the patch in (Connection Leaks From fndgfm (fndgfm.java, fndgfm.jsp, _fndgfm.java) [ID 1231393.1]) applied.

                      Please also verify Steps 3-6 in (Tools > Reprint /Republish Request Error JBO-27122: SQLError During Statement Preparation [ID 1258284.1]).

                      Thanks,
                      Hussein
                      • 8. Re: Reprint/Republish Functionality Erroring out
                        1008289
                        Hussein,

                        Thanks once again for responding. I applied the patch as mentioned in the note 1231393.1 but the issue persists. As regards the second note, as per step 3 the value of the parameter is "true" in my environment.

                        cat $CONTEXT_FILE | grep s_java_awt_headless
                        <java_awt_headless oa_var="s_java_awt_headless">true</java_awt_headless>

                        Thanks
                        bvp
                        • 9. Re: Reprint/Republish Functionality Erroring out
                          Hussein Sawwan-Oracle
                          Did you bounce the application services after applying the patch?

                          Please also see if the patch in (When Reprinting a Request No Default Values for Printer or Template Values [ID 1548274.1]) helps.

                          If you still have the same error, then I would suggest you log a SR.

                          Thanks,
                          Hussein
                          • 10. Re: Reprint/Republish Functionality Erroring out
                            1008289
                            Yes Hussein, I bounced the application after patching. I have logged an SR with Oracle.

                            Thanks
                            bvp