Search This Blog

Tuesday, December 17, 2013

Update Custom WebADI Integrator

Situation:
I have created a Custom Integrator using Create Document Function from 'Desktop Integrator' Responsibility using 'HR Integrator Setup' Integrator.

I have Provided Pl/SQL Procedure as API Type. Integrator got created successfully but in the Document i am seeing headers like p_emp_num_i etc which are my Procedure's Input Parameter names.

I want to change these Column names to more user-friendly.

But now when I go to the Desktop Integration Manager->Manage Integrator the update icon is disabled for this custom integrator and also the source is set to Oracle.

Is there any way i can change the Prompt of the Column names?

Solution:

There are two ways for this situation.

1. Update the source into custom by following SQL:

UPDATE BNE_INTEGRATORS_B

SET SOURCE = 'C'

WHERE APPLICATION_ID = 'XXX'

AND INTEGRATOR_CODE = 'XXX';

*** Please make sure that this is a custom integrator.

2. Update the document header by BNE API.

API : BNE_INTEGRATOR_UTILS.UPDATE_INTERFACE_COLUMN_TEXT

1 comment:

  1. Could you please provide more details or any documents,references on creating custom WEB ADI for custom API.

    ReplyDelete