23 Creating Reports

This chapter describes how to create Oracle Application Server ProcessConnect reports.

This chapter contains these topics:

• Reports Overview

• Creating Process Monitoring Reports

• Creating Activity Monitoring Reports

• Creating Process Optimization Reports

• Specifying the Layout of Your Report

• Reviewing Your Selections Before Creation

• Reviewing Your Output

• Report Creation Examples

• Common User Errors

• Chapter Summary

  
  

  Note: Do not use the Back or Forward buttons of your Web browser when creating reports. Instead, use the Back and Next buttons specifically provided by the report creation pages. This ensures that the correct information displays in each page.

  
  
  
  

  See Also: Chapter 3, "Oracle Application Server ProcessConnect Concepts" for conceptual details about events and coordinations Chapter 21, " Oracle Application Server ProcessConnect Error Handling " for additional details about error states

  
  

23.1 Reports Overview

Business data exists in the runtime repository as business processes are executed. The Oracle Application Server ProcessConnect user interface tool enables you to query this information to see what is occurring and to perform business analysis. You can query this information in several different ways based on the type that you want. Specifically, you can query for information such as events, business processes, and errors. For example, you create a query for the total and average values of purchase orders in the last month. For these types of information, Oracle Application Server ProcessConnect also enables you to either see the status of a specific event or the aggregate status on a group of events.

This section contains these topics:

• Configuration Support in Reports

• Process Monitoring Reports

• Activity Monitoring

• Process Optimization

  
  

  Note: Some report creation pages include lists that enable you to make multiple selections (for example, the Event State list, Coordination list, Party list, and Available Fields list). To do this, hold down the Ctrl key while making multiple selections.

  
  
  
  

  See Also: "Deploying a Configuration" for instructions on selecting a report logging level before deploying a configuration

  
  

23.1.1 Configuration Support in Reports

The first page of questions that displays for each report is the Parameters page. The values (such as the event types) available for selection on this page are based on the selected configuration. By default, these values are from the latest deployed configuration. However, you can also select Unspecified or select a different configuration from the Configuration Name list. In both these cases, the page refreshes to display values (such as business processes) applicable to your selection. To see the list of event types available with your selection, you must then click Specify Event and click the flashlight.

This section describes the values available with each configuration selection:

• Values Available when the Default Configuration is Selected

• Values Available when Unspecified is Selected

• Values Available when a Different Configuration is Selected

23.1.1.1 Values Available when the Default Configuration is Selected

The following values are available for selection when the default configuration is selected. This is the selected configuration when you initially access the Parameters page:

• The list of values available for selection are from the latest deployed configuration.

• The event types that display for selection when you click the flashlight next to the Name field on the Parameters page are from the latest deployed configuration. For Event Status, Coordination Status, and Error Status reports, the Name field displays after you select Specify Event. For Event Analysis reports, the field automatically displays.

• The event type structure that displays in the Event Content Query Expression and Event Fields sections of the Event Content page for both the Event Status and Activity Monitoring reports is from the latest deployed configuration.

• The business process structure that displays in the two Port pages of the Coordination Analysis report is from the latest deployed configuration.

• All queries are executed against the latest deployed configuration.

23.1.1.2 Values Available when Unspecified is Selected

The following values are available for selection when you select Unspecified from the Configuration Name list:

• The list of values available for selection are from all configurations, with any duplicate names removed.

• The event types that display for selection when you click the flashlight next to the Name field on the Parameters page are from the latest deployed configuration. For Event Status, Coordination Status, and Error Status reports, the Name field displays after you select Specify Event. For Event Analysis reports, the field automatically displays.

• The event type structure that displays in the Event Content Query Expression and Event Fields sections of the Event Content page for both the Event Status and Activity Monitoring reports is from the latest deployed configuration.

• The business process structure that displays in the two Port pages of the Coordination Analysis report is from the latest deployed configuration.

• All queries are executed against all configurations.

23.1.1.3 Values Available when a Different Configuration is Selected

The following values are available for selection when you select a specific configuration (for example, i_Procure_v1) from the Configuration Name list:

• The list of values available for selection are from the i_Procure_v1 configuration.

• The event types that display for selection when you click the flashlight next to the Name field on the Parameters page are from the i_Procure_v1 configuration. For Event Status, Coordination Status, and Error Status reports, the Name field displays after you select Specify Event. For Event Analysis reports, the field automatically displays.

• The event type structure that displays in the Event Content Query Expression and Event Fields sections of the Event Content page for both the Event Status and Activity Monitoring reports is from the i_Procure_v1 configuration.

• The business process structure that displays in the two Port pages of the Coordination Analysis report is from the i_Procure_v1 configuration.

• All queries are executed against the i_Procure_v1 configuration.

23.1.2 Process Monitoring Reports

The Oracle Application Server ProcessConnect user interface tool enables you to create process monitoring (also known as status) reports. Status reports show the current status of events, coordinations, errors, collaborations, and business messages in an integration.

They are best used to either monitor the status of events or business processes or debug the progress of a specific deployed integration.

Status reports provide a snapshot of the integration process. The following types of status reports are provided:

• Events

  Event status reports provide information on the status of events. For example, these reports can identify what has occurred with a specific purchase order received from a procurement system that has not yet been placed in the general ledger. This enables you to see whether events are active, consumed, in an error state, or waiting for instance processing.

