WEBADI - Register as Function

WEBADI 

Steps to create the function for WEBADI and attach to menu.

1. Get the Integrator code, layout code , content_code, param list code and create a function for the WEBADI document.

SELECT biv.application_id,
       biv.integrator_code,
       biv.user_name,
       bib.interface_code,
       lo.LAYOUT_CODE,
       (SELECT DISTINCT user_name
          FROM BNE_LAYOUTS_TL
         WHERE LAYOUT_CODE = lo.LAYOUT_CODE)
          layoutname,
       (SELECT DISTINCT user_name
          FROM BNE_CONTENTS_TL
         WHERE content_code = cont.content_code)
          contentname,
       cont.content_code,
       cont.param_list_code,
       cont.content_class,
       (SELECT QUERY
          FROM BNE_STORED_SQL
         WHERE CONTENT_CODE = CONT.CONTENT_CODE)
          QUERY
  FROM bne_integrators_vl biv,
              bne_interfaces_b bib,
              BNE_LAYOUTS_B lo,
              BNE_CONTENTS_b cont
 WHERE     UPPER (user_name) LIKE '&Integrator name'
                    AND bib.integrator_code = biv.integrator_code
                    AND lo.integrator_code = biv.integrator_code
                    AND cont.integrator_code = biv.integrator_code

----------------------------------------------------------------------------------------------------------------------------

Register document of WEBADI as form function in Oracle apps.

Step 1 -      Enter the function name and User function name in the functions form.
Navigation  - Application Developer Responsibility -- Applications -- Functions.

Step 2 -  Select SSWA servlet function in the Properties tab as below

Step 3 - in the Forms Tab, put the parameters value in the below format.

The highlighted in yellow are the data that can be obtained from the query shared above and need to replace herewith before adding in the form.

text to copy -
bne:page=BneCreateDoc&bne:viewer=BNE:EXCEL2016&bne:reporting=N&bne:integrator=SCHEMA_NAME:INTEGRATOR_CODE&bne:layout=SCHEMA_NAME:LAYOUT_CODE&bne:content=SCHEMA_NAME:CONTENT_CODE&bne:noreview=Y

Step 4- In the Web HTML tab, the html call field should have the following value-

Value- BneApplicationService

Step  5 - Click on save and add the created function to the Menu as below-

After addition , Navigate to the responsibility and check if the function is visible.

Step 6 - When we double click on this above highlighted menu item, then the create document page opens up in the browser as below-

Step 7 - Click on Create on the right top side of the page and this downloads a template for the user to fill in data.
It takes about 5-7 mins for the template to download.


This ends the chapter of Registering the function with Menu for WEBADI.