Rules
Discussion List
-
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 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… -
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 21 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 21 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… -
Stop Job from RunningSummary: Import Transaction with Auto Match - Stopping Job Content (required): Is there anyway to stop a Transaction Matching job from running within the Jobs tile? I ha… -
ARCS FrequencySummary: Could somebody please advise me on the best solution to implement the following scenario. We have a subset of accounts which are required to be reconciled in Pe… -
Reconciliation Matching Rule 1-M not working properlySummary: We want to reconciliate statement lines of an uploaded bank statement with system transactions using 1-Many matching rules and also Percentage Amount Tolerance …Giancarlo Cipra 41 views 1 comment 0 points Most recent by Tim Gaumont-Oracle Payables, Payments & Cash Management -
What is the formula for Percentage Amount Tolerance in Reconciliation Tolerance Rule settings.Summary: In Cash Management we have uploaded a bank statement and created reconciliation rules for autoconciliation. We also set Percentage Amount Tolerance parameters o…Giancarlo Cipra 21 views 1 comment 0 points Most recent by Tim Gaumont-Oracle Payables, Payments & Cash Management -
ARCS - Account Reconciliation Format Rules logic questionPlease see screen shot. In the example on Rule 3 if System Balance (Reporting) is between 5,000,000 and -5,000,000 USD it should auto submit. My question is if the balan… -
Create rules for reconciliationSummary: Hi I am new to ARCS. I have to create new rules for reconciliation for auto submission and auto approval and more like. Can you please help me to understand how… -
How to set up rule in format using Workbench ValuesI have one dimension in workbench where I have binary values coming from my data file. I want to setup a rule in the format based on my workbench data, but I am not able… -
Guidance on Efficiently Enabling/Disabling Rules in ARCS FormatsSummary: Guidance on Efficiently Enabling/Disabling Rules in ARCS Formats Content (please ensure you mask any confidential information): Hello everyone, We seek guidance… -
Reconciliations with two levels of reviewers do not auto submit and approveSummary: We have rules in place to auto submit and approve reconciliations with certain criteria. Recs with two reviewer levels are not auto closing similar to recs with… -
Rule that evaluates total value by criterionSummary: Rule that evaluates total value by criterion Content (please ensure you mask any confidential information): In Oracle ARCS, in his latest version I need perfom …Steven Ballen Pelayo 1 view 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
How to Create manual rule for "rule type adjustment"Summary: How Create manual rule for "rule type adjustment" Content (please ensure you mask any confidential information): I would like to ask if it is possible to create…Malalatiana_S 61 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Send Email On Update Rule - Not sending email to preparers if reviewer adds an commentHi All, We are trying to trigger email notifications to preparer when approver adds a new comment and vice versa. For achieving this, we tried to use send email on updat… -
Does the balance explanation entered through Smart View not carry forward to the next periodSummary: The balance explanations entered are not being carried forward to the next period. Is there a specific reason why they aren't being carried over? Content (pleas… -
How to automate removal of Reviewer2 in the following periodSummary: How to automate removal of Reviewer2 in the following period after it was set up in the current month using Set Attribute Rule Description: In Reconciliation Co… -
Closed Account Reconciliation is reopenedSummary Closed Account Reconciliation is reopenedContent An account reconciliation was approved and closed manually. However, it is reopened again even though there is n… -
reviewer 2 level to be set only for specific period for all the profilesSummary: we have a requirement to set reviewer 2 level only for Feb and May month for all the profiles. Is there a way to achieve this requirement Thanks in advance Cont…Harshavardhan Punuru 11 views 2 comments 0 points Most recent by Harshavardhan Punuru Account Reconciliation -
Ability to view audit trail for rule setSummary: Client has a requirement to have an audit trail or a report which will display all the changes that has been done on a Matching rule for a particular Match proc… -
Is there a way to have ARCS rules run on quarters only?I have the following request to setup rules that would run on a quarter only as follows? Does anyone know if this is possible? 2. Zero net activity, non-zero balance – w… -
Setting up Risk Rating based on Transaction attribute for a Recon in ARCS Recon ComplianceSummary: We are unable to set up a dynamic risk rating for the reconciliation based on a transaction present within the reconciliation based on the following criteria if…Eswar Naidu 11 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation