Oracle Web Applications Desktop Integrator Tutorial Defining Table LOV

YouTube video

In this tutorial, we will be discussing how to define table validated LOVs (List of Values) and how to use them in a custom integrator within the Oracle Web Applications Desktop Integrator (Web ADI) framework. This tutorial is specifically aimed at integration developers who are familiar with the concepts of Web ADI and the relevant Oracle E-Business Suite applications.

Web ADI allows for the creation of various types of user interface (UI) widgets, such as lists of values, in order to facilitate data entry and manipulation. Within these UI widgets, different types of LOVs can be used, including table validated LOVs. Table validated LOVs are designed to display meaningful information to end-users in both the LOV and the spreadsheet, while internally storing the corresponding ID or code in the E-Business Suite.

In this tutorial, we will be using a sample use case of uploading supplier information to a custom table. The steps involved in defining the table validated LOV are as follows:

  1. Prepare the database objects: This involves defining the custom table to store the supplier information and the shipment information.

  2. Create a custom integrator: Using the Desktop Integration Manager responsibility, create a custom integrator and select the table-based interface. The interface should be linked to the custom supplier table.

  3. Define interface attribute properties: Set the properties for the interface attributes, such as prompts, column headers, and required columns. One of the columns that will be shown in the spreadsheet is the shipment via column, which we will use the table LOV against.

  4. Create an uploader from the template: Create an uploader for the integrator, making sure to customize it based on the requirements of the use case. In this step, the table LOV component for the ship via interface attribute is defined.

  5. Define the layout for the integrator: Define how the integrator will be displayed in terms of layout and formatting. This step allows you to preview or test the integrator with sample data and verify the uploaded data in the backend.

Throughout the tutorial, we will be modifying default attributes of the LOB, such as the display name, internal name, owner application, and component parameters. It is important to note that the custom table and the custom lookup table will be registered using the appropriate ad script, and sample data will be inserted into the lookup table for testing purposes.

To create the integrator, log in as an operations user or a user with access to the Desktop Integration Manager responsibility. Navigate to the Desktop Integration Manager responsibility and click on the “Create Integrator” function. Follow the step-by-step wizard to define the integrator, including the name, interface type, and the custom supplier table that will be used.

Once the integrator is created, you can define the interface attributes by selecting the desired columns from the custom table. Make sure to update the interface attributes with meaningful prompts and set properties such as whether the column is required or not.

Next, create the uploader using a template and customize it according to the requirements of the use case. This is where the table LOV component for the ship via interface attribute is defined. Set the necessary component parameters, such as the table column alias and the column names of the lookup table that will be shown in the LOV component.

After creating the uploader, associate the table LOV component with the ship via interface attribute in the integrator definition. This ensures that the LOV component is linked correctly and will be displayed in the spreadsheet.

To define the layout for the integrator, select the integrator and click on the “Define Layout” function. Choose the desired layout name and select the columns that will be shown in the spreadsheet. Make any necessary changes to the layout, such as alignment or display options.

Once the layout is defined, you can preview or test the integrator by selecting it and clicking on the “Preview” function. This will generate a sample document with the specified layout. You can enter data into the spreadsheet and verify that the LOV component is working correctly.

Finally, you can upload the data to the backend system by navigating to the upload function within the integrator. The uploaded data will be validated against the custom lookup table, and the corresponding values will be stored in the custom supplier table.

In conclusion, defining table validated LOVs within the Oracle Web Applications Desktop Integrator is a powerful tool for integration developers. By following the steps outlined in this tutorial, you can effectively define and utilize table LOVs to enhance the functionality of your custom integrators.