Administering Oracle Web Applications Desktop Integrator

This chapter covers the following topics:

Defining Layouts

Layouts enable you to customize the user interface presented in your spreadsheet. Use the layout functionality to determine the fields in a spreadsheet, set their positions, and specify default values for the fields.

A layout must be available before you create a spreadsheet in the Create Document interface. Some integrators offer predefined layouts, or you can use the procedure described in this chapter to create a layout.

Note: For some products, the layouts are predefined and preselected. Therefore you cannot select an alternate layout during document creation.

Note: You must be granted access to an integrator to modify its layout. Specific security functions grant access to specific integrators. See the product-specific documentation for information regarding access to individual integrator layouts.

Use the Define Layout interface to perform the following:

When you define a layout, you must first select the integrator to which the layout applies. Then choose to create a new layout or select an existing layout to update. You can then define the layout properties, including the following:

Oracle Web Applications Desktop Integrator provides two versions of the Define Layout interface. The default is the Define Layout page flow, which guides you through multiple pages to enter the layout properties. Alternatively, your administrator can enable the Define Layout page, which lets you enter all the layout properties in a single page after you have selected the integrator to which the layout applies.

To define a layout in the Define Layout page flow

  1. From the Oracle E-Business Suite navigator, select Define Layout. 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.

  2. Select the integrator. Oracle Web Applications Desktop Integrator displays any existing layouts for the integrator.

  3. Choose Create to create a new layout, or select an existing layout and choose Update to modify it.

    To create a new layout based on an existing layout, select the existing layout and choose Duplicate. Enter a name for the new layout and choose Apply.

    To delete a layout that you no longer need, select the layout and choose Delete. Then choose OK in the confirmation page.

  4. Enter a Layout Name and specify the Number of Headers to place across the top of the document.

    If your document has one header, all fields that you identify as header fields will display in a single list. If your layout includes numerous header fields, consider defining multiple headers to place them horizontally across the top of your document.

  5. Determine the fields to be included in the layout, their placement, and their default values. The page displays a list of the required fields for this integrator and a list of optional fields.

    Some integrators offer the ability to display a graph of data from the rows in the lines region. In this case the Include Graph of Lines Data option appears in this page. Optionally select this option to specify that Oracle Web Applications Desktop Integrator should generate a graph automatically when the document is first downloaded. For example, you might want to select this option if the integrator has a content defined to populate the document with data during the initial download. If you do not select this option, then users must use one of the graph buttons from the Oracle ribbon tab in Microsoft Excel to generate a graph in their documents after the initial download. See: Viewing Graphs.

    All required fields must be included in your layout. Include optional fields by selecting the Select box. The following table describes the options available for the fields in your layout:

    Layout Field Options
    Fields Description
    Placement Defines the location of the field on the spreadsheet. You can select Context, Header, or Line.
    If you specified that the document has multiple headers, select the one in which you want the field to appear, such as Header 1, Header 2, or Header 3.
    Default Value Some fields may have predefined default values, or you can enter the default value here, using the appropriate format for the default type. For context fields, you should always define a default value.

    Note: For a field that contains a date value, the format of the default value should match the date format defined for the integrator in the integrator LDT file.

    Default Type Indicates how Oracle Web Applications Desktop Integrator should obtain the default value.

    The following table describes the available default types.

    Default Types
    Default Type Description
    None If you do not want to specify any default value, select this type and leave the Default Value field blank. None is the default setting for the Default Type option itself, for all fields in the layout. For context fields, you should always change this setting to specify a default type and a default value.
    Constant Select this type to use the text entered in the Default Value field as the default value in the spreadsheet.
    Environment Select this type to reference an environment variable when setting a default for a field. If you select this type, enter one of the following values in the Default Value field:
    • sysdate - System date

    • database - Name of the current database

    • oauser.id - ID of your current Oracle E-Business Suite user

    Parameter Select this type to reference a runtime parameter from the document parameter list defined for the integrator. The parameters that can be referenced are specific to each integrator. See the product-specific documentation for the valid values to enter in the Default Value field for this default type. For more information, see: To define integrator information, Oracle E-Business Suite Desktop Integration Framework Developer's Guide and To define a document parameter list, Oracle E-Business Suite Desktop Integration Framework Developer's Guide.
    SQL Select this type to run a SQL statement to determine the default for the field. Oracle Web Applications Desktop Integrator runs the SQL statement entered in the Default Value field and automatically populates the spreadsheet with the results. If more than one value is returned from the query, Oracle Web Applications Desktop Integrator uses the first value.
    You can use the following tokens in the SQL statement that you enter in the Default Value field:
    • $profiles$.profilename - Returns the value for the current user's profile when you enter the name of the profile option.

    • $env$.userid - Returns the current user ID.

    • $env$.appid - Returns the current application ID.

    • $env$.respid - Returns the current responsibility ID.

    • $env$.language - Returns the current session language.

    Formula Select this type to enter an Excel-compatible formula to determine the default value for a field. When you enter the formula in the Default Value field, follow the Excel formula syntax and enclose field names in brackets.
    For example: [credit]+[debit]
    Note that referencing the field names rather than the cell names prevents your formulas from being corrupted if the order of the fields is changed in the layout.
  6. In the Create Layout page, define display properties for the page components. Use this page to mark fields as Read Only, to hide fields, and to move the fields up or down in the display order.

    Document Properties

    • Protect Sheet - Select Yes or No to set the state of the document when downloaded. A protected sheet will allow you to update the data fields but will not allow you to insert rows. Users can change this setting in Microsoft Excel.

    • Style Sheet - Select a style sheet to apply to the document. See Defining a Style Sheet.

    • Apply Filters - Select Yes to enable Microsoft Excel filters for the lines region when the document is downloaded. Users can change this setting in Microsoft Excel by selecting the Filters button in the Oracle ribbon tab.

    • Image - If you want to display a branding image in the documents created with this layout, enter the file name of the image. For example, MyCompanyImage.gif. Ensure that you have placed the image in the OA_MEDIA virtual directory. The image you define here for the layout overrides any image specified at the style sheet level or in the Corporate Branding Image for Oracle Applications profile option. See: Implementing Branding Images.

    Graph Properties

    • Some integrators offer the ability to display a graph of data from the rows in the lines region. In this case you can specify the following properties to define how the graph should appear by default. These properties apply both to automatically generated graphs and to graphs that users add manually.

    • Enter a graph Title.

    • Select the Graph Type: Area, Bar, Column, Line, or Pie.

    • Select the Subtype: 3D (three-dimensional) or 2D (two-dimensional).

    • For 2D graphs, enter the titles for the Category (X) Axis and the Series (Y) Axis.

      For 3D graphs, enter the titles for the Category (X) Axis, the Series (Y) Axis, and the Value (Z) Axis.

    • Enter the Category Columns. The data from these columns will be represented on the X axis. Separate each column name from the next with a comma. Each name entered must be a valid column name occurring in the layout definition.

    • Enter the Series Columns. The data from these columns will be represented on the Y axis. Separate each column name from the next with a comma. Each name entered must be a valid column name occurring in the layout definition.

    Tip: Users can modify the graph within the downloaded document by selecting Modify Graph Type or Modify Graph Options from the Oracle ribbon tab in Microsoft Excel. See: Viewing Graphs.

    Context Field Properties

    • Prompt Span - enter the number of columns that the field prompt will span.

      Important: For context and header fields, you set the number of columns for the Prompt, Hint, and Data to span. You set the column widths for the fields at the Line level. Therefore, when setting the column spans for a header or context field, be aware that the width of a column is determined by the width of the line fields in the spreadsheet. See Design Considerations.

    • Hint Span - enter the number of columns for the field hint to span. The hint for a field can include the following:

      • * - indicates the field is required.

      • List - indicates that the field provides a list of values. Double-click the field to invoke the list.

      • Data type - the data type for each field is always displayed. For example, Text or Number.

    • Data Span - enter the number of columns for the data to span.

    • Move Up and Move Down - optionally use these arrows to change the order of the fields.

    • Hide - select this option if you want the field hidden on the spreadsheet.

    Header Field Properties

    • Prompt Span - enter the number of columns that the field prompt will span.

      Important: For context and header fields, you set the number of columns for the Prompt, Hint, and Data to span. You set the column widths for the fields at the Line level. Therefore, when setting the column spans for a header or context field, be aware that the width of a column is determined by the width of the line fields in the spreadsheet. See Design Considerations.

    • Title - optionally enter a title for the header.

    • Hint Span - enter the number of columns for the field hint to span. The hint for a field can include the following:

      • * - indicates the field is required.

      • List - indicates that the field provides a list of values. Double-click the field to invoke the list.

      • Data type - the data type for each field is always displayed. For example, Text or Number.

    • Data Span - enter the number of columns for the data to span.

    • Move Up and Move Down - optionally use these arrows to change the order of the fields.

    • Hide - select this option if you want the field hidden on the spreadsheet.

    • Read Only - select this option if you want the field to display as a nonupdateable, read-only field.

    Line Region Properties

    • Data Entry Rows - enter the number of blank rows to display when the document is generated. Users can add more rows once the document is downloaded to Excel.

      Note: The maximum number of data entry rows is limited by the number of rows that Microsoft Excel allows in a worksheet. When you use Microsoft Excel 2010 and higher with Oracle Web Applications Desktop Integrator Release 12.2.6 and higher, the maximum value for the Data Entry Rows field is 1,048,000 rows.

      If your site is not using the OOXML format, use caution when specifying the Data Entry Rows setting. Specifying a large number of data entry rows significantly increases the time required to create and upload Oracle Web Applications Desktop Integrator documents.

      If your site is using the OOXML format, then the document creation and upload processing is performed on the server. In this case the processing is significantly faster than if you do not use OOXML, but requires a larger server heap memory. You should review the server heap memory setting to ensure it is appropriate for this configuration.

    • Move Up and Move Down - optionally use these arrows to change the order of the fields.

    • Read Only - select this option if you want the field to display as a nonupdateable, read-only field.

    • Width - enter the width of the field in characters.

    • Frozen Pane - use this option to set the fields that you want to remain visible while users scroll horizontally across the spreadsheet. All fields before the field for which you select the Frozen Pane option will be fixed in the spreadsheet and remain visible. Select the first field in the list if you do not want a frozen pane.