• Coordinations

  Coordination status reports provide information on the status of a specific coordination. For example, these reports can identify all coordinations with a specific trading partner within a specific period of time. This enables you to see whether specific coordinations have aborted, closed, or remained open.

• Errors

  Error status reports enable you to view details about errors occurring in an integration. You can create reports that provide details on all errors or you can create reports that provide details about a specific type of error (for example, the error type, error class, and error code).

• Collaborations

  Collaboration reports enable you to generate reports about the collaboration name (such as RosettaNet partner interface process (PIP) 01A, 3A4, or 3A6) in an integration.

• Business messages

  Business message status reports enable you to identify details about the sending trading partner in an integration, such as their collaboration name, actor role (for example, buyer or seller), protocol message identification (ID), and exchange protocol (RosettaNet).

  
  

  See Also: "Creating Process Monitoring Reports" for procedural instructions on creating process monitoring reports The following examples of creating process monitoring reports: "Monitoring iProcurement Process Status" "Monitoring Coordination Details" "Monitoring Current Errors in an Integration"

  
  

23.1.3 Activity Monitoring

Activity monitoring reports analyze specific business activities across integration objects (for example, the total number of event instances sent by a specific party during this quarter).

See Also: "Creating Activity Monitoring Reports" for procedural instructions on creating activity monitoring reports "Monitoring the Total and Average Amount of Desktop Personal Computers for this Month" for an example of an activity monitoring report

23.1.4 Process Optimization

Process optimization reports monitor business process efficiency (for example, the response time for orders placed by a specific party during the last month).

See Also: "Creating Process Optimization Reports" for procedural instructions on creating process optimization reports "Monitoring Business Process Efficiency" for an example of a process optimization report

23.2 Creating Process Monitoring Reports

Process monitoring reports monitor the current state of an integration object (for example, an event instance).

The following process monitoring reports are provided:

• Event Status Report

• Coordination Status Report

• Error Status Report

• Collaboration Status Report

• Business Message Status Report

There are a number of elements of information in process monitoring reports that you can choose to specify. Some information is necessary to run or create the report. Other parameters are advanced and optional and designed to enable you to further narrow the scope of a query.

Process monitoring reports are structured in a consistent manner. On the first page, you can choose to specify mandatory and optional parameters necessary to create the report. Other advanced parameters can be specified on a second page, if necessary. Final pages enable you to specify the layout of your report information and view a summary of the report to create.

23.2.1 Event Status Report

Follow these instructions to create an event status report. The pages that appear are part of a wizard in which you enter information that appears in a final report.

Table 23-1 provides an overview of the pages that appear.

Table 23-1 Event Status Report Pages Overview

Page	Description
Event Report: Parameters	A page that consists of two sections: A section for specifying basic parameters such as a report name, start and end dates for gathering data, event type classification (native, application, or business), event type names, and event states (active, consumed, error, or wait). While only the report name is mandatory, specifying these other parameters enables you to narrow the scope of your report. An advanced section for specifying optional parameters such as the business process, coordination state (aborted, closed, or open), parties involved in the agreement, and configuration name.
Event Report: Event Content	A page that enables you to specify querying events based on content (such as querying for all purchase order amounts over $1000). You can also specify the event fields to display in the report.
Event Report: Layout	A page that enables you to specify the layout of information in your report, such as specifying the column names and order of their appearance in the report.
Event Report: Review	A page that enables you to review your selections before creating the report.

To create an event status report:

1. Select the Reports tab.

2. Select the Process Monitoring tab.

3. Select Event Status.

23.2.1.1 Specify Event Status Report Parameters

The Event Report: Parameters page appears.

1. Enter a unique and recognizable name in the Name field or accept the default name of Event Status Report. This is the only mandatory field on this page.

2. Click the calendar icon for the Start Date field to select a date at which to begin gathering report data.

3. Click the calendar icon for the End Date field to select a date at which to stop gathering report data.

4. If you want to specify a specific event classification and event type name, click the Specify Event box. The page refreshes to display the following fields:

   1. Select Application Event Type, Business Event Type, or Native Event Type from the Classification list.

   2. Click the flashlight to select the specific event type name for the Name field. Only event type names that are part of a deployed configuration display in this list; event types that are only in the design-time repository do not appear.

      
      

      Note: You must use the flashlight to select an event type name. Do not manually enter a name in the Name field.

      
      

   3. If you want to specify querying events (for example, query for all purchase order amounts over $1000) based on content or to select event fields for your report, select the Specify Event content box and ensure that you specified an event type name in Step 4b.

5. Select an event state from the Event State list or select Unspecified to select all event states:

State	Description
Active	The event is currently processing.
Consumed	Event processing has completed. The event can no longer be used. Consumed events are only used for correlation or during monitoring. A consumed event cannot be copied or sent for additional processing.
Error	An error occurred during the event lifecycle.
Wait	The event is potentially out of order and cannot currently be processed.

The wizard page that displays next is based on selections you made in Step 4 and are about to make on this Event Report: Parameters page.

6. See the following sections based on your selections:

If You...	Then...
Want to specify advanced report parameters	Click Show Advanced Report Options. Go to "Specify Advanced Event Status Report Parameters".
Selected a specific event type name in Step 4b and selected the Specify Event content box in Step 4c	Click Next. Go to "Specify Event Contents".
Do not want to perform either of these tasks	Click Next. Go to "Specifying the Layout of Your Report".

