Changes in Existing Web-Adi Letter Column/Data

Changes in Existing Web-Adi Letter Column/Data

====================================================================

1. Find the Integrator Name of the letter.Form Function name is same as Integrator Name.

2. Find the form function.

3.SELECT integrator_code, application_idFROM bne_integrators_vl vlWHERE user_name IN ('XX Request for further references', 'XX Sorry Interview did not work') ;Here you find the Integrator Code.

4. Use FNDLOAD command to download the Integartor as ================================================================

FNDLOAD apps/hp75400 0 Y DOWNLOAD $BNE_TOP/admin/import/bneint.lct XX_HR_2_INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN="PER" INTEGRATOR_CODE="HR_2_INTG"

=================================================================

The integrator will be downloaded to the current location from where the command issued as XX_HR_2_INTG.ldt for above example.Issue this command to the application server.

5.open XX_HR_2_INTG.ldt file with wordpad here you will find the Integrator Interface code name.

6.Now issue the following commandselect user_name from BNE_INTERFACES_VL where INTEGRATOR_CODE LIKE 'HR_2_INTG'

7.From above querry you will find the view name used for this letter generation.ie, user_name form above querry obtain is nothing but the database view name.

8.Now by opening this view you can modify the select statement used in creation of this view.

9.Recreate the view after changes are done.

10. Finish..now you can check the data by generating letter using web-adi.

=============================================================

Very Important Link for this : http://oracle.anilpassi.com/fndload-for-oracle-web-adi.html