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:

1. Auto reconciliation method - See Auto Reconciliation Methods in Creating Profiles
2. 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
3. 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 7-1 Order of Precedence Rules

Rule	Rule Type	Runs When	Precedence Notes
Auto Approve Reconciliation	Format/Profile Rule	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. This rule can be rerun using Actions under the Run Rules menu. An Auto Approve rule depends on there being an Auto Submit rule. For example, it would be executed if the reconciliation: was Closed prior to the dataload and was reopened due to new or modified data and an Auto Submit rule forwarded the reconciliation to the With Approver status is Open but no transactions have been entered or imported for the reconciliation and an Auto Submit rule forwarded the reconciliation to the With Approver status	If multiple Auto Approve rules are configured, then the success of any rule causes the reconciliation to be automatically approved.
Auto Submit Reconciliation	Format/Profile Rule	Reconciliation status changes from Pending to Open with Preparer. During the post-dataload processing, the criteria for running an Auto Submit rule is that the reconciliation: was Closed prior to the dataload and was reopened due to new or modified data is Open but no transactions have been entered or imported for the reconciliation 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.
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.	Format Transaction Rule	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	Format Transaction Rule	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 Reconciliation Approval	Format/Profile Rule	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	Format/Profile Rule	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	Format/Profile Rule	Reviewer clicks Reject.	Rule prevents rejections unless user fills in certain fields. This gives the preparer more information on how to correct.
Prevent Transaction Delete	Format Transaction Rule	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	Format Transaction Rule	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	Format Transaction Rule	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.
Require Reconciliation Attachment	Format/Profile Rule	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	Format/Profile Rule	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	Format/Profile Rules	According to Run When attribute configuration: Profile attribute: Before profile is copied to period. 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.