23.2.1.2 Specify Advanced Event Status Report Parameters

1. Select the business process for which to create a report from the Business Process list.

2. Select a status from the Coordination State list. If you select Unspecified, all coordination states are included in the report.

   State	Description
   aborted	Coordination processing has been aborted.
   closed	Coordination processing has completed.
   open	Coordination processing is occurring.

   
   

3. Select the sending party from the From Party list. Only parties included in deployed configurations appear.

4. Select the receiving party from the To Party list. Only parties included in deployed configurations appear.

5. Select the configuration for which to create a report from the Configuration Name list. See "Configuration Support in Reports" for details about the type of information that appears in fields based on your selection.

6. Click Next.

7. See the following section based on your selections.

   If You...	Then...
   Selected a specific event type name in Step 4b and selected the Specify Event content box in Step 4c	Go to "Specify Event Contents".
   Did not perform this task	Go to "Specifying the Layout of Your Report".

   
   

23.2.1.3 Specify Event Contents

If you selected a specific event type name in Step 4b and selected the Specify Event content box in Step 4c, the Event Report: Event Content page appears. This page enables you to create conditional expressions on event content (for example, query for purchase order amounts over $1000) and select event fields for the summary and detail reports.

1. Go to the Event Content Query Expression section.

2. Select Condition expression not specified.

3. Click Update to build a new condition.

   The Create Condition Expression page appears.

4. Click Expand All or select a specific entry to expand in the Left Operand column to display the contents of the selected event.

5. Select a name.

6. Select an operator from the Operator list (for example, =):

   • != (not equal to)

   • < (less than)

   • <= (less than or equal to)

   • = (equal to)

   • > (greater than)

   • >= (greater than or equal to)

7. Enter a value in the Right Operand field.

8. Click Apply.

   The results display onscreen.

9. Go to the Event Fields section.

10. Click Expand All or select a specific entry to expand.

11. If you want, you can select the event fields to use in the summary report and details reports. A later page in this wizard enables you to specify the order in which these fields display in the reports.

    These fields provide the following functionality:

    • Summary Report Grouping

      Select Yes to include this event field in the summary report.

    • Detail Report Inclusion

      Select Yes to include this event field in the details reports.

    • Alias

      Use the default alias or specify a different name to use as the column name in the report.

12. Click Next.

13. Go to "Specifying the Layout of Your Report".

23.2.2 Coordination Status Report

Follow these instructions to create a coordination status report. The pages that appear are part of a wizard in which you enter information that appears in a final report.

Table 23-2 provides an overview of the pages that appear.

Table 23-2 Coordination Status Report Pages Overview

Page	Description
Coordination Report: Parameters	A page that consists of two sections: A section for specifying basic parameters such as a report name, start and end dates for gathering data, business process, and coordination state (aborted, closed, or open). While only the report name is mandatory, specifying these other parameters enables you to narrow the scope of your report. An advanced section for specifying parameters such as the event type classification (native, application, or business), event type names, event state (active, consumed, error, or wait), parties involved in the agreement, and configuration name.
Coordination Report: Layout	A page that enables you to specify the layout of information in your report, such as specifying the column names and order of their appearance in the report.
Coordination Report: Review	A page that enables you to review your selections before creating the report.

To create a coordination status report:

1. Select the Reports tab.

2. Select the Process Monitoring tab.

3. Select Coordination Status.

23.2.2.1 Specify Coordination Status Report Parameters

The Coordination Report: Parameters page appears.

1. Enter a unique and recognizable name in the Name field or accept the default name of Coordination Status Report. This is the only mandatory field on this page.

2. Click the calendar icon for the Start Date field to select a date at which to begin gathering report data.

3. Click the calendar icon for the End Date field to select a date at which to stop gathering report data.

4. Select the business process for which to create a report from the Business Process list.

5. Select a status from the Coordination State list. If you select Unspecified, all coordination states are included in the report.

   State	Description
   aborted	Coordination processing has been aborted.
   closed	Coordination processing has completed.
   open	Coordination processing is occurring.

   
   

6. See the following section based on whether you want to specify advanced report parameters.

   If You...	Then...
   Want to specify advanced report parameters	Click Show Advanced Report Options. Go to "Specify Advanced Coordination Status Report Parameters".
   Do not want to specify advanced report parameters	Click Next. Go to "Specifying the Layout of Your Report".

   
   

23.2.2.2 Specify Advanced Coordination Status Report Parameters

