Rules
Discussion List
-
Match Rule with Date Tolerance not finding matchesSummary: Match Rule with Date Tolerance not finding matches An account is matching on Desc3 field when Effective date is one day later. For example, Desc3 = HB2803 and S… -
Is there a report (or list) of all auto-reconciliation rules assigned to each format/all formats?Summary: Our Auditors have requested that we provide them with a report from ARCS (not a screenshot) that shows the relationship between Account -> Profile -> Format -> …
-
M-M with subset matching rule is matching transactions without matching all parametersWe have created a Many-Many match rule with subset enabled in single data source match type. In this rule, we are matching 3 parameters - a. policy should match exactly …
-
ARCS Report in not fetching the one month old payment data transaction.Summary: Content (please ensure you mask any confidential information): ARCS Report is not fetching the one month old payment data transaction, even it is not in the rep…
-
Match Rule to deny items if common dollar amountsSummary: Match Rule to deny items if common dollar amounts Content (please ensure you mask any confidential information): We have a use case where we don't want to match…
-
Rule to Notify Preparer on Reopened ReconciliationHi Team, Earlier, my reconciliation was submitted because the source and sub-system balances matched, and the unexplained difference was zero rule executed. Later, the s…
-
Auto Certify while also using Balance Explanation RuleSummary: Content (please ensure you mask any confidential information): Hi We are using the auto reconciliation rule "no activity" on many of our manual reconciliations … -
Format Rule to Exclude Reporting Currency in Auto Submit & Auto ApproveSummary: Is there a way to configure the rule so that it ignores Subsystem Balance (Reporting) and Source System Balance (Reporting), but still evaluates “Balance Exists…
-
ARCS Set Attribute Rule for Workflow Duration and FrequencySummary: Hi, We have created the Set Attribute Rule for Risk Rating based on Balances or Account Type. Then we have created another Set Attribute Rule for Workflow (Prep…
-
Aged item violation attributesSummary: Hi Team, My client has lots of aged reconciling items, for that they want to create few alerts and attributes for more than 90 days aged reconciling items. We h…
-
How to stop auto submission when ending Balance is not Zero?Summary: I have source and sub system balances however Recon is getting submitted with No period activity is zero and blank. How to configure the below rules for one Rec…
-
We want to know, how open/active recon rule is getting is executed? we want to know the schedule.Summary: We want to understand, how open/active recon rule is getting is executed? we want to know the schedule. Content (please ensure you mask any confidential informa…
-
Prevent Auto submission when variances found at Sub Segment levelSummary How to override auto submission rule when there is an Unexplained Difference at Sub Segment levelContent Hi, We currently have a profile that reconciles at Entit… -
ARCS Detail Balance - Is there a way to autoclose rec based on core dimensionHi Team, I wanted to create a rule for auto submit in profile/format if the reconciliation contains only 1 unique value for a dimension highlighted in below screenshot I…
-
Match with "Group" function does not work, please help!Summary: Match with "Group" function does not work Content (please ensure you mask any confidential information): By reference to Filter and Grouping Transactions in Aut…Vani-Oracle 31 views 3 comments 0 points Most recent by Rajesh Krishnam-Oracle Account Reconciliation -
Email notification when reconciliation rejected by ReviewerWe request that when a reconciliation is rejected by the Reviewer, an email notification should be sent only to the Preparer who claimed and submitted that reconciliatio…
-
Wipe off balance explanations in ARCS ReconciliationsWipe off balance explanations in ARCS Reconciliations Content (please ensure you mask any confidential information): Hi All, I have a business requirement to wipe off ba…Amit Agarwal-158816 21 views 1 comment 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation -
Exporting/importing Profile RulesSummary Looking for way to export and import Profile Rules for easy editingContent Hi All, I have created some custom auto-submit and auto-approve rules in a balance com…User_2025-01-28-03-53-07-071 76 views 4 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation -
Auto-Reconciliation using Rules in ARCSSummary: Auto-Reconciliation using Rules in ARCS (Creating Filters and applying to Formats) Content (please ensure you mask any confidential information): Hi Friends, I …Amit Agarwal-158816 81 views 10 comments 0 points Most recent by Amit Agarwal-158816 Account Reconciliation
-
Need Best Practice for Creating Multiple Manual Match Rules with Different Tolerance in Single MatchSummary: Need Best Practice for Creating Multiple Manual Match Rules with Different Tolerance in Single Match Process Hi Team, I am working on a Transaction Matching set…
-
ARCS how to remove spaces in a calculated attributeSummary: I have a calculated attribute : SUBSTRING({attribute6},0,6) which can contain spaces. It's used in a rule and I need to remove spaces, otherwise the rule doesn'…
-
Calculate Age days for TransactionHi Team I have created an attribute in Match type of Age_days which is calculating based on a different date and not accounting date. Calculation type:- Scripted Formula…
-
How To Change Data Type and Perform Data Fix for Match Type ConfigurationSummary: Due to an incorrect setup, the data type of the "Data Source Attribute" in the Match Type was set to Integer instead of Text. We would like to request a change …
-
A Rule on Format is not working as expectedHello, We have a file based data load to subsystem. In which a profile has data to multiple currencies and it is loading perfectly. We have a format rule to "Prevent Rec…
-
Transaction Matching Commentator and ViewerHi Team, I have given a user commentator role for a transaction matching only rec, however, I have want to where can user add comments in Matching section? Also, I have …
-
Auto-Reconciliation Issue with Online and Counter TransactionsTrying to assist our finance team with an ongoing issue related to the auto-reconciliation for one of their transactions. The team has tried recreating their reconciliat…
-
Create a report of detail balance with unexplained differenceSummary: Hi team, I want to create a detail balance report which contains the unexplained differences at string level. Could you please help me to achieve the above task…
-
Why is calculated attribute not filtering properly?We created a calculated attribute for % Variance that's used for our Variance Analysis recs. The attribute is calculating correctly, however, the filtering and rules tha…
-
Transaction Matching Like Matching Conditions for Text Strings in Oracle ARCSSummary: Is there a way to map Text Strings for Matching Rules in Oracle ARCS for Transaction Matching. For Eg including Contains or Starts With in matching rules? Conte…
-
Could you please provide tables of Match type config to track changes made to the Match TypeSummary: We need the tables that give details of the match type configurations, so that we can use the tables to track the changes made to the match type. Changes made t…