Category 117
Discussion List
-
Read Only/Non Editable Adjustment Attribute for Manual match Adjustment entriesSummary: We have a requirement from our client wherein they want some of the Adjustment attributes which are displayed to be read only since we have mapping to deduce th… -
What ways can I report on match metrics during my purge process?Matched transactions can only be archived and purged if 100% of the transactions for that Match Type and Account ID are matched with an accounting date that is earlier t… -
How to avoid duplicate loads of Bank fileSummary: Hi Oracle team We are reaching out regarding an issue we've encountered with ARCS and Data Management. Currently, there is no mechanism in place to prevent the …
-
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…
-
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 …Jacalyn Munyon 42 views 5 comments 0 points Most recent by Arjun Kumanduri-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 …
-
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…
-
Autoreconciliation rules doesn't work with Receipt methodsWe create matching reconciliation rules using advanced criteria with transaction Receipt Method. We uploaded the bank statement with the correct bank account and amounts…Giancarlo Cipra 43 views 2 comments 0 points Most recent by Tim Gaumont-Oracle Payables, Payments & Cash Management
-
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 …Kritika Dhingra 21 views 2 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
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?
-
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 14 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 11 views 1 comment 0 points Most recent by Tim Gaumont-Oracle Payables, Payments & Cash Management
-
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'…Larissa Pavao Taft 89 views 5 comments 1 point Most recent by Ryan Lunde-Oracle Account Reconciliation
-
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.
-
How to pass 12 months forecast in time format 2024M10 - 2025M09 in one process to DWSummary: Hi all, We are on a monthly basis reporting a 12 months rolling forecast to a Datawarehouse (DW) through the EPM Integration Agent. Date format in DW is like th…Bo Løve Langhorn 22 views 2 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close
-
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…Kunal Baikar 81 views 11 comments 0 points Most recent by Kurt-ARCS Support-Oracle Account Reconciliation -
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…Jared Custer 66 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
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…Paul Håvik 42 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
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…