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:

Symptoms

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.

STEPS TO REPRODUCE THE ISSUE
--------------------------------------
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:

Changes

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

Cause

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