Formats
Discussion List
-
Need to know on ARCS, can we connect use file other then CSV whist we're using Custom Integration?When we do custom Integration, we use file which is in CSV format by running the report as ESS job. Is there a way where we can integrate the file as per the output whic… -
Ability to define a custom Bank Statement Import Format in ARCS (csv/txt file) ?Summary: Hello For a french customer, we are going to use ARCS to match Bank Statement Lines against GL Lines. Regarding Bank Statement Lines, our bank statements are no…
-
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 3 views 2 comments 0 points Most recent by AlagappanVeerappan Account Reconciliation
-
How to translate Subsystem Input Balances in ARCSSummary: Hi Team, In our current ARCS implementation, we have a scenario where client would like to input Sub-System Balances, so we have enabled necessary configuration…
-
Data Load is missing records even though ESS Job file had it in themSummary: We created BIP report which was used as ESS Job to pull data to ARCS. File loaded all the records when we manually load it into ARCS, however it ignore lines wh…Wilson Chelakadan 11 views 4 comments 0 points Most recent by Wilson Chelakadan Account Reconciliation -
Auto Reconciliation method - Balance is zero and no activityAuto Reconciliation method - Balance is zero and no activity To auto-reconcile the zero value accounts, we have defined Balance is zero and no activity method which is s…Shilpa Char 37 views 4 comments 0 points Most recent by Kurt-ARCS Support-Oracle Account Reconciliation
-
Subledger Transaction data can be used for both Transaction Matching and Balance Comparison(Recon CoSummary We have periodic Transaction level data extract for all subledgers(AP,AR,FA,Cost,Cash), can we use same extract for both Transaction Matching and reconciling the…Venkatraj Bhat 66 views 9 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
could you please provide guidance on whether there is a way to create an automated rule in EPMSummary: could you please provide guidance on whether there is a way to create an automated rule in EPM when we are setting up a rule in specific format Content (please …
-
Schedule from close date vs end dateHi, Could you help me understand setting in profiles called "Schedule from"? I see that there is option to choose end date vs close date but I don't know the difference.…
-
Hide Sub-ledger column for Reporting CurrencySummary: Is it possible in ARCS to have the Format with Method as Balance Comparison however hide the sub-ledger column for Reporting Currency? The Functional Currency s…
-
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…
-
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…
-
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 21 views 2 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close
-
ARCS Confirm suggested matches before you can submit reconciliationHi all, From our business we received the wish for suggested matched to be confirmed before the reconciliation can be submitted. There is a configuration setting (on the…Pieter-Jan Vandendriessche 32 views 3 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Removal of "Short Description" from adjustments tab of the reconciliation windowSummary Removal of "Short Description" from adjustments tab of the reconciliation window Content (please ensure you mask any confidential information): Hi Team, On the "…Usha_Ramsinghani 72 views 12 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
Is there a way to export format rules?We'd like to do an export of the custom rules for each format. Is there a way to export the format rules? Seems like there isn't an export option but wondering if there'…
-
Switching Format ImpactsSummary: If we have Format A assigned to all of our profiles and create Format B and want to completely replace Format A with the new format, is there any easy way to ad…
-
In ARCS we have the Account Analyze format enabling users to explain the end balance of an account.I have a customer who wants the Balance explanation to be copied to the next period when opening reconciliations, is that possible? If an account balance is $ 2.000.000 …Gert Hvarregaard 32 views 7 comments 0 points Most recent by Gert Hvarregaard Account Reconciliation
-
Available fields when using Transaction Matching formatSummary: Hi everyone. We implemented transaction matching and thus needed to update our account rec format. When using the "TX matching" format, there does not appear to…
-
Group reconciliation not showing the "Group Detail" tabSummary: All the configs seem to be correct and I can see the data in the detailed balances tab in the reconciliations page but I am unable to see the details in the rec…Nimisha Mundade 21 views 3 comments 0 points Most recent by RahulBansal-Oracle Account Reconciliation -
How a reviewer can view transactions that were match for TM Only methodSummary: We have profiles that were applied to Transaction Matching Only method which can only be accessed by a Preparer. how a reviewer can view transactions that were …Saritha Mannnajirao 13 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Display multiple periods in one reconciliationSummary: Hi, is it possible to see multiple periods in 1 reconciliation? Would be interesting to test if seeing multiple periods as data would add value or just be confu…Ketil Bolstad 11 views 1 comment 0 points Most recent by James Yesudass-Oracle Account Reconciliation -
Auto-submit rule for Account analysis methodWe have created Account Analysis method for few accounts and we have added rule under Balance Explanation to copy transactions from prior reconciliation. We want Auto Su…
-
Action Plan Close Date impacting aging of TransactionsContent Has anyone noticed that when using Action Plans, the Action Plan Close Date is impacting the aging of Transactions? For instance, I have a Balance Explanation cr… -
Is there a way to copy a rule from one format to another?We have rules set up on various formats in ARCS. We'd like to use the same rule in one format in another format. Is there a way to copy a rule from one format to another…
-
Reconciliation between balances (ERP) and workbench data (FCCS)Summary: I would like to know the best way to set up a reconciliation between ERP ending balances and a workbench data file from FCCS in order to ensure that mapping bet…Karolina Kawecki 64 views 10 comments 1 point Most recent by Karolina Kawecki Account Reconciliation
-
Unallocated Cash Split functionality is not working as expected in ARCSSummary: one of the account amount 1527,93 needed to be split in 715,79 and 812,14. the user entered the amount of 71579 (without the dots/comma) this results that the a…Annapoorna 31 views 2 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Enforce Reviewer Comment before RejectionSummary: Enforce Reviewer Comment (not via attribute) before Rejection Content (please ensure you mask any confidential information): Hi All, I would like to create a ru…