Rules
Discussion List
-
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…
-
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 11 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…
-
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 33 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 13 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 2 views 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…
-
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 -> …
-
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
-
"Set Attribute" rule to change Risk Rating of ReconciliationSummary: Dynamic Risk Rating-Accounts with activity but zero ending balance - Changing Risk Rating of Reconciliation and its attached profile. We are trying to configure…
-
No Period Activity Rule for Balance Comparion MethodSummary: Auto-submit if no Period Activity for Balance Comparison Method Content (please ensure you mask any confidential information): Hi All, There is one requirement …Usha_Ramsinghani 32 views 2 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation