1 2 Previous Next 17 Replies Latest reply: Aug 8, 2014 10:46 AM by Chuggans-Oracle RSS

    ERPI opens blank landing page

    ragavhere

      Hi,

       

      I am using ERPI 11.1.2.2.300 to integrate Hyperion planning with Peoplesoft. I can load data. But when I drill down from planning data form or smartview it opens a blank ERPI landing page.

       

      The log has the following message.

       

      [2014-07-30T10:08:08.549-07:00] [ErpIntegrator1] [ERROR] [EPMERPI-104506] [oracle.apps.erpi.model] [tid: 13] [userId: <anonymous>] [ecid: 0000KU8F^PS7q2WzLwmJOA1Jp2JN00017y,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] No valid scenario could be found for the passed category:null

      I did take a look at this article 1561950.1 and verified my scenario dimension. It is tagged as Scenario dimension class.

       

      Regards,

      Ragav.

        • 1. Re: ERPI opens blank landing page
          Francisco Amores

          Have you tried reloading data again after changing it?

          • 2. Re: ERPI opens blank landing page
            ragavhere

            It was always tagged as scenario dimension. I havent changed it. In fact, it cant even change it. It is greyed out.

             

            Regards,

            Ragav.

            • 3. Re: ERPI opens blank landing page
              Francisco Amores

              Try the following:

               

              Navigate to Target Application > Dimension Details > click Refresh Metadata > Save

              Try again load + drill.

               

              Can you write what you have in table AIF_TARGET_APPL_DIMENSIONS for your Scenario dimension in your target application?

              • 4. Re: ERPI opens blank landing page
                ragavhere

                I have tried refreshing and reloading data. I cant still drill down.

                 

                Here is what is in AIF_TARGET_APPL_DIMENSIONS table for scenario dimension.

                 

                Scenario.jpg

                • 5. Re: ERPI opens blank landing page
                  Francisco Amores

                  Have you checked that your category mappings are correctly configured?

                  • 6. Re: ERPI opens blank landing page
                    ragavhere

                    Yes. I have only one category mapping. It was working earlier. Suddenly it stopped working.

                     

                    Category.jpg

                    Regards,

                    Ragav

                    • 7. Re: ERPI opens blank landing page
                      Francisco Amores

                      It seems that your configuration is correct.

                       

                      Have you tried to set Scenario dimension class to Generic? Just to test what you get.

                       

                      I would suggest raising SR with OCS so they can help you with further research.

                       

                      Regards

                      • 8. Re: ERPI opens blank landing page
                        ragavhere


                        No. It is not changeable and I have not change the scenario dimension class.

                         

                        I have raised an SR with oracle. But I hardly get an update.

                         

                        Regards,

                        Ragav.

                        • 9. Re: ERPI opens blank landing page
                          Chuggans-Oracle

                          Hi Ragav,

                           

                          The ERPI 11.1.2.2 admin guide says that 'The target category is the Scenario dimension in the application' but in your screenshot you've got Target Category mapped to Actual. Are you sure that this hasn't been accidentally modified if this was working in the past?

                           

                          Could you please try changing your category mapping to point to the name of the Scenario dimension for the target category, run a data load again and then try drilling back.

                           

                          Regards

                           

                          Craig

                          • 10. Re: ERPI opens blank landing page
                            ragavhere

                            Actual is the scenario dimension member that I want to load data to. I dont know whats wrong. I have the same set up in Test environment. it works there. But in Dev, it does not work. I changed category as below. Still it does not work. I have defined the application mapping too.

                             

                            Global category mapping.jpg

                            Application category mapping.jpg

                            Regards,

                            Ragav.

                            • 11. Re: ERPI opens blank landing page
                              Francisco Amores

                              Can you paste the drill through log entries produced in ERPIntegrator0.log when you drill-through from HP?

                              • 12. Re: ERPI opens blank landing page
                                ragavhere

                                Here is the log. It picks all the parameters. Still cannot understand why it will open blank page.

                                 

                                [2014-08-04T15:00:12.765-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.ui] [tid: 18] [userId: <anonymous>] [ecid: 0000KUZ2NZT7q2WzLwmJOA1JrxXc00006u,0] [SRC_CLASS: jsp_servlet._modules._com._hyperion._aif._gl._drilldown.__adf] [APP: AIF#11.1.2.0] [SRC_METHOD: _jspService] param context:?attribute1=system.ds.planning&amp;attribute2=app.ds.PLPLAN&amp;attribute3=cluster.ds.PLANNING_LWA&amp;attribute4=database.ds.PL&amp;attribute5=Account.id.098621&amp;attribute6=Year.id.FY14&amp;attribute7=Period.id.Feb&amp;attribute8=Scenario.id.Actual&amp;attribute9=Version.id.Final&amp;attribute10=Project.id.No+Project&amp;attribute11=State.id.VA&amp;attribute12=Entity.id.R420-999&amp;attribute13=Product.id.19210&amp;attributeCount=13

                                [2014-08-04T15:00:13.007-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] START -

                                [2014-08-04T15:00:13.009-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[0] = system.ds.planning

                                [2014-08-04T15:00:13.009-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[1] = app.ds.PLPLAN

                                [2014-08-04T15:00:13.010-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[2] = cluster.ds.PLANNING_LWA

                                [2014-08-04T15:00:13.010-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[3] = database.ds.PL

                                [2014-08-04T15:00:13.010-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[4] = Account.id.098621

                                [2014-08-04T15:00:13.010-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[5] = Year.id.FY14

                                [2014-08-04T15:00:13.011-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[6] = Period.id.Feb

                                [2014-08-04T15:00:13.011-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[7] = Scenario.id.Actual

                                [2014-08-04T15:00:13.011-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[8] = Version.id.Final

                                [2014-08-04T15:00:13.011-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[9] = Project.id.No Project

                                [2014-08-04T15:00:13.012-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[10] = State.id.VA

                                [2014-08-04T15:00:13.012-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[11] = Entity.id.R420-999

                                [2014-08-04T15:00:13.012-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] attribute[12] = Product.id.19210

                                [2014-08-04T15:00:13.013-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] Application Name:PLPLAN

                                [2014-08-04T15:00:13.013-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] Target Application Type:HPL

                                [2014-08-04T15:00:13.013-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] Database Name:PL

                                [2014-08-04T15:00:13.015-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] ERPI Target Application Name:PLPLAN

                                [2014-08-04T15:00:13.015-07:00] [ErpIntegrator1] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] ERPI Plan Type:PLAN2

                                [2014-08-04T15:00:13.021-07:00] [ErpIntegrator1] [ERROR] [EPMERPI-104506] [oracle.apps.erpi.model] [tid: 33] [userId: <anonymous>] [ecid: 0000KUZ2Nad7q2WzLwmJOA1JrxXc00006x,0] [SRC_CLASS: com.hyperion.aif.gl.drilldown.model.applicationModule.DrillDownAMImpl] [APP: AIF#11.1.2.0] [SRC_METHOD: drillDown] No valid scenario could be found for the passed category:null

                                 

                                Regards,

                                Ragav.

                                • 13. Re: ERPI opens blank landing page
                                  ragavhere

                                  Hi,

                                   

                                  I deleted all the mappings and target application and recreated everything. Now I can drill down from planning forms. But in FR and smartview I cannot drill down if I use essbase connection. But works if I use planning connection.

                                   

                                  Regards,

                                  Ragav.

                                  • 14. Re: ERPI opens blank landing page
                                    Francisco Amores

                                    Hi,

                                     

                                    happy to hear you solved your issue.

                                     

                                    Please mark this question as answered so others can see its feedback.

                                     

                                    For the other issue, I would recommend opening a new thread.


                                    Regards

                                    1 2 Previous Next