To define a layout in the simplified Define Layout page

  1. From the Oracle E-Business Suite navigator, select Define Layout. 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.

  2. Select the integrator. You can optionally enter a complete or partial layout name to search for layouts whose names match that value. Leave the layout name blank to search for all existing layouts for the integrator. Then choose Go. Oracle Web Applications Desktop Integrator displays the layouts that match your search criteria.

    Note: 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.

  3. Choose the action you want to perform.

    • To define a new layout, choose Create Layout.

    • To modify an existing layout, choose the Update icon for that layout.

    • To create a new layout based on an existing layout, choose the Duplicate icon for the existing layout.

    • To delete a layout that you no longer need, choose the Delete icon for that layout and confirm the deletion in the warning dialog.

    If you chose to create, update, or duplicate a layout, continue with the following steps to define the layout properties in the Create Layout, Update Layout, or Duplicate Layout page, respectively.

  4. Enter a name for the layout.

  5. Select a style sheet to apply to the documents created with this layout. See Defining a Style Sheet.

  6. If you want to display a branding image in the documents created with this layout, enter the file name of the image. For example, MyCompanyImage.gif. Ensure that you have placed the image in the OA_MEDIA virtual directory. The image you define here for the layout overrides any image specified at the style sheet level or in the Corporate Branding Image for Oracle Applications profile option. See: Implementing Branding Images.

  7. Optionally select the Protect Sheet option to set the state of the document to protected when it is first downloaded. A protected sheet lets users update the data fields but does not let them insert rows. Users can change this setting in Microsoft Excel.

  8. Optionally select the Apply Filters option to enable Microsoft Excel filters for the lines region when the document is first downloaded. Users can change this setting in Microsoft Excel by selecting the Filters button in the Oracle ribbon tab.

  9. Some integrators offer the ability to display a graph of data from the rows in the lines region. In this case the Graph region appears in this page.

    Optionally select the Automatically Generate Graph option to specify that Oracle Web Applications Desktop Integrator should generate a graph automatically when the document is first downloaded. For example, you might want to select this option if the integrator has a content defined to populate the document with data during the initial download. If you do not select this option, then users must use one of the graph buttons from the Oracle ribbon tab in Microsoft Excel to generate a graph in their documents after the initial download. See: Viewing Graphs.

    Specify the following properties to define how the graph should appear by default. These properties apply both to automatically generated graphs and to graphs that users add manually.

    • Enter a graph title.

    • Select the graph type: Area, Bar, Column, Line, or Pie.

    • Select the subtype: 3D (three-dimensional) or 2D (two-dimensional).

    • For 2D graphs, enter the titles for the Category (X) axis and the Series (Y) axis.

      For 3D graphs, enter the titles for the Category (X) axis, the Series (Y) axis, and the Value (Z) axis.

    Additionally, when you set the properties for the line fields in the Line region of this page, you should specify the fields that will be represented on the X axis and the fields that will be represented on the Y axis. See step 19.

    Tip: Users can modify the graph within the downloaded document by selecting Modify Graph Type or Modify Graph Options from the Oracle ribbon tab in Microsoft Excel. See: Viewing Graphs.

  10. In the Context region, enter the following overall properties for the context fields.

    • Prompt Span - Enter the number of columns that the field prompt will span.

      Important: For context and header fields, you set the number of columns for the prompt, hint, and data to span. You set the column widths for the fields at the line level. Therefore, when setting the column spans for a header or context field, be aware that the width of a column is determined by the width of the line fields in the spreadsheet. See Design Considerations.

    • Hint Span - Enter the number of columns that the field hint will span. When determining the width required for the hint, note that the hint for a field can include the following:

      • *- Indicates that the field is required.

      • List - Indicates that the field provides a list of values. The user can double-click the field to invoke the list.

      • Data type - The data type for each field is always displayed. For example, Text or Number.

    • Data Span - Enter the number of columns that the data will span.

  11. Specify the fields to include as context fields in the layout. Choose Add Optional Fields to add available fields to the context. You can also move fields from a header or from the Line region to the context.

    If you do not want a field to appear in the context, you can move it to a header or to the Line region, or, if the field is optional, you can remove it from the layout.

  12. Set the properties for each context field.

    • Optionally select the Hide option to hide the field in the spreadsheet.

    • Enter a default value for the field, using the appropriate format for the default type. Some fields may have a predefined default value specified in the integrator definition. You should always define a default value for context fields.

      Note: For a field that contains a date value, the format of the default value should match the date format defined for the integrator in the integrator LDT file.

    • Select the default type that indicates how Oracle Web Applications Desktop Integrator should obtain the default value. The following table describes the available default types.

      Default Types
      Default Type Description
      None If you do not want to specify any default value, select this type and leave the Default Value field blank. If you do not want to specify any default value, select this type and leave the Default Value field blank. None is the default setting for the Default Type option itself, for all fields in the layout. For context fields, you should always change this setting to specify a default type and a default value.
      Constant Select this type to use the text entered in the Default Value field as the default value in the spreadsheet.
      Environment Select this type to reference an environment variable when setting a default for a field. If you select this type, enter one of the following values in the Default Value field:
      • sysdate - System date

      • database - Name of the current database

      • oauser.id - ID of your current Oracle E-Business Suite user

      Parameter Select this type to reference a runtime parameter from the document parameter list defined for the integrator. The parameters that can be referenced are specific to each integrator. See the product-specific documentation for the valid values to enter in the Default Value field for this default type. For more information, see: To define integrator information, Oracle E-Business Suite Desktop Integration Framework Developer's Guide and To define a document parameter list, Oracle E-Business Suite Desktop Integration Framework Developer's Guide.
      SQL Select this type to run a SQL statement to determine the default for the field. Oracle Web Applications Desktop Integrator runs the SQL statement entered in the Default Value field and automatically populates the spreadsheet with the results. If more than one value is returned from the query, Oracle Web Applications Desktop Integrator uses the first value.
      You can use the following tokens in the SQL statement that you enter in the Default Value field:
      • $profiles$.profilename - Returns the value for the current user's profile when you enter the name of the profile option.

      • $env$.userid - Returns the current user ID.

      • $env$.appid - Returns the current application ID.

      • $env$.respid - Returns the current responsibility ID.

      • $env$.language - Returns the current session language.

      Formula Select this type to enter an Excel-compatible formula to determine the default value for a field. When you enter the formula in the Default Value field, follow the Excel formula syntax and enclose field names in brackets.
      For example: [credit]+[debit]
      Note that referencing the field names rather than the cell names prevents your formulas from being corrupted if the order of the fields is changed in the layout.
    • The context fields will appear in the same order in the spreadsheet as they do in the list in this page. Use the Move Up and Move Down icons to place the fields in the order you want.

    • If you do not want a listed field to appear in the context, select the Move To icon and select the part of the layout where you want to move the field, either a header or the Line region. Alternatively, if the field is optional, select the Remove icon to remove it from the layout.

  13. In the Headers region, select the number of headers to include in the layout and choose Apply. The page then displays a region to define each header, identified as Header 1, Header 2, Header 3, and so on. You can include up to 10 headers. If you do not want to include a header, select 0.

    If your document has one header, all fields that you identify as header fields will be displayed in a single vertical list. If you define multiple headers, they are displayed in multiple lists placed horizontally across your document. If your layout includes numerous header fields, consider defining multiple headers to make it easier for users to see all the header fields.

  14. In each header region, enter the following overall properties for the header.

    • Title - Optionally enter a title for the header.

    • Prompt Span - Enter the number of columns that the field prompt will span.

      Important: For context and header fields, you set the number of columns for the prompt, hint, and data to span. You set the column widths for the fields at the line level. Therefore, when setting the column spans for a header or context field, be aware that the width of a column is determined by the width of the line fields in the spreadsheet. See Design Considerations.

    • Hint Span - Enter the number of columns that the field hint will span. When determining the width required for the hint, note that the hint for a field can include the following:

      • *- Indicates that the field is required.

      • List - Indicates that the field provides a list of values. The user can double-click the field to invoke the list.

      • Data type - The data type for each field is always displayed. For example, Text or Number.

    • Data Span - Enter the number of columns that the data will span.

  15. Specify the fields to include in this header. Choose Add Optional Fields to add available fields to the header. You can also move fields from the context, from another header, or from the Line region to this header.

    If you do not want a field to appear in this header, you can move it to the context, to another header, or to the Line region. Alternatively, if the field is optional, you can remove it from the layout.

  16. Set the properties for each header field.

    • Optionally select the Read Only option if you want the field to appear as a nonupdatable, read-only field.

    • Optionally select the Hide option to hide the field in the spreadsheet.

    • Optionally enter a default value for the field, using the appropriate format for the default type. Some fields may have a predefined default value specified in the integrator definition.

      Note: For a field that contains a date value, the format of the default value should match the date format defined for the integrator in the integrator LDT file.

    • Select the default type that indicates how Oracle Web Applications Desktop Integrator should obtain the default value. The available default types are the same as those for the context fields.

    • The header fields will appear in the same order in the spreadsheet as they do in the list in this page. Use the Move Up and Move Down icons to place the fields in the order you want.

    • If you do not want a listed field to appear in this header, select the Move To icon and select the part of the layout where you want to move the field, either the context, another header, or the Line region. Alternatively, if the field is optional, select the Remove icon to remove it from the layout.

  17. In the Line region, in the Data Entry Rows field, enter the number of blank rows to display when the document is generated. Users can add more rows once the document is downloaded to Microsoft Excel.

    Note: The maximum number of data entry rows is limited by the number of rows that Microsoft Excel allows in a worksheet. When you use Microsoft Excel 2010 and higher with Oracle Web Applications Desktop Integrator Release 12.2.6 and higher, the maximum value for the Data Entry Rows field is 1,048,000 rows.

    If your site is not using the OOXML format, use caution when specifying the Data Entry Rows setting. Specifying a large number of data entry rows significantly increases the time required to create and upload Oracle Web Applications Desktop Integrator documents.

    If your site is using the OOXML format, then the document creation and upload processing is performed on the server. In this case the processing is significantly faster than if you do not use OOXML, but requires a larger server heap memory. You should review the server heap memory setting to ensure it is appropriate for this configuration.

  18. Specify the fields to include in the lines in the layout. Choose Add Optional Fields to add available fields to the lines. You can also move fields from the context or from a header to the lines.

    If you do not want a field to appear in the lines, you can move it to the context or to a header, or, if the field is optional, you can remove it from the layout.

  19. Set the properties for each line field.

    • Optionally select the Read Only option if you want the field to appear as a nonupdatable, read-only field.

    • Enter the width of the field in characters.

    • Use the Frozen Pane option to determine which fields remain visible while users scroll horizontally across the spreadsheet. All fields before the field for which you select the Frozen Pane option will be fixed in the spreadsheet and remain visible. If you do not want a frozen pane, then select the first field in the list.

    • Optionally enter a default value for the field, using the appropriate format for the default type. Some fields may have a predefined default value specified in the integrator definition.

      Note: For a field that contains a date value, the format of the default value should match the date format defined for the integrator in the integrator LDT file.

    • Select the default type that indicates how Oracle Web Applications Desktop Integrator should obtain the default value. The available default types are the same as those for the context fields.

    • If this integrator offers the ability to display a graph, then the Graph Location option appears to let you specify where the data from the field will be represented in the graph by default.

      • Category - The data from this field will be represented on the Category (X) axis.

      • Data - The data from this field will be represented on the Series (Y) axis.

      You can include multiple fields on each axis. If you do not want a field to be included in the graph, leave the Graph Location field blank. Ensure that you have also specified the related graph properties described in step 9.

    • The line fields will appear in the same order in the spreadsheet as they do in the list in this page. Use the Move Up and Move Down icons to place the fields in the order you want.

    • If you do not want a listed field to appear in the lines, select the Move To icon and select the part of the layout where you want to move the field, either the context or a header. Alternatively, if the field is optional, select the Remove icon to remove it from the layout.

  20. Choose Apply to save the layout definition.

