Rules
Discussion List
-
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 69 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 65 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…
-
Setup different due dates for different profilesSummary: We have 3 different due dates for our Profiles Recon is due on 10th Day on the regular month and 15th day on the quarter end month, we are able to achieve this …Madhu Chalamalasetty 53 views 5 comments 0 points Most recent by Madhu Chalamalasetty Account Reconciliation -
How to prevent transactions from being imported twice or arriving twice in ARCSI have a connection that brings data from Oracle Fusion to ARCS to Transaction Matching aplication, the client wants to import the data every two hours, but only to brin…
-
"Send Email on Update" rule - Not sending email to users if specific reconciliation is approvedSummary: Despite configuring "Send Email on Update" rule at the format, profile, and reconciliation levels, emails are not being sent to users with the reconciliation wh…
-
Business requirement to manually match one sided transactionSummary: Business requirement to have one sided matching created manually by user when there is no transaction on other side flowing Content (please ensure you mask any …Vaishnavi Laguduva 22 views 3 comments 0 points Most recent by Dave Jesky-Oracle Account Reconciliation
-
ARCS Many to one rule : how to group by an attribute that is not in the ruleWe want to prioritize a match to be done by summarizing amounts based on an attribute on the source system only. I explain : in the source system we have Amount station …
-
Using Send Email on Update rule, Preparer should be notified once every week for 30 daysSummary: Hi, We have a business scenario to send email to preparer on a weekly basis until the preparer duration (30 days) ends. The email notification is for reminding …AlagappanVeerappan 1 view 2 comments 0 points Most recent by AlagappanVeerappan Account Reconciliation
-
Transaction Matching : How to transfer support attribute data into adjustment attributesWe want to use a one sided adjustment to self-match transactions. We need to define rules of adjutment type to create adjustments from supported transactions. Adjustment…