Working With Format Rules

Note:

This feature is available only in 11.1.2.4.100 (patch 20307212). For information about new features and updating to release 11.1.2.4.100, see My Oracle Support https://support.oracle.com

Format rules affect reconciliation workflow, the requirement for reconciliation attachments, or the value of profile/reconciliation attributes. The rules are displayed on the Profile Rules tab in read-only form.

Rules evaluate transaction conditions only if the accompanying reconciliations already exist.

Available rules:

See Order of Precedence Rules for Account Reconciliation.

• Auto Approve Reconciliation—Automatically completes specified approvals only if specified conditions have been met.

  Examples of conditions that could apply to this rule:

  • The balance is outside a specified range.

  • The balance fluctuates more than a specified amount or percentage from some prior period.

  • The prior reconciliation has transactions or other conditions meeting specified criteria.

  • Attributes have specified values (including calculated attributes).

  When conditions are satisfied, the specified reviewer levels are marked complete, and workflow progresses to the next level, or the workflow is closed if no additional review levels exist.

  This rule can be rerun.

• Auto Submit Reconciliation—Automatically submits a reconciliation if specifiedRuns when Reconciliation status changes to Open with Reviewer.

  Examples of conditions that could apply to this rule:

  • The balance is outside a specified range.

  • The balance fluctuates more than a specified amount or percentage from some prior period.

  • The prior reconciliation has transactions or other conditions meeting specified criteria.

  • Attributes have specified values (including calculated attributes)

  When conditions are satisfied, the specified reviewer levels are marked complete, and workflow progresses to the next review level, or the workflow is closed if no additional review levels exist.

  This rule can be rerun.

• Prevent Reconciliation Approval—Prevents approval of a reconciliation based on attribute values, or other characteristics.

• Prevent Reconciliation Submission—Prevents submission of a reconciliation based on attribute values, or other characteristics.

• Prevent Rejection—This rule prevents rejection by a reviewer under certain conditions. This rules runs when a Reviewer click Reject.

• Require Reconciliation Attachment—Prevents submission of a reconciliation if an attachment has not been added to the main attachments section of the reconciliation; conditions may be established based on attribute values, or other characteristics that specify when the attachment is required.

  Example: Set the Preparer Duration based on the period frequency. The rule configuration supports when to set the value: Before profile is copied to the period.

• Send Email on Update—This rule sends emails when a reconciliation is saved based on certain conditions being met. This rule runs when a preparer clicks Save.

  Note:

  This rule is designed to be run when a user takes an action on a reconciliation such as setting attributes, not for actions on the reconciliation that happen outside the Actions dialog such as resetting dates.

To work with format rules:

1. Select Manage, and then Formats.
2. Double-click a format.
3. Select the Rules tab. You can view the following information:

   • Order—The order of precedence. See Order of Precedence Rules for Account Reconciliation

   • Rule—Name of the Rule

   • Conditions—The choice of what conditions must exist before running the rule

4. To create, edit, duplicate, delete, or reorder a rule, on the Rules tab, click the appropriate button and, if necessary, update:

   • Rule—Select a rule.

   • Description—Optional. Explain why you configured the rule and how the rule should be used.

   • Message(on sum rules):

     • Message to Preparer—Define an optional message to preparer on the prevent reconciliation submission rule and require reconciliation attachment rules.

     • Message to Reviewer—Define an optional message to preparer on the prevent reconciliation approval rule.

   • Reviewer Level—Select "All Levels" to apply the rule to all reviewer levels or select specific reviewer levels individually. At least one reviewer level must be selected.

   • Select Create Filter and populate the conditions section or select Use Saved Filter, and then select a filter. The filter selected and configured for the rule determines the conditions that trigger the rule to apply.

   • Conditions—

     • If Use Saved Filter is selected, the Conditions section displays a read-only version of the conditions associated with the saved filter.

     • If Create Filter is selected, the Condition section is enabled.

       Conjunction, Source, Attribute, Operand, and Value behave as they do for the existing advanced filter feature. When creating filters, you can use these attributes:

       • Any Reconciliation or Transaction attribute, including calculated attributes that are classified as Reconciliation and Transaction attributes

       • Period Frequency