1. PART 2 - Changing the Column Prompts of Custom Integrator 3
1.1 Business Requirement 3
1.2 Setup Steps 3
PART 2 - Changing the Column Prompts of Custom Integrator
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:
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
| Filed Name | Value |
| Application | PER |
| Integrator | XX – Upload Training 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
Subscribe to this comment's feedwritten by sanjaysingh , March 31, 2011
Prompt Left - Name of the column prompts in the header region which have the Prompts name left aligned -Example: the instructions which we have added to our custom integrator in part 1 gets added in the header and have the names left aligned as INSTRUCT1, INSTRUCT2 etc . If we want to rename them we will have to add the new value in Prompt left
Prompt Above - Name of the column pormpts in the upload region which have different columns like Employee_number etc, In order to change them we have to change the values in Prompt Above column.
Hope this helps to resolve the query.
Kind Regards,
Sanjay
written by Avinash.mca , October 14, 2011
What is teh integrator name in 11i I do not get the name "Web ADI – Update Interface Column Prompts" in 11i instance.
Thanks,
Avinash
written by electronic ballast , November 18, 2011
Ningbo Zhengjia Electric Appliance Co., Ltd is a professional R & D manufacturer and exporter of electronic ballast for fluorescent lamps(FL) and Compact Fluorescent Lamps(PL).
written by block machine , January 11, 2012
Ningbo Yinzhou Nuoya Cement Block Machine Factory, a professional manufacturer and exporter of all kinds of Single and Multi Spring brick machine,concrete brick machine,block machine,We are a member of Building Block Association with excellent and advanced technology.
Can you pls let us knw the difference between Prompt Left and Prompt Above?
Thanks