Design Considerations

The width of columns in a spreadsheet is set at the line item level. Consequently, when setting the column spans for context and header fields, you must consider the widths of the corresponding line item columns. The following example shows the layout specifications for the Context fields and how these specifications are rendered in the actual document. The Context Prompt Span is defined as 5 columns and the Context Data Span is defined as 4 columns. Note that in the resulting spreadsheet, the context prompts span the five columns B through F.

The context data following the context prompts span the 4 columns G through J.

Note: The examples in this section show the layout specifications defined in the simplified Define Layout page. The layout properties appear slightly differently in the Define Layout page flow, but you can define the same properties in both interfaces.

Example 1 - Layout Specifications

the picture is described in the document text

Example 1 - Resulting Spreadsheet

the picture is described in the document text

The next example shows the Hint Span for the Header set to 1. In this case because the column that the hint falls into is narrow, the full hints are not displayed. To display the full hint text in this example, expand the Hint Span to 3.

Example 2 - Layout Specifications

the picture is described in the document text

Example 2 - Resulting Spreadsheet

the picture is described in the document text

The following example shows the same document after increasing the Header Hint Span to 3, to accommodate the full hint text.

Example 3 - Layout Specifications

the picture is described in the document text

Example 3 - Resulting Spreadsheet

the picture is described in the document text