1. If you want to specify a specific event, click the Specify Event box and perform Steps 0` through 0b. You must perform these steps if you want to go to the next page in this wizard.

   1. Select the Application Event Type, Business Event Type, or Native Event Type from the Classification list.

   2. Click the flashlight to select the specific event type name for the Name field. Only event type names that are part of a deployed configuration display in this list; event types that are only in the design-time repository do not appear.

      
      

      Note: You must use the flashlight to select an event type name. Do not manually enter a name in the Name field.

      
      

2. Select an event state from the Event State list or select Unspecified to select all event states:

   State	Description
   Active	The event is currently processing.
   Consumed	Event processing has completed. The event can no longer be used. Consumed events are only used for correlation or during monitoring. A consumed event cannot be copied or sent for additional processing.
   Error	An error occurred during the event lifecycle.
   Wait	The event is potentially out of order and cannot currently be processed.

   
   

3. Select the sending party from the From Party list. Only parties included in deployed configurations appear.

4. Select the receiving party from the To Party list. Only parties included in deployed configurations appear.

5. Select the configuration for which to create a report from the Configuration Name list. See "Configuration Support in Reports" for details about the type of information that appears in fields based on your selection.

6. Click Next.

7. Go to "Specifying the Layout of Your Report".

23.2.3 Error Status Report

Follow these instructions to create an error status report. The pages that appear are part of a wizard in which you enter information that appears in a final report.

Table 23-3 provides an overview of the pages that appear.

Table 23-3 Error Status Report Pages Overview

Page	Description
Error Report: Parameters	A page that consists of two sections: A section for specifying basic parameters such as a report name, start and end dates for gathering data, error class (system or domain), error code, and error message. While only the report name is mandatory, specifying these other parameters enables you to narrow the focus of your report. An advanced section for specifying optional parameters such as event type classification (native, application, or business), event type name, business process, coordination state (aborted, closed, or open), parties involved in the agreement, and configuration name.
Error Report: Error Event Content	A page that enables you to specify querying events based on content.
Error Report: Layout	A page that enables you to specify the layout of information in your report, such as specifying the column names and order of their appearance in the report.
Error Report: Review	A page that enables you to review your selections before creating the report.

To create an error status report:

1. Select the Reports tab.

2. Select the Process Monitoring tab.

3. Select Error Status.

23.2.3.1 Specify Error Status Report Parameters

The Error Report: Parameters page appears.

1. Enter a unique and recognizable name in the Name field or accept the default name of Error Status Report. This is the only mandatory field on this page.

2. Click the calendar icon for the Start Date field to select a date at which to begin gathering report data.

3. Click the calendar icon for the End Date field to select a date at which to stop gathering report data.

4. Select a specific error class or select Unspecified for all error classes in the Error Class list:

   • Domain

     These are errors that impact events in a specific Oracle Application Server ProcessConnect middle-tier instance. An example of a domain error occurrence is when the runtime system uses an incorrectly-created event transformation map.

   • System

     These are errors that impact the entire system, and not just Oracle Application Server ProcessConnect. Examples of system error occurrences include a database being down, a disk being full, or network connectivity problems.

5. Enter specific error codes for which to search in the Error Code field (separated by commas) or leave this field blank to search for all errors.

6. Enter a specific error message in the Error Message field for which to search or leave this field blank to search for all errors.

7. See the following section based on whether you want to specify advanced report parameters.

   If You...	Then...
   Want to specify advanced report parameters	Click Show Advanced Report Options. Go to "Specify Advanced Error Status Report Parameters".
   Do not want to specify advanced report parameters	Click Next. Go to "Specifying the Layout of Your Report".

   
   

23.2.3.2 Specify Advanced Error Status Report Parameters

1. If you want to specify a specific event, click the Specify Event box and perform Steps 0` through 0b. Otherwise, go to Step 2.

   1. Select the Application Event Type, Business Event Type, or Native Event Type from the Classification list.

   2. Click the flashlight to select the specific event type name for the Name field. Only event type names that are part of a deployed configuration display in this list; event types that are only in the design-time repository do not appear. If you want to specify querying events based on content on a later page, ensure that you specify an event type name.

      
      

      Note: You must use the flashlight to select an event type name. Do not manually enter a name in the Name field.

      
      

2. Select the business process for which to create a report from the Business Process list.

3. Select a status from the Coordination State list. If you select Unspecified, all coordination states are included in the report.

   State	Description
   aborted	Coordination processing has been aborted.
   closed	Coordination processing has completed.
   open	Coordination processing is occurring.

   
   

4. Select the sending party from the From Party list. Only parties included in deployed configurations appear.

5. Select the receiving party from the To Party list. Only parties included in deployed configurations appear.

6. Select the configuration for which to create a report from the Configuration Name list. See "Configuration Support in Reports" for details about the type of information that appears in fields based on your selection.

7. See the following section based on your selection at Step 0.

   If You...	Then...
   Selected the Specify Event box in Step 0 and selected a specific event type name in Step 0b	Click Next. Go to "Specify Event Contents".
   Did not perform this task	Click Next. Go to "Specifying the Layout of Your Report".

   
   

23.2.3.3 Specify Event Contents

If you selected the Specify Event box in Step 0 and selected a specific event type name in Step 0b, the Error Report: Error Event Content page appears. This page enables you to create conditional expressions on event content.

1. Go to the Event Content Query Expression section.

2. Select Condition expression not specified.

3. Click Update to build a new condition.

   The Create Condition Expression page appears.

4. Click Expand All or select a specific entry to expand in the Left Operand column to display the contents of the selected event.

5. Select a name.

6. Select an operator from the Operator list (for example, =):

   • != (not equal to)

   • < (less than)

   • <= (less than or equal to)

   • = (equal to)

   • > (greater than)

   • >= (greater than or equal to)

7. Enter a value in the Right Operand field.

8. Click Apply.

   The results display onscreen.

9. Click Next.

10. Go to "Specifying the Layout of Your Report".

23.2.4 Collaboration Status Report

Follow these instructions to create a collaboration status report. The pages that appear are part of a wizard in which you enter information that appears in a final report.

