To define a mapping in the Define Mapping page flow:You can choose to automatically import data into the spreadsheet in the Create Document interface, as described in Creating a Document. When you choose to import data on the Content page, Oracle Web Applications Desktop Integrator prompts you to select a mapping. Oracle Web Applications Desktop Integrator requires a mapping in order to determine where imported data should be placed in the spreadsheet.
Mapping associates columns in the imported source data with columns in the spreadsheet. You do not need to create new mappings for fields that do not have data, or if a mapped field is not included in the spreadsheet. You need to create multiple mappings for a content only if the associations between the downloaded columns and the fields in the spreadsheet change. If you import text files with varied data structures, you may need to define more than one mapping for each text file variation.
Note: Do not modify contents that download data from Oracle E-Business Suite.
Note: To modify an integrator's mappings, you must be granted access to the integrator or have the System Administrator responsibility. Specific form functions grant access to specific integrators. See the product documentation for the form functions that must be added to your menu to have access to an integrator's list of mappings.
Oracle Web Applications Desktop Integrator provides two versions of the Define Mapping interface. The default is the Define Mapping page flow, which guides you through multiple pages to enter the mapping properties. Alternatively, your administrator can enable the Define Mapping page, which lets you enter all the mapping properties in a single page after you have selected the integrator to which the mapping applies.
To define a mapping in the Define Mapping page flow:From the Oracle E-Business Suite navigator, select the Define Mapping link. This may be under the Desktop Integration responsibility, or it may be located under a different responsibility assigned to you by your system administrator.
If the integrator has more than one content defined, then in the Select Content page, select a content to import.
Content indicates the information you will import into your spreadsheet. One or more mappings can be defined for a particular content.
Choose Define Mapping to define a new mapping, or choose Update for an existing mapping to modify it.
To define a new mapping based on an existing mapping, choose Duplicate for the existing mapping. Enter the name and unique key for the new mapping, and choose Apply.
To delete a mapping that you no longer need, choose Delete for that mapping. Then choose OK in the confirmation page.
Enter a name and a unique key for the mapping and the number of columns to be mapped.
If you are updating an existing mapping, you can update the name and the number of columns for the mapping, but you cannot change the unique mapping key.
Associate columns being imported from the content with fields in the spreadsheet.
For each mapping row, enter a source column within the content. You can choose LOV for the Source Column field in the mapping row to view a list of available columns to import.
Then, enter the target column within the spreadsheet that you want to associate with that source column. You can choose LOV for the Target Column field in the mapping row to view a list of available columns for the spreadsheet.
To add another mapping row, choose Add Row.
Some target columns support the translation of ID values from source columns. To find out if a specific column supports the translation of IDs, select that column and choose Lookup. If the column supports ID translation, a check box appears under Lookup in the mapping row for that column name. To perform the ID translation, select the Lookup check box for the desired columns.
Choose Apply.
To define a mapping in the simplified Define Mapping page:From the Oracle E-Business Suite navigator, select Define Mapping. This menu item may be under the Desktop Integration responsibility, or it may be located under a different responsibility assigned to you by your system administrator.
Select the integrator. You can optionally enter a complete or partial mapping name to search for mappings whose names match that value. Leave the mapping name blank to search for all existing mappings for the integrator. Then choose Go. Oracle Web Applications Desktop Integrator displays the mappings that match your search criteria.
Note: Because mappings are created for a specific content, the list of values for the Integrator Name field includes only those integrators for which at least one SQL query, Java, or text file content is defined.
Tip: The number of integrators displayed in the list of values for the Integrator Name field is limited by the FND: View Object Max Fetch Size profile option. By default, this profile option is set to 200 records. If the list of values does not display all your integrators, set the FND: View Object Max Fetch Size profile option to a value equal to or higher than the number of integrators defined in your instance. For more information about this profile option, see the Oracle Application Framework Developer's Guide, available from My Oracle Support Knowledge Document 1315485.1.
Note: The list of existing mappings does not include the default mappings that are generated automatically for reporting-only contents by Oracle E-Business Suite Desktop Integration Framework. You cannot view or update the automatically generated mappings.
Choose the action you want to perform.
To create a new mapping, choose Define Mapping.
To modify an existing mapping, choose the Update icon for that mapping.
To create a new mapping based on an existing mapping, choose the Duplicate icon for the existing mapping.
To delete a mapping that you no longer need, choose the Delete icon for that mapping.
If you chose to create, update, or duplicate a mapping, continue with the following steps to define the mapping properties in the Define Mapping page.
Enter a name for the mapping.
If the integrator has more than one content defined, then select the content to which this mapping applies.
The content indicates the information you will import into your spreadsheet. You can define one or more mappings for a particular content.
Note: If you are updating or duplicating an existing mapping, you cannot change the previously specified content.
Use the Source Column list and the Target Column list to associate source columns being imported from the content with target columns in the spreadsheet. The columns in the lists are mapped to each other in the order in which they appear in this page. That is, the first source column shown is mapped to the first target column shown, the second source column shown is mapped to the second target column shown, and so on. Each source column that you include must be mapped to a target column.
Tip: You can map multiple source columns to the same target column. To do so, add the same target column to the Target Column list as many times as needed, so that it appears in a mapped pair with each relevant source column.
Choose Select Source Columns to search for the source columns you want to include in the mapping. In the Select Source Columns list of values, choose one or more columns to add.
Tip: To add more columns after the initial selection, choose Select Source Columns again. The new columns are added at the end of the Source Columns list.
Choose Select Target Columns to search for the target columns you want to include in the mapping. In the Select Target Columns list of values, choose one or more columns to add.
Tip: To add more columns after the initial selection, choose Select Target Columns again. The new columns are added at the end of the Target Columns list.
Use the Move Up and Move Down arrows in the Target Column list to change the order of the target columns to match the order of the corresponding columns in the Source Column list.
Some target columns support the conversion of internal ID values from the corresponding source column into user-readable values in the target column. For these target columns, a check box appears under the Lookup heading in the Target Columns list. To enable the conversion of ID values for a pair of mapped columns, select the Lookup check box for the target column.
To delete a pair of mapped columns, choose the Delete icon for the source column in the Source Column list. Oracle Web Applications Desktop Integrator deletes both that source column and the target column in the corresponding position in the Target Column list.
Choose Save.
Tip: Oracle Web Applications Desktop Integrator saves only mapped pairs of source and target columns in the mapping definition. If the Target Columns list contains more entries than the Source Columns list, then Oracle Web Applications Desktop Integrator ignores the unmapped target columns.