Queries related to concurrent programs, request sets and programs attached to responsibilities

SQL Query to find Request Set for the given concurrent program

SELECT

   DISTINCT  user_request_set_name

FROM

    fnd_request_sets_tl rs,

    fnd_request_set_programs rsp,

    fnd_concurrent_programs_tl cp

WHERE

    rsp.concurrent_program_id = cp.concurrent_program_id

    AND   rs.request_set_id = rsp.request_set_id

    AND   upper(user_concurrent_program_name) = upper('Program name') 

Query to find the list of responsibilities to which the concurrent program is attached 

SELECT frt.responsibility_name, frg.request_group_name,frgu.request_unit_type,frgu.request_unit_id,

    fcpt.user_concurrent_program_name

    FROM fnd_Responsibility fr, fnd_responsibility_tl frt,

    fnd_request_groups frg, fnd_request_group_units frgu,

    fnd_concurrent_programs_tl fcpt

    WHERE frt.responsibility_id = fr.responsibility_id

    AND frg.request_group_id = fr.request_group_id

    AND frgu.request_group_id = frg.request_group_id

    AND fcpt.concurrent_program_id = frgu.request_unit_id

    AND frt.LANGUAGE = USERENV('LANG')

    AND fcpt.LANGUAGE = USERENV('LANG')

    AND fcpt.user_concurrent_program_name = :conc_prg_name

    ORDER BY 1,2,3,4

Query to find Request set attached to responsibility in oracle apps

SELECT DISTINCT frt.responsibility_name,

   frg.request_group_name,

   frsv.user_request_set_name,

   frsv.request_set_name

         FROM fnd_responsibility fr,

              fnd_responsibility_tl frt,

              fnd_request_groups frg,

              fnd_request_group_units frgu,

              fnd_request_sets_vl frsv

        WHERE fr.request_group_id = frg.request_group_id

          AND fr.responsibility_id = frt.responsibility_id

          AND frg.request_group_id = frgu.request_group_id

          AND frgu.request_unit_id = frsv.request_set_id

          AND frsv.request_set_name=:P_REQUEST_SET_NAME

How to Upgrade or Migrate from Forms and Reports 6i to 12c

 Migrate forms and Reports 6i to 12c in Linux/Unix Environment

1. Ensure the DB and Unix Server are upgraded to 12c version is 12.2.1.19.0

 OS: Oracle Linux Server release 7.9

Database: 19c

2. Once the Environment is set, identify the list of 6i forms to be migrated.

3.First you need to install the forms 10g and Forms 12c,the patch which is available to install Forms and Reports 12c are 

DLP:

Oracle Forms and Reports 12.2.1.19.0 ( Oracle Forms and Reports )

You can download from https://edelivery.oracle.com/osdc/faces/SoftwareDelivery

4.Once you have downloaded and installed you will have frmbld which is the form builder

Forms Migration:

1. First open forms 10g builder and open the 6i form and just save it, without this step if you open directly the 6i form in 12c it will error out and does not allow you to open.

2. Now once the form is saved from 10g builder you can open the form directly in 12c forms builder

3. You need to set the FORMS_PATH just like you set it for forms 10g where all the pll's,olb's and other library files are copied.

4. You need to regenerate or re compile all the 6i plls in 12c and just copy the olb's to the FORMS_PATH

5.All the icons should be copied in icons.jar/frmall.jar file and mention the path of this jar file in the FORMS_PATH in the Linux Server to reflect the icons/images for the buttons.

6.Attach the required pll's in Attached Libraries in the form builder 12c when the form is opened, open the OLB file also if its reading from OLB and then save and compile and ensure that fmx is generated.

7.To Run the form you need to have the URL 

 http://hostname:port/forms/frmservlet?config=webutil_webstart

8.If you have any login form which has to appear initially then in the URL you need not give the form name ,but you can do the setup 

8.When you run this in the browser it will open the form 

To access Web Configuration page: ---> https://docs.oracle.com/middleware/1221/formsandreports/deploy-forms/configure.htm#FSDEP171 ----> Image is displayed

Access Fusion Middleware Control.

From the Fusion Middleware Control main page, click the Target Navigation link to expose the navigation side panel.

In the tree, expand the Forms node and click on the instance you want to configure.

From the Forms page and in the Forms Deployments table, click on Web Configuration and right corner you will have "Lock and Edit option and click on it"

Click on webutil_webstart and down you will have ADD button. Click on it :

Add the following parameters and it's values :

parameter : form

value: S016

next

parameter : userid

value: <give your userid/password@dbconnect string>

Apply and in right top corner you will have "Activate Changes" --Click on it.

Now access your forms URL just until ---> http://hostname:port/forms/frmservlet?config=webutil_webstart

This should solve this issue

9. If you want to download or upload the files from local machine from your forms then you should use CLIENT_TEXT_IO and CLIENT_GET_FILE_NAME builtin functions in 12c forms, for that webutil.pll and webutil.olb is must.If the webutil is not working for some reasons then you can follow the document How to Configure Webutil in Forms 12c (Doc ID 2070183.1)