To create a collaboration status report:

1. Select the Reports tab.

2. Select the Process Monitoring tab.

3. Select Collaboration Status.

23.2.4.1 Specify Report Parameters

The Collaboration Report: Parameters page appears.

1. Enter the following details:

   Field	Description
   Collaboration Name	Select the collaboration name (for example, 0A1, 3A4, or 3A6).
   Protocol Collaboration ID	Enter the protocol message ID.
   Configuration Name	Select the configuration name.

   
   

2. Click Finish.

3. Go to "Reviewing Your Output".

23.2.5 Business Message Status Report

Follow these instructions to create a business message status report. The pages that appear are part of a wizard in which you enter information that appears in a final report.

To create a business message status report:

1. Select the Reports tab.

2. Select the Process Monitoring tab.

3. Select Business Message Status.

23.2.5.1 Specify Report Parameters

The Business Message Report: Parameters page appears.

1. Enter the following details:

   Field	Description
   Sending Trading Partner	Select the trading partner sending the message.
   Collaboration Name	Select the collaboration name of the trading partner (for example, 0A1, 3A4, or 3A6). Your selection causes only those actors applicable to the collaboration name to display in the Actor field.
   Actor	Select the actor type for the collaboration name you selected in the Collaboration Name list: Buyer Seller Failure Report Administrator PIP Failure Notifier
   Protocol Message ID	Enter the protocol message ID.
   Exchange Protocol	Select RosettaNet.
   Configuration Name	Select the configuration name.

   
   

2. Click Finish.

3. Go to "Reviewing Your Output"

23.3 Creating Activity Monitoring Reports

Activity monitoring reports analyze specific business activities across integration objects (for example, the total number of event instances sent by a specific party during this quarter).

Follow these instructions to create an activity monitoring report. The pages that appear are part of a wizard in which you enter information that appears in a final report.

Table 23-4 provides an overview of the pages that appear.

Table 23-4 Activity Monitoring Report Pages Overview

Page	Description
Event Analysis Report: Parameters	A page that consists of two sections: A section for specifying basic parameters such as a report name, start and end dates for gathering data, event type classification (native, application, or business), event type name, and event state (active, consumed, error, or wait). The report name, event type classification (native, application, or business), and event type name are mandatory. You can also specify other parameters to narrow the scope of your report. An advanced section for specifying optional parameters such as business process, the coordination state (aborted, closed, or open), the parties involved in the agreement, and the configuration name.
Event Analysis Report: Event Content	A page that enables you to specify querying events based on content.
Event Analysis Report: Layout	A page that enables you to specify the layout of information in your report, such as specifying the column names and order of their appearance in the report.
Event Analysis Report: Review	A page that enables you to review your selections before creating the report.

To create an activity monitoring report:

1. Select the Reports tab.

2. Select the Activity Monitoring tab.

23.3.1 Specify Activity Monitoring Report Parameters

The Event Analysis Report: Parameters page appears.

1. Enter a unique and recognizable name in the Name field or accept the default name of Event Analysis Report. This is a mandatory field.

2. Click the calendar icon for the Start Date field to select a date at which to begin gathering report data.

3. Click the calendar icon for the End Date field to select a date at which to stop gathering report data.

4. Select the Application Event Type, Business Event Type, or Native Event Type from the Classification list. This is a mandatory field.

5. Click the flashlight to select the specific event type name for the Name field. Only event type names that are part of a deployed configuration display in this list; event types that are currently in the design-time repository do not appear. This is a mandatory field. You must select a name or you cannot go to the next page in this wizard.

   
   

   Note: You must use the flashlight to select an event type name. Do not manually enter a name in the Name field.

   
   

6. Select an event state from the Event State list or select Unspecified to select all event states:

   State	Description
   Active	The event is currently processing.
   Consumed	Event processing has completed. The event can no longer be used. Consumed events are only used for correlation or during monitoring. A consumed event cannot be copied or sent for additional processing.
   Error	An error occurred during the event lifecycle.
   Wait	The event is potentially out of order and cannot currently be processed.

   
   

   The wizard page that displays next is based on selections you made in Step 5 or are about to make on this Event Analysis Report: Parameters page.

7. See the following sections based on your selections:

   If You...	Then...
   Want to specify advanced report parameters	Click Show Advanced Report Options. Go to "Specify Advanced Activity Monitoring Report Parameters". Note: You cannot access these advanced parameters until you use the flashlight to select an event type name for the Name field in Step 5.
   Selected a specific event type name in Step 5 and do not want to specify advanced report parameters	Click Next. Go to "Specify Event Contents".

   
   

23.3.2 Specify Advanced Activity Monitoring Report Parameters

1. Select the business process for which to create a report from the Business Process list.

2. Select a status from the Coordination State list. If you select Unspecified, all coordination states are included in the report.

   State	Description
   aborted	Coordination processing has been aborted.
   closed	Coordination processing has completed.
   open	Coordination processing is occurring.

   
   

3. Select the sending party from the From Party list. Only parties included in deployed configurations appear.

4. Select the receiving party from the To Party list. Only parties included in deployed configurations appear.

5. Select the configuration for which to create a report from the Configuration Name list. See "Configuration Support in Reports" for details about the type of information that appears in fields based on your selection.

23.3.3 Specify Event Contents

