My Oracle Support Banner

Web ADI Custom Integrator Creating a Layout And It Is Missing Optional Fields to Select (Doc ID 2934171.1)

Last updated on MARCH 13, 2023

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.0.0 and later
Information in this document applies to any platform.


Attempting to create a layout for a custom template and not all the optional fields are being displayed.

There are over 450 columns in the assigned interface table that the integrator is defined to use,  200 of the 450 fields are currently being displayed.

Create a new Integrator that uses a interface table with over 200 columns.
1) Using Desktop Integration Manager Responsibility.
2) Navigate to Create Integrator.
3) Define a new Custom Integrator that uses a Interface table with Over 200 columns, in this example the table used had over 450 columns defined.
4) Submit to save and have the Integrator created.

Attempting now to create a Layout to be used with the newly defined custom integrator.
5) Using Desktop Integration Responsibility.
6) Navigate to Define Layout.
7) Select the custom integrator name.
8) Create layout provide name, next.
9) Go to provided Optional Fields scroll down to find only 200 of the 450 fields are displayed.

Attempting to refresh the assigned integrator shows a Warning: Query has Exceeded 200 rows. Potentially more rows exist, please restrict your query.
10) Using Desktop Integration Manager Responsibility.
11) Navigate to Manage Integrators.
12) Query the newly defined Integrator, select Update.
13) Select Next to go to the Interfaces page.
14) Select the Interface being used by clicking on the select radio button, then click on the Integrator Name. This will query the Interface attributes.
15) Select - Refresh.
16) After Refreshing the following warning is seen at the top of the page:

1. Query has Exceeded 200 rows. Potentially more rows exist, please restrict your query.
2. Interface based on database table has been refreshed successfully.



 This is a newly defined custom integrator, it has not been used in the past.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.