Rules
Discussion List
-
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 34 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 25 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 71 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 60 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 51 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 21 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 2 views 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…
-
Timing issue for assigning periods to auto-loaded filesSummary: We are setting a cash reconciliation flow in ARCS. Daily, a lot of files are loaded trough OIC into EPM. The issue is because the files often contain data of pr…Pieter-Jan Vandendriessche 11 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche Account Reconciliation
-
TM - Many to Many rule not working in transaction matching in Oracle ARCS with the same data typeHi All, we have a rule regarding many-to-many relationships, where there are two transactions on the source system side and one transaction on the sub-system side, with …Radha Dhumale 12 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Transaction Matching Group Attributes in Match-Type RulesSummary: When creating a many to 1 auto-match rule in ARCS Transaction Matching, how can group attributes be used to group transactions based on an employee ID number on…Bill Stevens - 1234 11 views 2 comments 0 points Most recent by Bill Stevens - 1234 Account Reconciliation
-
Is it possible to prevent the transactions with 0 balance from being carried forward in ARCS?We have many combinations of recons with the Balance explanations both equals to and greater than zero : Ex: 1. ****-1234 - 4500 USD 2. ****-2345- 0.00 USD We want the 0…