Note that achieving the desired layout might require several iterations, because changing the column spans for the fields in the first header will affect the placement of the fields in subsequent headers. For example, if changing the Hint Span for Header 1 moves the hint text for Header 2 to a narrower column, then you should also change the Hint Span for Header 2 to accommodate that hint text.

Defining Mappings

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. Specific security functions grant access to specific integrators. See the product documentation for the functions that must be added to your menu for you 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

  1. 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.

  2. In the Mapping page, select an integrator.

  3. 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.

  4. 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.

  5. 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.

  6. 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 checkbox appears under Lookup in the mapping row for that column name. To perform the ID translation, select the Lookup checkbox for the desired columns.

  7. Choose Apply.

To define a mapping in the simplified Define Mapping page

  1. 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.

  2. 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.

  3. 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.

  4. Enter a name for the mapping.

  5. 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.

  6. 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 checkbox 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 checkbox 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.

  7. 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.

Defining a Style Sheet

A style sheet enables you to define the colors and fonts to apply to the sheet, the prompts, the hints, and the data fields of your document.

Create Style Sheet Page

the picture is described in the document text

  1. From the Oracle E-Business Suite navigator, select the Define Style Sheet 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.

  2. Choose Create to create a new style sheet, or select an existing style sheet and choose Update to modify it. To create a new style sheet based on an existing style sheet, select the existing style sheet and choose Duplicate.

    To delete a style sheet that you no longer need, select the style sheet and choose Delete. Then choose Yes in the confirmation page.

  3. Enter a name and description for the style sheet. The maximum length for the style sheet name is ten characters.

  4. If you want to display a branding image in the documents created with this style sheet, enter the file name of the image. For example, MyCompanyImage.gif. Ensure that you have placed the image in the OA_MEDIA virtual directory. The image you define here for the style sheet overrides any image specified in the Corporate Branding Image for Oracle Applications profile option. However, an image defined at the layout level will override the image defined for the style sheet. See: Implementing Branding Images.

  5. Select a read only color to apply to the background of read-only fields. Read-only fields take the font properties of data fields.

    Use the color picker to select a color, or for additional color options, you can enter the hexadecimal value for the color in the field. For example, enter #A52A2A for brown.

  6. Define the following properties for the sheet as a whole, for the prompts, for the hints, and for the data fields:

    • Background color - Use the color picker to select a color, or for additional color options, you can enter the hexadecimal value for the color in the field.

    • Font color - Use the color picker to select a color, or for additional color options, you can enter the hexadecimal value for the color in the field.

    • Font family - Enter the name of a font family supported by the viewer in which users will view the document.

    • Font style - Select Regular, Italic, Bold Italic, or Bold.

    • Font size - Enter the numerical font size.

  7. Choose Apply.

