1 2 Previous Next 27 Replies Latest reply on Jul 30, 2009 1:34 PM by Gauravv

    Request Details Screen attach to request id

    709751
      Hi,
      I have a requirement to show the complete details of the particular request when user click on request_id ( I just want to show only that particular request details).

      I have tried to use "OA.jsp?page=/oracle/apps/fnd/cp/viewreq/webui/CPReqDetailsStopPG" in destination URI (without quotes) but the screen is not coming properly ( it is showing request_id and status properly but not complete details) How can i achive this?

      Thanks,
        • 1. Re: Request Details Screen attach to request id
          498248
          Append &retainAM=Y.
          i.e. OA.jsp?page=/oracle/apps/fnd/cp/viewreq/webui/CPReqDetailsStopPG&retainAM=Y

          thanks,
          Kumar
          • 2. Re: Request Details Screen attach to request id
            709751
            Hi ,


            This solution is not working .. I am geting the same error.

            Thanks,
            • 3. Re: Request Details Screen attach to request id
              498248
              share your code..
              • 4. Re: Request Details Screen attach to request id
                709751
                Hi,
                Actually in code I have given destintaion URL as "OA.jsp?page=/oracle/apps/fnd/cp/viewreq/webui/CPReqDetailsStopPG&retainAM=Y" there is no other setup is done for this. I guess becase of that i failing to give make the page to refer the exact request id.

                So I have done one alternative option

                I have given the Destination function as FNDCPVIEWREQUEST&requestId=787880 ( for testing hard coding some request id.

                But i am getting an exception while i am opening the page saying




                Error Page
                Exception Details.
                oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at OA.jspService(_OA.java:71) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) 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:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392) at OA.jspService(_OA.java:80) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) 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.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) 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:595) ## Detail 0 ## java.lang.NullPointerException at oracle.apps.fnd.cp.viewreq.webui.ViewRequestsPageCO.processRequest(ViewRequestsPageCO.java:197) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at OA.jspService(_OA.java:71) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) 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:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392) at OA.jspService(_OA.java:80) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) 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.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) 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:595) java.lang.NullPointerException at oracle.apps.fnd.cp.viewreq.webui.ViewRequestsPageCO.processRequest(ViewRequestsPageCO.java:197) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAFlowLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at OA.jspService(_OA.java:71) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) 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:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392) at OA.jspService(_OA.java:80) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) 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.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) 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:595)

                Logout

                Copyright (c) 2006, Oracle. All rights reserved.
                • 5. Re: Request Details Screen attach to request id
                  Braj Pratap
                  Hi

                  one question ,up to now how u r trying to get the details on the basis of request id .

                  in destination URI ,u have to pass like this

                  OA.jsp?page=/oracle/apps/fnd/cp/viewreq/webui/CPReqDetailsStopPG&requstId={@Viewattribute_for_ request_id}retainAM=Y&addBreadCrumb=Y

                  1.) here u have to pass the request id for the next page co .
                  2.) in the process form request of next page co u need to exectute the VO query after setting the requstId in whereclauseparameters

                  thanx
                  Pratap
                  1 person found this helpful
                  • 6. Re: Request Details Screen attach to request id
                    709751
                    Hi,

                    CPReqDetailsStopPG is a standrad page so in my project i am not able to continue with editing the CO of that page.

                    I can see this page (CPReqDetailsStopPG ) is used in multiple places in oracle.

                    So i belive there must be some way to set the request id here

                    PFB The CO of this page, Please help.


                    // Source File Name: RequestDetailStopCO.java

                    package oracle.apps.fnd.cp.viewreq.webui;

                    import oracle.apps.fnd.common.VersionInfo;
                    import oracle.apps.fnd.framework.webui.OAControllerImpl;
                    import oracle.apps.fnd.framework.webui.OAPageContext;
                    import oracle.apps.fnd.framework.webui.beans.OAWebBean;
                    import oracle.apps.fnd.framework.webui.beans.nav.OALinkBean;

                    public class RequestDetailStopCO extends OAControllerImpl
                    {

                    public RequestDetailStopCO()
                    {
                    }

                    public void processRequest(OAPageContext oapagecontext, OAWebBean oawebbean)
                    {
                    super.processRequest(oapagecontext, oawebbean);
                    OALinkBean oalinkbean = (OALinkBean)oawebbean.findChildRecursive("ReturnToRequests");
                    String s = null;
                    Object obj = null;
                    s = (String)oapagecontext.getSessionValue("returnToRequestURL");
                    if(s != null && !"".equals(s))
                    {
                    if(oalinkbean != null)
                    {
                    oalinkbean.setDestination(s);
                    oalinkbean.setRendered(true);
                    }
                    } else
                    if(oalinkbean != null)
                    oalinkbean.setRendered(false);
                    }

                    public void processFormRequest(OAPageContext oapagecontext, OAWebBean oawebbean)
                    {
                    super.processFormRequest(oapagecontext, oawebbean);
                    }

                    public static final String RCS_ID = "$Header: RequestDetailStopCO.java 120.3.12010000.1 2008/07/25 07:59:48 appldev ship $";
                    public static final boolean RCS_ID_RECORDED = VersionInfo.recordClassVersion("$Header: RequestDetailStopCO.java 120.3.12010000.1 2008/07/25 07:59:48 appldev ship $", "oracle.apps.fnd.cp.viewreq.webui");

                    }
                    • 7. Re: Request Details Screen attach to request id
                      Abdul Wahid
                      Hi Aru,

                      As I know, Request submisson/ view functionality in SSWA is based on AK regions. Can you please try following URL.

                      OA.jsp?akRegionCode=FNDCPREQUESTVIEWREGION&akRegionApplicationId=<your application id>&requestID=<your reqeustID>

                      Abdul Wahid
                      • 8. Re: Request Details Screen attach to request id
                        709751
                        Hi,

                        OA.jsp?akRegionCode=FNDCPREQUESTVIEWREGION&akRegionApplicationId=661&requestID=789890
                        601 is the application id of the the application short name configured for jdev
                        789890 is a the request id

                        But i am getting following error message


                        Exception Details.
                        oracle.apps.fnd.framework.OAException: Region could not be found in AK_REGIONS; RegionCode: RegionApplicationId: -1
                        • 9. Re: Request Details Screen attach to request id
                          Gauravv
                          Hi,

                          Run this query and use the same akRegionApplicationId in url as the query returns

                          OA.jsp?akRegionCode=FNDCPREQUESTVIEWREGION&akRegionApplicationId=<>&requestID=789890

                          select region_application_id from ak_regions where region_code = 'FNDCPREQUESTVIEWREGION'

                          Thanks,
                          Gaurav
                          • 10. Re: Request Details Screen attach to request id
                            709751
                            Hi,
                            If i have given like this i will get the concurrent request screen. ( But this will display the details of all the requests)

                            But i need the details of the specific request only ( the same screen we used to get while we click on 'Details' in this screen)

                            means the page /oracle/apps/fnd/cp/viewreq/webui/CPReqDetailsStopPG

                            How can I achive this. Directly go to details screen ........
                            • 11. Re: Request Details Screen attach to request id
                              Gauravv
                              Hi,

                              I dont think you can go directly to that page.....


                              Thanks,
                              Gaurav
                              • 12. Re: Request Details Screen attach to request id
                                709751
                                Hi .. I am able to find that it is possible

                                OA.jsp?page=/oracle/apps/fnd/cp/viewreq/webui/CPReqDetailsStopPG&REQUESTID=998987&retainAM=Y&addBreadCrumb=Y"


                                only issue is that i have to give REQUESTID (all caps) instead of requestId or RequestId

                                Thank you all for the support.....
                                • 13. Re: Request Details Screen attach to request id
                                  Gauravv
                                  Thats great!!!!

                                  Thanks for the information...

                                  It will help everybody....

                                  Gaurav
                                  • 14. Re: Request Details Screen attach to request id
                                    709751
                                    Hi ... I have to do one more thing here ... I just want to make a message ( using OAMessageBoxBean) to show the request id in the first screen ( currently it is an item) but how can i show the request id and make the hyper link on request id as an information message?
                                    1 2 Previous Next