WEB ADI_Creation

*=========================================================================*

Ticket NO   Date            Updated By      Description

*==================================================================*

         21-Sep-2019     Ravikas Verma         updated template

==========================================================================*

1=> Take the responsibility of Desktop Integrator.

INTERFACE NAME => XXESTEST

Desk top Integrator Setup document.

This document for insert data into customer table

Click On Next button

Click on next button.

Click on Next button.

Click On Create document system will ask to save the file.

Click Open system will generate the Excel file.

Prepare a package in database to insert in table.

Enter the Data

Click On ADDINS oracle menu from the menu bar then click oracle Upload.

Click on Define Layout and enter the required details.

Click Open.

Select the Integrator name from the list of Values which you created.

Click GO

Click on Create

Click Next

Select the line in Placement List of values

Click next.

Enter the range of values of width

Click Apply.

After create WEB ADI create , make a function from System Administrator – Application – Function

TYPE : SSWA servlet function

PARAMETERS : bne:page=BneCreateDoc&bne:integrator=20003:GENERAL_146_INTG

Note : To get integrator code use below SQL query

HTML CALL= BneApplicationService

Select * From BNE_INTEGRATORS_TL

WHERE USER_NAME LIKE'%BI%'    TO GET GENERAL_224_INTG VALUE

PARAMETER = bne:page=BneCreateDoc&bne:integrator=20003:GENERAL_224_INTG

After this you can add this above function in any MENU where you want to all this option

Now Add Web ADI To a Menu

Goto SYSADMINàSECURITYàRESPOSIBILITYàDEFINE

QUERY FOR RESPONSIBILITY NAME COPY THE MENU NAME

Goto SYSADMINàAPPLICATIONàMENU

QUERY THE MENU NAME AND ADD THE FUNCTION AS SHOWN BELOW

MENU (ORDER ENTRY EAM)

ESCORTS_ORDER_ENTRY_NEW

CHANGE COLUMN NAME

GET INTEGRATOR NAME FROM

Select * From BNE_INTEGRATORS_TL  WHERE USER_NAME LIKE'%BI%'

GET INTERFACE_CODE NAME USING THIS QUERY. CHANGE INTG TO INTF IN INTERFACE_CODE

SELECT * FROM bne_interface_cols_tl

WHERE

1=1

AND INTERFACE_CODE='GENERAL_224_INTF'

UPDATE bne_interface_cols_tl

SET prompt_above = 'Code Nature',

prompt_left = 'Code Nature'

WHERE prompt_above = 'DE_NATURE'

AND application_id = 20003

AND interface_code = 'GENERAL_224_INTF'

SELECT * FROM bne_interface_cols_tl

WHERE

1=1

AND INTERFACE_CODE='GENERAL_684_INTF'

UPDATE bne_integrators_b SET SOURCE  = 'C' WHERE integrator_code IN ('GENERAL_684_INTG');

select * from

bne_integrators_b

where

integrator_code IN ('GENERAL_684_INTG');

select * from

bne_param_list_items

where

PARAM_LIST_CODE like '%GENERAL%684%';

select * from

bne_attributes

where

ATTRIBUTE_CODE like '%GENERAL%684%';