Oracle FDMEE: Check Rule & Entity Groups and Report Execution

After data is loaded to a target application, a check report using defined check rules is generated to enforce data integrity. In other words, Check Reports provide information on the issues encountered when the specified Check Rule Group is executed. This is the last step in the work flow process, also known as the last orange fish- “Check.” Once check rules are defined, Check Rule Groups and Entities are applied to locations.

So how do they work?

Check Rule Groups

Since there are check entities assigned to each location, the check report runs for all entities defined in Check Entity Group. However, if the check entity field displayed in locations is blank, the check report runs for each entity that was loaded to the target application. Values in the check reports are retrieved from the source and target data. 

Assuming any Check Rules have already been defined, FDMEE reviews the check report and produces a successful/fail status in Process Details.The location associated with the report shows a Pass status only if all rules within the check report pass. In addition, if there is an outstanding balance in the location, the check report will fail.

Note: Each line of a check report represents a check rule. 

Check reports run as data is loaded (last orange fish), but can also be run manually, which will be discussed later in the post. 

To create Check Rule Groups:

1. Select Check Rule Group under the Data Load section in the Workflow tab

2. In the Check Rule Group Summary Grid (top section), click Add

3. Enter a Name, Description and click Save

To create Check Rules: 

1. Select the Check Rule Group created above

2. In the Rule Item Details Grid, click Add

3. Enter Information for each field: Display Value, Description, Rule Name, Rule Text, Category, Sequence, Rule Logic (optional) and click Save

Check Rule Group

Note: If any items in Rule logic are defined incorrectly, the report will not execute and will return blank.

Check Rule Entities

A Check Entity Group consists of target application entities. When a check report is produced, the entities that are assigned to the report location are displayed in the report.

To create Check Rule Entities: 

1. Select Check Entity Group under the Data Load section in the Workflow tab

2. In the Check Rule Group Summary Grid (top section), click Add

3. Enter a Name, Description and click Save

To create Check Entities: 

1. Select the Check Entity Group created above

2. In the Entity Details Grid, click Add

3. Enter Information for each field: Script Name, Calculation Script Parameter, Entity, consolidate, On Report, Sequence and click Save

Check Entity Group

Assign Check Entity Groups and Entities to locations in the Setup tab.

Location

Report Execution

FDMEE reports can be generated as PDF, Excel, Word or HTML output. In addition, administrators can assign the type of Default Check Report under Application Settings.

For example purposes, we are going to focus on Base Trial Balance Reports. Base Trial Balance Reports can be used to validate and compare balances as data is loaded from the source general ledger system to the target application. The subcategories of Base Trial Balance Reports in FDMEE include:

tb

As mentioned above, Check Reports provide information on the issues encountered when the Check Rule Group is executed. The subcategories of Check reports include:

tb2

As shown in the image below, to manually execute a Check Report:

  1. Select Report Execution under Other in the Workflow Tab
  2. In the Report Group drop down, select the report of your choice
  3. Select the type of report
  4. Click Execute
  5. When requested, click Save as or Open

tb3

Other reports available in FDMEE include Location Analysis, Process Monitor, Variance and Audit Reports