1.    PART 2 - Changing the Column Prompts of Custom Integrator    3

1.1    Business Requirement    3

1.2    Setup Steps    3

1. PART 2 - Changing the Column Prompts of Custom Integrator

1. 1. Business Requirement

The Column prompts of any Custom integrator will have the names of the parameter which you have used in the wrapper package. Most of the times these prompts are not user friendly and let say we have a requirement to change the Column prompt to make them more users friendly. We can achieve it very easily using the following steps:

2. 2. Setup Steps

Navigation -> Desktop Integrator -> Create Document
Select Integrator name as Web ADI – Update Interface Column Prompts, this is a seeded integrator provided by Oracle to change the prompts for any define integrator (we can also achieve this by doing an update directly to base tables but that option is not a recommended one)


Click next and enter below details

Click next and click on create document – this will download the Integrator data along with the prompts which are currently in use for the integrator

Now remember the ADI which we had created in our earlier section

Now there is a requirement that we want to hide the prompts INSTRUCT and change the prompts like EMPLOYEE_NUMBER to Employee Number, etc
I will be changing the Prompt left property for INSTRUCT to NULL and Prompt Above property of other as per requirement.

Once done Upload the change prompt by using the Oracle -> Upload option in toolbar

Let’s now re-download our integrator to see the change
Navigation -> Desktop Integrator-> Create Document -> Search for your custom integrator

We can see that the column prompts have got changed

Add comment