If you selected a specific event type name in Step 5, the Event Analysis Report: Event Content page appears. This page enables you to create conditional expressions on event content and select event fields and their aggregation type for the summary and details reports.

1. Go to the Event Content Query Expression section.

2. Select Condition expression not specified.

3. Click Update to build a new condition.

   The Create Condition Expression page appears.

4. Click Expand All or select a specific entry to expand in the Left Operand column to display the contents of the selected event.

5. Select a name.

6. Select an operator from the Operator list (for example, =):

   • != (not equal to)

   • < (less than)

   • <= (less than or equal to)

   • = (equal to)

   • > (greater than)

   • >= (greater than or equal to)

7. Enter a value in the Right Operand field.

8. Click Apply.

   The results display onscreen.

9. Click Next.

10. Go to the Event Fields section.

11. Click Expand All or select a specific entry to expand.

12. If you want, you can select the event fields to use in the summary report and details reports. A later page in this wizard enables you to specify the order in which these fields display in the reports.

    These fields provide the following functionality:

    • Aggregation Type

      Select Average to calculate the average, Sum to add the total amount, or Both to perform both calculations on the condition expression you created in Steps 4 through 8.

      
      

      Note: Ensure that the string fields selected for Sum or Average have numeric content. Otherwise, blank Sum and Average columns appear in the final report.

      
      

    • Summary Report Grouping

      Select Yes to include this event field in the summary report.

    • Detail Report Inclusion

      Select Yes to include this event field in the details reports.

    • Alias

      Use the default alias or specify a different name to use as the column name in the report.

13. Click Next.

14. Go to "Specifying the Layout of Your Report".

23.4 Creating Process Optimization Reports

Process optimization reports monitor business process efficiency (for example, the response time for orders placed by a specific party during the last month).

Follow these instructions to create a process optimization report. The pages that appear are part of a wizard in which you enter information that appears in a final report.

To create a process optimization report:

1. Select the Reports tab.

2. Select the Process Optimization tab.

Table 23-5 provides an overview of the pages that appear.

Table 23-5 Process Optimization Report Pages Overview

Page	Description
Coordination Analysis Report: Parameters	A mandatory page for specifying basic parameters such as a report name, start and end dates for gathering data, business process, coordination state (aborted, closed, or open), and configuration name. While only the report name is mandatory, specifying these other parameters enables you to narrow the focus of your report.
Coordination Analysis Report: Ports	A page on which you must specify a specific role or step port as the first port endpoint for collecting data.
Coordination Analysis Report: Ports	A page on which you must specify a specific role or step port as the second port endpoint for collecting data.
Coordination Analysis Report: Layout	A page that enables you to specify the layout of information in your report, such as specifying the column names and order of their appearance in the report.
Coordination Analysis Report: Review	A page that enables you to review your selections before creating the report.

23.4.1 Specify Process Optimization Report Parameters

The Coordination Analysis Report: Parameters page appears.

1. Enter a unique and recognizable name in the Name field or accept the default name of Coordination Analysis Report. This is the only mandatory field on this page.

2. Click the calendar icon for the Start Date field to select a date at which to begin gathering report data.

3. Click the calendar icon for the End Date field to select a date at which to stop gathering report data.

4. Select the business process for which to create a report from the Business Process list.

5. Select a status for the business process from the Coordination State list. If you select Unspecified, all coordination states are included in the report.

   State	Description
   aborted	Coordination processing has been aborted.
   closed	Coordination processing has completed.
   open	Coordination processing is occurring.

   
   

6. Select the configuration for which to create a report from the Configuration Name list. See "Configuration Support in Reports" for details about the type of information that appears in fields based on your selection.

7. Click Next.

23.4.2 Specify the First Port

The first Coordination Analysis Report: Ports page appears.

1. Click a specific business process to expand or click Expand All to display all role ports and step ports integrated with this business process.

2. Select a specific port as the first endpoint for collecting report data. This is a mandatory task.

3. Select the sending party from the From Party list. Only parties included in deployed configurations appear.

23.4.3 Specify a Second Port

The second Coordination Analysis Report: Ports page appears.

1. Click a specific business process to expand or click Expand All to display all role ports and step ports integrated with this business process.

2. Select a specific port as the second endpoint for collecting report data. This is a mandatory task. Your port selections determine the total amount of time it takes for an event to enter one port and exit through the other port. This is useful for determining the efficiency of your business process.

3. Select the outgoing party from the From Party list. Only parties included in deployed configurations appear.

4. Click Next.

5. Go to "Specifying the Layout of Your Report".

23.5 Specifying the Layout of Your Report

The Report: Layout page appears and enables you to specify the layout of information in your report. The fields available for selection are based on your selections in the Parameters page and any additional fields you selected in the Event Content page. The left-most column that you specify in your layout determines the method by which information is sorted in your report. If you want to change the order by which information is sorted, then switch the column order on this page.

Column headers displaying in top-to-bottom order in the Selected Fields lists described in this section appear in left-to-right order, respectively, in the final summary and details reports.

1. Go to the Grouping Fields section to select summary report column headers.

2. Select the column headers in the Available Fields list.

3. Click Move to copy a column header or Move All to copy all column headers to the Selected Fields list.

4. Go to the Details Fields section to select details report column headers.

5. Select the column headers in the Available Fields list.

