To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Account Reconciliation
Discussion List
-
How to Join Between Project Accounting Sub ledger and GL Sub Ledger Journal LinesSummary: We would like to know the most optimal way to join Project Accounting Sub ledger and GL Journal Lines. We understand we can join either by events or by distribu… -
ARCS SWIFT MT940 FORMAT BANK FILE Missing Value DateThe default Data Source Application for SWIFT MT940 FORMAT BANK FILE is missing "Value Date" dimension field 61. How can this be added? If I use the "+" button to add a …
-
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 …
-
When setting up a summary reconciliation filter, what does "Balance Exists" represent?I'm setting up a summary reconciliation filter for a Variance Analysis reconciliation (screenshot below). One of the filter options is "Balance Exists." What does "Balan…
-
Is there an easy way to identify recently updated profiles on the reconciliations screen?Summary: We recently had to update an attribute on existing open reconciliations in order to keep them open instead of auto-closing (we have a custom rule set up to auto…
-
How can i seperately view data from different source systems when i click on ending balance of reconI have created a reconciliation to load data from two different sources and one sub system. When i open the reconciliation and click on ending balance to see the source …
-
Do email notifications sent to the preparer & reviewer when a commentator adds a comment to a reconSummary: Do email notifications get sent to the preparer and reviewer when a commentator adds a comment to an open or closed reconciliation?
-
Unmatched transactions email notificationsHi, The users wants to receive email notifications whenever there are variance between new unmatched transactions in POS x Bank (See image attached). We searched Oracle'…
-
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…
-
Is there a way to see the last generated or usage date of Custom Report IN ARCS?Summary: Client has a large number of custom reports created since the beginning and would like to know when was the last generated date of all the reports so that they …
-
Delete prior periods reconciliation and period setupSummary: Hi All, We wanted to delete all prior periods reconciliation and period setup. I have archived and purged the reconciliation, but not able to delete periods. De…
-
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…
-
Is it possible to add closing balance column in the index page of Report binder.Is it possible to add closing balance column in the index page of Report binder.
-
Open Reconciliation Job taking around 12 HrsSummary: We are working on RC project with 300K profiles , The Open reconciliation job triggered after open period and create reconciliation is taking 10+ hours. Content… -
Custom BIP Report for AP Subledger Integration with ARCSSummary: Good Day, We are attempting to utilize the Oracle Payables Trial Balance Report to integrate the AP subledger into our ARCS instance. We've noticed that the out… -
How many rows to be loaded at one timeHello everyone, I have one question about the row limitation to load to ARCS. I know the row limit for csv file is 500.000 rows. But what's about connecting directly to … -
Post Exported Transaction Matching Journals to ERPSummary: How can I post the adjustment/exported journal to Oracle ERP? Content (please ensure you mask any confidential information): Hi, When we adjust a transaction in…
-
ARCS camt053 adapter: how to get a separator into the RmtInf between each subfieldCurrently the CAMT053 adapter add the sub fields together in one string. For readability I would like to have a separator semicolon or comma. This comes as one text stri…
-
BAI vs. BAI2 file formatSummary: We are trying to load both BAI and BAI2 files into transaction matching accounts, via integrations using a BAI Format Bank File Transactions target application.…
-
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…
-
Use Earliest Accounting Date in Match Group?When adjusting multiple transactions as one match in transaction matching, it there a way to default the accounting date to the earliest date in the match group? We curr…
-
Email notifications from ARCS application to a specific email ID.Summary: Is there a way that we can configure the ARCS Application to send all the email notifications to a specific email ID instead of individual users. Content (requi…
-
Getting adjustment period data from GL to ARCSSummary How to Get the Adjustment Period Data from GL to ARCSContent Hi Community, Good Day, Environment Involved : * ARCS * ERP Cloud (GL) Scenario: I have an adjustmen…
-
Is there a report for Viewer/Commentator access?I would like to audit the Viewer and Commentator access that's been granted by Reconciliation and Profile without having to click into each. Is there a report or view th… -
Pros/Cons of using FCC to Load ARCSHi - can anyone tell me what they have found to be pros/cons of using FCC balances to load ARCS?
-
ARCS - Output log (process details) is missingHi, In ARCS we load ICO transactions to match, often there are errors such as "Relonciliation does not exist for this period",… These errors are quite interesting for en…
-
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 …
-
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…