This chapter contains the following topics:
The Drill Down feature is available in tabular report sections only. This includes application reports that use tabular sections. You cannot create an audit trail for tabular reports containing row or cell specifications or calculation fields.
The Drill Down feature enables you to research beyond the summary information in the tabular report section and into the detail from which the information was derived. For example, in a tabular report that presents unpaid balances for customers, you can use the Drill Down feature to review each unpaid invoice that contributes to the total unpaid balance. Use the Drill Down feature to associate the data in the report with the related detail in Oracle's JD Edwards EnterpriseOne interactive application.
For financial reports, an audit trail is created when the related JD Edwards EnterpriseOne application opens. The audit trail includes detail regarding the data on the report. The audit trail records are static; therefore, the information in the audit trail might differ from the information in the records that you are auditing. For example, if someone posts a transaction after you run the report, the change is immediately reflected in the table, but it is not reflected in the audit trail.
Important:Because the Drill Down feature requires significant system resources, you should activate this feature only when it is required.
This section provides an overview of how to activate the Drill Down feature, lists the prerequisites, and discusses how to:
Activate and define the Drill Down feature.
Review audit trails.
Purge drill down work files.
You must activate the Drill Down feature before you can define it. You activate and define the Drill Down feature in tabular sections only. This includes financial reports because they use the tabular section type.
You can also activate and define the Drill Down feature in a batch version. When defining the Drill Down feature in a batch version, you must first override the specifications for the section layout and the event rules.
You can activate the Drill Down feature during these activities:
Editing or revising tabular section reports in Oracle's JD Edwards EnterpriseOne Report Design Aid (RDA).
You can access the Drill Down feature on the Tabular Section Properties form. The name of the tab where the Drill Down feature resides depends on the type of section that you create. For a tabular section, the name of the tab is Financial. For a financial report, the name of the tab is Financial Report.
Creating a financial report using the Report Design Director.
Modifying or creating a Report Director template.
Begin defining the Drill Down feature by indicating the JD Edwards EnterpriseOne application where the related detail resides for the data that is presented in the tabular section. As part of the Drill Down feature, you define the:
JD Edwards EnterpriseOne Interactive application
This is the name of the application that is associated with the data that is presented in the tabular report section.
JD Edwards EnterpriseOne interactive applications can include multiple forms. Select the form to appear when the application is launched.
Some JD Edwards EnterpriseOne interactive applications have more than one version. Select the appropriate version to launch. When only one version of the application exists, the system does not present this form.
Note:If the report template has processing options attached, you are prompted to provide the parameters after defining the interactive application.
The next step in defining the Drill Down feature is to map the form interconnect fields in the data structure. The data structure passes field values between the report and the selected interactive application. The data flows in the direction that is indicated by the directional arrows.
Map fields from the business view that is attached to the tabular section to the data items that reside on the selected interactive application form. The fields that you map from the tabular section must be the fields that are required to access the detail in the application. You can verify the fields that are required by launching the interactive application and noting the fields that are required to populate the detail form.
You do not typically need to map all fields that are included in the data structure. After selecting the appropriate fields, you must modify the directional arrows to ensure that the data flows from the tabular section to the associated application.
When reviewing a report online from the web client, a user can click specific data in the report to invoke the Drill Down feature. The data that is clicked must be fetched from the database; the user cannot click data that is calculated using event rules because that data is not entered using the application suite. In Adobe Acrobat Reader, the cursor changes to a pointing index finger when hovered over a field that can be accessed using the defined interactive application. Using the pointing index finger cursor, the user can click the field, and the system automatically launches the associated JD Edwards EnterpriseOne application.
Using the Drill Down feature establishes an audit trail for financial reports, which you can use to view detail about the data in the report. Tabular reports that use the Drill Down feature and are not financial in nature do not create an audit trail.
Each time that you activate the Drill Down feature in a financial report, the system creates a work file. This work file remains in the system until it is manually purged.
The information from the audit trail resides in the Balance Audit Work File-Financial Reporting (F83UI001) table. This work file must be purged periodically to improve processing time. Purge the work file using the Oracle's JD Edwards EnterpriseOne Drill Down Table Purge (P83001) application. You can access the JD Edwards EnterpriseOne Drill Down Table Purge application from both the Microsoft Windows client and the web client. Typically, a system administrator is responsible for purging drill down work files.
Before you define the Drill Down feature, ensure that you:
Create a batch application object.
Complete the design of a financial report template in which you can define the Drill Down feature.
Open a financial report template in RDA.
Double-click the tabular report section for which you want to activate the Drill Down feature.
On the Tabular Section properties form, select the Financial tab.
If you are creating an application report, the system names the tab the same names as the Report Director template. For example, if you select the Financial Reports template in the Director, the tab is named Financial Reports.
Select the Drill Down option, and click the Define button.
You can filter the search by entering search criteria in the QBE (query by example) line.
Click an application, and click Select.
Click a version, and then click Select.
Click Close to avoid selecting a specific version.
If the report has processing options, the system prompts you to provide the parameters.
Double-click the object in the Available Objects list that is associated with the field from the application form.
Fields in the Data Item column of the data structure come from the application that you defined. Mapping the associated field from the report ensures that the value is passed into that field of the application form.
Click the directional arrow in the Dir column until it becomes a right arrow.
The arrow indicates that the data flows from the source (the report section) to the target (the interactive application).
Ensure that you move the cursor down to the next field in the data structure before you select the next available object.
Note:Available objects vary for each <NOT Assigned> field, depending on the field type of the data item.
When all required fields are mapped, click OK.
On the Tabular Section form, click OK to return to the Report Design form.
From the Form menu, select Submitted Jobs.
Within the online report in Adobe Acrobat Reader, position the cursor over the record that you want to research, and click the value.
The Adobe Acrobat Reader displays a message asking if you want to launch the application.
The form that is associated with this report section displays the record that you selected from the report.
Select the record for which you want to display details, and click Select.
The form that is associated with this report displays the details of the record that you are investigating.
When you are finished with the evaluation of the form, click Close.
When you are finished with the evaluation of the records, open the report template in RDA, access the tabular section properties, select the Financial tab, and clear the Drill Down option.