6. Click Move to copy a column header or Move All to copy all column headers to the Selected Fields list.

7. Enter optional comments in the Comments field. These comments appear under the report title.

8. Click Next.

9. Go to "Reviewing Your Selections Before Creation" to review your selections.

23.6 Reviewing Your Selections Before Creation

The Report: Review page appears. The selections that you have made on previous pages of the wizard appear.

1. Review your selections. If you want to make changes, click the Back button provided by the wizard.

2. Click Finish when satisfied with your selections.

3. Go to "Reviewing Your Output".

23.7 Reviewing Your Output

See one of the following sections based on the type of report you created:

• Reviewing Business Message and Collaboration Status Report Output

• Reviewing the Report Output for All Others

  
  

  See Also: "Report Creation Examples"

  
  

23.7.1 Reviewing Business Message and Collaboration Status Report Output

The report is generated and displays onscreen. You cannot customize the fields that display in these types of reports. The summary report provides links to instance data reports.

23.7.2 Reviewing the Report Output for All Others

The report is generated and displays onscreen. Separate tables display for the summary and detail reports with the column headers you selected in the Report: Layout page. The summary report provides links to the details report. The details report provides additional links to instance data in the Details column.

23.8 Report Creation Examples

This section provides examples of creating reports.

Table 23-6 lists the report examples provided:

Table 23-6 Report Examples

Report Type	Example
Process Monitoring:
Event Status	"Monitoring iProcurement Process Status"
Coordination Status	"Monitoring Coordination Details"
Error Status	"Monitoring Current Errors in an Integration"
Activity Monitoring	"Monitoring the Total and Average Amount of Desktop Personal Computers for this Month"
Process Optimization	"Monitoring Business Process Efficiency"

See Also: "Creating Reports" to create a report as part of the tutorial

23.8.1 Monitoring iProcurement Process Status

This example describes how to monitor the status of iProcurement purchase orders moving through Oracle Application Server ProcessConnect during a specific time period.

1. Select Reports > Process Monitoring.

2. Enter a unique and recognizable name in the Name field or accept the default name.

3. Click the calendar icon for the Start Date field to select the date of one month ago.

4. Leave the End Date field blank to indicate today’s date.

5. Click the Specify Event box.

6. Select Application Event Type from the Classification list.

7. Click the flashlight to select the specific event type name for the Name field. For this example, an event named ServiceRequest is selected.

   The Event Report: Parameters page displays your selections:

Description of the illustration rep_es1.gif

8. Click Finish.

   The Summary Report of the Event Status Report page appears and indicates that six iProcurement purchase order requests were processed in the last month.

Description of the illustration rep_es2.gif

9. Click Details to display the Details page.

Description of the illustration rep_es3.gif

This page displays the application event types consumed with each of the six purchase order requests over the past month. Since these events have all completed processing, their state display as consumed. The times at which these events were created also display in the Event Timestamp column.

10. Click Details for a specific event classification.

    This details page displays the roles and steps that processed this event, their current status, and the time the event was last modified in that role or step. Details about the predecessor (native) and successor (business) events for the selected event (application) also display.

Description of the illustration rep_es10.gif

If this is an event details report for a native event, Correlated To and Correlated By sections display details about any initiating and target native event instances that have been correlated. An Event Payload window also displays the contents of the native format file (for example, the contents of an XML file).

23.8.2 Monitoring Coordination Details

This example describes how to monitor coordination details.

1. Select Reports > Process Monitoring > Coordination Status.

2. Enter a unique and recognizable name in the Name field or accept the default name.

3. Click the calendar icon for the Start Date field to select the date of one week ago.

4. Leave the End Date field blank.

5. Click Finish.

   The Summary Report of the Coordination Status Report page appears.

Description of the illustration rep_cs1.gif

The total number of coordinations processed in the last week appears.

6. Click Details.

   The Details Report of the Coordination Status Report page appears.

Description of the illustration rep_cs2.gif

A timestamp indicates when coordination processing completed.

7. Click Details for a specific coordination.

   A second Coordination Details page appears. The upper portion of this page displays details such as the roles within this coordination, the steps within those roles, their current status, and their creation time.

Description of the illustration rep_cs3.gif

8. Expand a specific role to display additional report details about steps.

   The lower portion of this page displays the events in this coordination, their event classification, and the role or step port in which they were processed.

Description of the illustration rep_cs4.gif

23.8.3 Monitoring Current Errors in an Integration

This example describes how to identify the event errors that have occurred during a specific period of time.

1. Select Reports > Process Monitoring > Error Status.

2. Enter a unique and recognizable name in the Name field or accept the default name.

3. Click the calendar icon for the Start Date field to select the date of one week ago.

4. Leave the End Date field blank to indicate today’s date.

5. Click Finish. The Summary Report of the Error Status Report page displays the number of errors occurring in the past week.

6. Click Details. The Details Report of the Error Status Report page appears.

   The Error Timestamp column indicates when the error first occurred. The Last Occurred Timestamp column indicates the last time the error occurred. The Retry Count column indicates the number of retries that were attempted to recover from the error.

Description of the illustration rep_err1.gif

If this is a domain error associated with an event, two additional links can appear along with the link in the Details column. These additional links provide access to the Event Instance Details page and the Coordinations Instance details page.

7. Click Details in the Details column.

   The Error Details page displays specific details about the error, including error class, code, and message. In this example, a system error occurred.

