Category 117
Discussion List
-
How is period mapping related to periods in the ARCS application?How is period mapping related to periods in the application? I have created periods in the application as part of a yearly activity and set up period mapping in the data… -
Example of Enterprise Journals Connection Screen in ARCsI am getting this error when I try to connect to FCCS from ARCs for Enterprise Journals Connection. Does anyone have an example of what format the URL and User Name shou… -
ARCS Power Users AccessWe recently had a compliance review in our organization in which re-evaluate the access for multiple users based on if they are Administrators or PowerUsers. During this…
-
FIELD_ID labels from ARM_HISTORYSummary: Does anyone know how to get the labels (names) for FIELD_ID from the ARM_HISTORY table? The reference doc for ARM_HISTORY mentions: “The field ID which states w… -
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…
-
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 41 views 5 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
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 53 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 23 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 27 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 16 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…
-
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…
-
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 23 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 88 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 41 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…