The following figure shows the style sheet items as they appear on a generated document:

Example Spreadsheet

the picture is described in the document text

Defining Setup Options for Key Flexfields

Oracle Web Applications Desktop Integrator provides the option to set right-justification and zero padding for every segment of a key flexfield, regardless of this setting at the value set level.

Lists of values for flexfields apply character format masks after a segment value has been selected. These format masks such as right-justify and zero padding and maximum character width are derived from the flexfield value set definition. Use the Oracle Web Applications Desktop Integrator Setup Options feature to override the values specified in the value set definition.

If you set the right-justify and zero-fill format mask for a key flexfield segment, then Oracle Web Applications Desktop Integrator performs right-justification and zero padding on the value entered in the spreadsheet based on the segment length and validates the value according to this option before updating the segment value in the interface table.

Note: If you are migrating from the client-server Oracle Applications Desktop Integrator, this provides the equivalent functionality to the Zero Pad Account Values feature.

To set the right-justify and zero-fill format mask for a key flexfield, or for a specific key flexfield structure:

  1. From the Oracle E-Business Suite navigator, select Desktop Integration, then Setup Options, or follow a navigation path provided by your system administrator.

  2. Choose Select Key Flexfields.

  3. To apply the right-justify and zero-fill format mask to every structure of a key flexfield, select the flexfield in the list and choose Apply.

  4. To apply the format mask only to specific structures of a key flexfield, choose Select Structure for the flexfield. Then select the appropriate structures and choose Apply.

