Order of Precedence for Auto Reconciliation and Rules

This topic explains the order of precedence when auto reconciliation and rules are run.

At a high level, here is the processing order:

Auto reconciliation method - See Auto Reconciliation Methods in Creating Profiles
Reconciliations closed by the three auto reconciliation methods (No activity, Balance within range, Balance within range and no activity), copy transactions/comments from prior reconciliation
Rule execution
1. Copy transactions rules
2. Set attribute rules, if applicable
3. Auto submit/approve rules

Order of Precedence Rules

Successfully executing a rule in Oracle Account Reconciliation may prevent a later rule from being invoked. For example, if a customer assigns an auto-reconciliation rule to a reconciliation, and the auto-reconciliation succeeds, then any rule tied to the Submit function (such as require reconciliation attachment) would never be invoked.

Table 6-2 Format and Profile Rules

Rule	Runs When	Precedence Notes
Auto Approve Reconciliation	Reconciliation status changes to Open with Reviewer. During post-processing of data loads, to handle cases where the rule is based on balance conditions that may be satisfied as a result of the data load process. An Auto Approve rule depends on there being an Auto Submit rule. During the post-data load processing, an Auto Approve rule is run if any of the following conditions is true: Reconciliation was Open with Reviewer, Pending, or Closed prior to the data load and it was reopened due to new or modified data and an Auto Submit rule forwarded the reconciliation to the With Approver status Reconciliation is Open with Preparer prior to the data load, but no transactions have been entered or imported for the reconciliation, and an Auto Submit rule forwarded the reconciliation to the With Approver status Note: The system checks if no transactions have been entered or imported only for reconciliations that were Open with Preparer prior to the data load. If a reconciliation was Open with Reviewer, Pending, or Closed prior to the data load, Auto Approve rules may be evaluated during post-data load processing without checking whether transactions already exist. This rule can be rerun using Actions under the Run Rules menu.	If multiple Auto Approve rules are configured, then the success of any rule causes the reconciliation to be automatically approved.
Auto Submit Reconciliation	Reconciliation status changes from Pending to Open with Preparer. During the post-data load processing, an Auto Submit rule is run for if any of the following conditions is true: Reconciliation was Open with Reviewer, Pending, or Closed prior to the data load and was reopened due to new or modified data Reconciliation was Open with Preparer prior to the data load and no transactions have been entered or imported for the reconciliation Note: The system checks if no transactions have been entered or imported only for reconciliations that were Open with Preparer prior to the data load. If a reconciliation was Open with Reviewer, Pending, or Closed prior to the data load, Auto Approve rules may be evaluated during post-data load processing without checking whether transactions already exist. This rule can be rerun using Actions under the Run Rules menu.	The Copy Transactions Rule is processed before the Auto Submit Reconciliation Rule is evaluated.
Prevent Reconciliation Approval	Approver clicks Approve	Rules triggered when the Approver clicks Approve. Can be evaluated in any order. If any rule succeeds, then the Approve function is prevented.
Prevent Reconciliation Submission	Preparer clicks Submit.	Rule triggered when the preparer clicks Submit. Can be evaluated in any order (the order is irrelevant). If any rule succeeds, then the Submit function is prevented.
Prevent Reconciliation Rejection	Reviewer clicks Reject.	Rule prevents rejections unless user fills in certain fields. This gives the preparer more information on how to correct.
Require Reconciliation Attachment	Preparer clicks Submit	Rule triggered when the preparer clicks Submit. Can be evaluated in any order. If any rule succeeds, then the Submit function is prevented.
Send Email On Update	Users updates attributes on a reconciliation and pre-existing conditions are met.	Rule triggered when the user updates attribute values in the Reconciliation dialog when certain conditions associated with this rule have been satisfied.
Set Attribute Value	According to Run When attribute configuration. For Set Attribute Value rules, select one or more of the following: Profile section: The available options are Post Data Load and Pre Reconciliation Creation. Reconciliation section: The available option is Post Data Load This rule can be rerun using Actions under the Run Rules menu. Rules that reference periods in their filter conditions are not run when reconciliations are being created (from profiles or periods). You need to run such rules using the Run Rules option under Actions after the reconciliation is created.

Table 6-3 Format Transaction Rules

Rule	Runs When	Precedence Notes
Copy Transactions Copies transactions from the previous reconciliation performed by the user and that correspond to the same profile . This copy function behaves the same as the Copy Transactions from Prior Reconciliation window. The transactions, transaction attachments, and transaction comments from the previous reconciliation that are copied are selected based on the conditions established. Note: The copy transactions from the prior reconciliation is not permitted for a summary reconciliation.	This rule is run when: the status of a reconciliation changes from Pending to Open with Preparer. balances are loaded into a reconciliation whose status is Pending. This rule can be rerun using Actions under the Run Rules menu.	The Copy Transactions Rule is processed before the Auto Submit Reconciliation Rule is evaluated.
Prevent Amount Edit	When Preparer accesses the Transaction Detail dialog box.	When the conditions associated with the rule are met, the Preparer cannot edit the transaction amount through the application (the amount attribute is disabled, and any override features for calculated amounts are also disabled). In addition, import validations prevent editing the Amount through import.
Prevent Transaction Delete	Preparer clicks transaction Delete.	Rule triggered when the preparer clicks Delete. Can be evaluated in any order. If any rule succeeds, then the Delete function is prevented.
Prevent Transaction Save	Preparer clicks transaction Save	Rules triggered when the preparer clicks the transaction Save. Can be evaluated in any order (the order is irrelevant). If any rule succeeds, then the Submit function is prevented.
Require Transaction Attachment	Preparer clicks transaction Save	Rules triggered when the preparer clicks the transaction Save. Can be evaluated in any order. If any rule succeeds, then the Submit function is prevented.