7 Replies Latest reply on Aug 3, 2016 3:14 PM by Bashar.

    R12.2.5 E-Business Suite Forms Redirects to database server

    Ramaraju

      Hi all,

      We have upgraded EBS 11i to R12.2.5.

      After login with application user, while click on responsibility, it is redirect to wrong server (database server).

      Example:

      R12 E-Business Suite Forms Login Redirects User to An Incorrect Start Page Instead of the Assigned Responsibility List (Doc ID 2113860.1)

      GL Super User, USA --> Journals --> Enter

      It redirect to "http://db-serverip:8008/dev60cgi/f60cgi?appletmode=nonforms&HTMLpageTitle=&HTMLpreApplet=&code=oracle/apps/fnd/formsClient/...."

      And port 8008 is another instance.

      Atcual url is: http://apps-serverip:8007

      We have 2 nodes, one is database and other one is applications.

       

      Please help on this issue.

       

      Thanks,

      Ramaraju

        • 1. Re: R12.2.5 E-Business Suite Forms Redirects to database server
          Bashar.

          Hi,

           

          Please post the output of the following queries:

           

          select node_name, node_mode, support_cp, support_web, support_admin, support_forms, support_db, status

          from FND_NODES;

           

          SELECT user_profile_option_name, name, level_set, context, value, last_update_date, last_updated_by

          FROM (

          SELECT   po.user_profile_option_name, po.profile_option_name name,

                   pov.level_id,

                   decode(pov.level_id,

                          10001, 'Site',

                          10002, 'Application',

                          10003, 'Responsibility',

                          10004, 'User',

                          10005, 'Server',

                          10006, 'Organization',

                          10007, 'ServResp',

                          'Undefined') LEVEL_SET,

                   decode(to_char(pov.level_id),

                          '10001', '',

                          '10002', app.application_short_name,

                          '10003', rsp.responsibility_key,

                          '10004', usr.user_name,

                          '10005', svr.node_name,

                          '10006', org.name,

                          '10007', (SELECT n.node_name from fnd_nodes n

                                    WHERE n.node_id=level_value2) ||'/'||

                                    (decode(pov.level_value, -1,'Default',

                                            (SELECT responsibility_key FROM fnd_responsibility

                                             WHERE responsibility_id = level_value))), pov.level_id) CONTEXT,

                   pov.profile_option_value VALUE,

                   pov.last_update_date,

                   usrlst.user_name last_updated_by

              FROM fnd_profile_options_vl po,

                   fnd_profile_option_values pov,

                   fnd_user usr,

                   fnd_application app,

                   fnd_responsibility_vl rsp,

                   fnd_user usrlst,

                   fnd_nodes svr,

                   hr_operating_units org

             WHERE usrlst.user_id =  pov.last_updated_by

               AND pov.application_id = po.application_id

               AND pov.profile_option_id = po.profile_option_id

               AND usr.user_id(+) = pov.level_value

               AND rsp.application_id(+) = pov.level_value_application_id

               AND rsp.responsibility_id(+) = pov.level_value

               AND app.application_id(+) = pov.level_value

               AND svr.node_id(+) = pov.level_value

               AND org.organization_id(+) = pov.level_value

           

          UNION ALL

           

          SELECT user_profile_option_name, profile_option_name name,

                 null level_id,

                 'Not Set' LEVEL_SET,

                 null CONTEXT,

                 null VALUE,

                 null last_update_date,

                 null last_updated_by

          FROM fnd_profile_options_vl p

          WHERE NOT EXISTS (SELECT 'x' FROM fnd_profile_option_values ov

                            WHERE p.profile_option_id = ov.profile_option_id)

          )

          WHERE name in ('APPS_WEB_AGENT','APPS_SERVLET_AGENT','APPS_JSP_AGENT','APPS_FRAMEWORK_AGENT','ICX_FORMS_LAUNCHER')

          ORDER BY name, level_id, value;

           

          Regards,

          Bashar

          • 2. Re: R12.2.5 E-Business Suite Forms Redirects to database server
            Ramaraju

            Hi Bashar,

            Please find the details below.

            1. select node_name, node_mode, support_cp, support_web, support_admin, support_forms, support_db, status

            from FND_NODES;

            2.

            Thanks,

            Ramaraju

            • 3. Re: R12.2.5 E-Business Suite Forms Redirects to database server
              TerryChen

              Hi Ramaraju,

               

                  Seems you need to check the HTML file and then run the autoconfig. then rebounce the service.

               

               

               

               

              BR

              Terry

              • 4. Re: R12.2.5 E-Business Suite Forms Redirects to database server
                Ramaraju

                Hi HTerry,

                Can you please provide the file name and location.

                 

                Thanks,

                Ramaraju

                • 5. Re: R12.2.5 E-Business Suite Forms Redirects to database server
                  Bashar.

                  Now it is clear why you experienced this problem!

                   

                  In 11i, the profile option "ICX: Forms Launcher" was set at the responsibility and user levels. At that time, the database server used to run the application, too.

                  During the upgrade, the value of this profile option was changed at the site level only, which is normal behavior.

                  You should delete the values assigned at user and resp. levels and the problem will be resolved.

                   

                  Old URL:

                  http://devr12upgdb.bluestarinc.com:8008/dev60cgi/f60cgi

                   

                  New URL:

                  http://devr12upgapp64.bluestarinc.com:8007/forms/frmservlet

                   

                  Regards,

                  Bashar

                  • 6. Re: R12.2.5 E-Business Suite Forms Redirects to database server
                    Ramaraju

                    Hi Bashar,

                    Thank you for the update. We  found 26 responsibilities and manually deleted values at responsibility level.

                    Is there any script to delete value at responsibility level?

                     

                    Thanks,

                    Ramaraju

                    • 7. Re: R12.2.5 E-Business Suite Forms Redirects to database server
                      Bashar.

                      It is not recommended nor supported to manipulate Oracle EBS tables using SQL commands. You should use the Profile Option Values form to make changes.

                       

                      Regards,

                      Bashar