Oracle Corporation

03/11/2024 | Press release | Distributed by Public on 03/11/2024 03:12

Customize your Rule Runtime Report

Introduction

Enhanced Business Rules, is an improved version of the legacy business rules in Agent Desktop. EBR makes it easy to define and maintain rules in a very simple format. It provides a set of conditions and actions in such a way that an admin can automate different business processes without much expertise.

With enhanced capabilities of EBR, it is important to have the ability to view rule execution details as a report. The canned report named "Rule Runtime Log"(report id : 13158) can be utilized to view rule execution information. However, the need to customize a rule report would help in troubleshooting and understanding the pattern of rule execution. Having the ability to edit fields, new filter or slice etc. will help to analyze rule execution in a better and easy way. To achieve customizations on browser UI based enhanced business rule execution, the rule runtime log table is added to the report designer from 24A.

How to create custom rule runtime log report?

If your profile has the appropriate analytics permission to create reports, then custom rule runtime report can de designed. There is a new table added to the data dictionary within report designer- Rule Run time log (rule_runtime_log). Fields can be chosen to create the report. Using this new table, filters and slices can be designed too.

Often with custom reports, it is desirable to join with other tables to show more useful information. Rule runtime custom report allows joining other tables either through custom scripts or by making use of linked reports.

One thing to note here is that the rule_runtime_log table has the runtime info on enhanced rules that are created from agent browser UI and not from the legacy rules.

What about the Limitations?

  • Customized reports can only be accessed via Agent desktop console or through browser UI.

  • As of now, these reports cannot be accessed using REST API calls. This feature will be available in the upcoming release.

  • Maximum number of records that can be fetched by a report is 10000.

  • Joins with other tables for customized runtime reports can be only done using custom php script. Usual way of joining with other tables are not possible. Another workaround is to make use of linked reports, to fetch information from other tables.