Description of the illustration rep_err2.gif

23.8.4 Monitoring the Total and Average Amount of Desktop Personal Computers for this Month

This example describes how to monitor the total and average amount of purchase orders over a specific time period.

1. Select Reports > Activity Monitoring.

2. Enter a unique and recognizable name in the Name field or accept the default name.

3. Click the calendar icon for the Start Date field to select the date of one month ago.

4. Leave the End Date field blank to indicate today’s date.

5. Select Application Event Type from the Classification list.

6. Click the flashlight to select the specific event type name for the Name field. For this example, supplierpo is selected.

   The Event Analysis Report: Parameters page displays your selections:

Description of the illustration rep_am1.gif

7. Click Next.

   The Event Analysis Report: Event Content page appears.

8. Go to the Event Content Query Expression section.

9. Click the Select button for Condition expression not specified.

10. Click Update.

    The Create Condition Expression page appears.

11. Click Expand All or select a specific entry to expand in the Left Operand section.

12. Select total.

13. Select > from the Operator list.

14. Enter 500 in the Right Operand field.

    The Create Condition Expression page displays the following selections:

Description of the illustration rep_am2.gif

15. Click Apply.

    You are returned to the Event Analysis Report: Event Content page. The condition you created displays in the Event Content Query Expression section. This condition finds the purchase orders over $500.

Description of the illustration rep_am3.gif

16. Go to the Event Fields section of the Event Analysis Report: Event Content page.

17. Click Expand All or select a specific entry to expand.

18. Select Both in the Aggregation Type column for total. This selection compiles the average and the total sum of purchase orders over $500.

19. Select Yes for ProductName in the Summary Report Grouping column.

20. Select Yes in the Detail Report Inclusion column for doctype, productName, and total.

    The Event Report: Event Content page displays the following selections:

Description of the illustration rep_am4.gif

21. Click Next.

22. Go to the Grouping Fields section.

23. Select Productname in the Available Fields section.

24. Click Move.

25. Go to the Details Fields section.

26. Select Doctype and Total in the Available Fields section.

27. Click Move.

    The Event Analysis Report: Layout page displays your selections:

Description of the illustration rep_am5.gif

28. Click Finish.

    The Summary Report of the Event Status Report page displays the results. The Productname column appears because you selected it in Step 23. The Total Sum and Total Average columns display because you selected both in Step 18.

Description of the illustration rep_am6.gif

29. Click Details for additional details. The Total and Doctype columns display because you selected Both in Step 26.

Description of the illustration rep_am7.gif

23.8.5 Monitoring Business Process Efficiency

This example describes how to monitor the efficiency of your business process by identifying the total amount of time it takes for an event to be processed from one end to another.

1. Select the Reports > Process Optimization.

2. Enter a unique and recognizable name in the Name field or accept the default name.

3. Click the calendar icon for the Start Date field to select the date of one month ago.

4. Leave the End Date field blank to indicate today’s date.

5. Click Next.

   The Coordination Analysis Report: Ports page appears.

6. Click Expand All or select a specific entry to expand.

7. Select the first port endpoint for collecting information (in this example, the Global NP Ad-IN port of native role Placing Ad at Global NP-NR is selected):

Description of the illustration rep_po1.gif

8. Click Next.

9. Select the second port endpoint for collecting information (for this example, the Global NP Ad-OUT port of native role Placing Ad at Global NP-NR is selected):

Description of the illustration rep_po2.gif

10. Click Next.

    The Event Analysis Report: Layout page appears.

11. Go to the Grouping Fields section.

12. Make appropriate selections in the Available Fields section.

13. Click Move.

14. Go to the Details Fields section.

15. Make appropriate selections in the Available Fields section.

16. Click Move.

    The Coordination Analysis Report: Layout page displays your selections:

Description of the illustration rep_po3.gif

17. Click Finish.

    The Summary Report of the Coordination Analysis Report page appears. Note the amount of time it takes to process from the inbound native role to the outbound native role.

Description of the illustration rep_po4.gif

18. Click Details for a specific entry (for this example, the second entry).

    The Details Report of the Coordination Analysis Report page appears.

Description of the illustration rep_po5.gif

19. Click Details.

    An additional Details Report of the Coordination Details page appears.

20. Expand specific roles to display greater detail.

    The upper portion of this page displays the following information.

Description of the illustration rep_po6.gif

Note that within the business role, a pass-through step took a significant amount of time to process. This may be because an approval was required due to the purchase order being over a specific amount.

The lower portion of this page displays coordination event and deployment details.

Description of the illustration rep_po7.gif

23.9 Common User Errors

The following are common user report user errors.

• When creating an activity monitoring report, ensure that the string fields selected for Sum or Average have numeric content on the Event Analysis Report: Event Content page. Otherwise, blank Sum and Average columns appear in the final report.

• Ensure that you have a deployed configuration running when you attempt to create a report. You cannot create reports if a configuration is not deployed.

23.10 Chapter Summary

This chapter describes how to create reports and provides the following report creation examples:

• An event status report that identifies iProcurement purchase orders

• A coordination status report that identifies coordination details

• An error status report that identifies the current errors in an integration

• An activity monitoring reports that identifies the total and average amount of desktop personal computers purchased this month

• A process optimization reports that identifies business process efficiency