The Overridden column displays the number of structures selected.

Note: If you choose this option, you must not modify the format of the cells for the flexfield segments in the spreadsheet. Oracle Web Applications Desktop Integrator sets a custom number format for the flexfield segments in the spreadsheet to enable zero padding. If you change this format, such as by using the Format Cells menu option within Microsoft Excel, by copying and pasting a cell with a different format, or by adding a character such as an apostrophe (') to the cell value, then Oracle Web Applications Desktop Integrator does not perform zero padding for the value, and the value may fail validation and not be updated in the interface table.

Implementing Branding Images

You can include a branding image in your Oracle Web Applications Desktop Integrator spreadsheets to mark the spreadsheets with your corporate logo or otherwise identify the source or owner of the data. Use the BNE Viewer Displays Image profile option to enable or disable branding images. Branding images are enabled by default.

You can specify the image to use at the layout level, at the style sheet level, or through the Corporate Branding Image for Oracle Applications profile option (FND_CORPORATE_BRANDING_IMAGE). You can also use the default Oracle corporate image (/OA_MEDIA/oracle_log.png).

If you have implemented branding images, then when you open a spreadsheet in Microsoft Excel, the image appears in the upper left corner of the sheet.

To implement branding images

  1. Place the images you want to use in the OA_MEDIA virtual directory on your Web server.

  2. Set the BNE Viewer Displays Image profile option to null or Yes.

  3. Optionally specify custom images at the levels you want.

    • Specify an image when defining a layout. See: Defining Layouts.

    • Specify an image when defining a style sheet, and assign that style sheet to the layouts you want. See: Defining a Style Sheet.

    • Specify an image in the Corporate Branding Image for Oracle Applications profile option at user, responsibility, application, or site level. See: Overview of Setting User Profiles, Oracle E-Business Suite Setup Guide.

    Alternatively, if you do not want to specify custom images, you can use the default Oracle corporate image (/OA_MEDIA/oracle_log.png).