Many of the Oracle Assets reports are available as variable format reports, which means you can view and manipulate the report data in the desktop application of your choice. For example, you can download the information into Microsoft Excel and sort, analyze, and manipulate the report data using familiar spreadsheet features. You can also format the report as an HTML file and place it on your Web server or directly into the database for general access.

To create a variable format report, an attribute set that contains formatting instructions is applied to Oracle Assets report data. You also have a variety of options to publish your report.

In Oracle Applications, attribute sets are defined using the RXi Report Administration Tool. In Applications Desktop Integrator, you can apply ADI defined attribute sets to format and publish your report from the Request Center.

Each Oracle Assets variable format report has two submission options:

• One-Step - You generate, apply an attribute set, and publish your report, all in one step.

  Note: In the list of values on the Submit Request window, for reports you run using the one-step process, the title of the report is followed by RXi. For example, Mass Additions Report: RXi.

• Two-Step - You can generate your report and note the concurrent request ID. Use this ID to apply an attribute set in:

  ADI - apply an ADI defined attribute set using the Request Center to publish your report.

  Oracle Applications - apply an attribute set defined by the RXi Report Administration Tool. Concurrent processing applies the attribute set to your generated report. Additional parameters are applied to publish your report.

  Note: In the list of values on the Submit Request window, for reports you run using the two-step process, the title of the report is preceded by RX-only. For example, RX-only: Mass Additions Report.

To generate and publish a variable format report using the one-step process:

1. Navigate to the Submit Request window and select the variable format report you want to run (report title is followed by RXi).

2. Enter the parameters in the Parameters window.

3. Choose OK.

4. Submit your request.

   Your one-step report will be published automatically.

   Note: Two concurrent request IDs are created: one initial ID to generate your report and a second ID to apply formatting and to publish your report.

To generate and publish a variable format report using the two-step process:

1. Navigate to the Submit Request window and select the variable format report you want to run (report title is preceded by RX-only).

2. Enter the parameters in the Parameters window.

3. Choose OK.

4. Submit your request. Note the concurrent request ID for your request.

5. Navigate to the Submit Request window and select Publish RXi Report.

   The Parameters window appears.

6. Enter the Request ID.

7. Specify the Attribute Set you want to apply to your report.

8. Specify the Output Format: Text, HTML, CSV, or Tab Delimited.

   Your report will be published as specified.

To publish a variable format report in ADI using the two-step process:

1. Navigate to the Submit Request window and select the variable format report you want to run (report title is preceded by RX-only).

2. Complete the remaining parameters and submit your request.

3. Note the Concurrent Request ID for your report.

4. Launch the Request Center and log onto the database where your generated report is stored.

5. Select the report with your Request ID from the list under the Completed tab.

6. From the Request Center toolbar, choose the Publishing button.

   The Report Submission and Publishing window appears.

7. Apply an ADI defined attribute set and complete the remaining fields in the Report Submission and Publishing window.

8. Choose OK to publish your report.

Other Sources

• Oracle Applications Desktop Integrator User's Guide

• Oracle Financials RXi Report Administration Tool User's Guide