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 laterInformation in this document applies to any platform.
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:
1. Query has Exceeded 200 rows. Potentially more rows exist, please restrict your query.
2. Interface based on database table has been refreshed successfully.
Changes
This is a newly defined custom integrator, it has not been used in the past.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |