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
-
Can we calculate aging in Transaction Matching on basis of Period Close Date?We are trying to calculate aging in TM module for each transaction on basis of period close date, instead of sysdate, which is current capability for OOB Aging attribute… -
Dimensions are not showing in data mappingSummary: I'm in the process of setting up a new transaction matching data import for Account Reconciliation ARCs. Source is a comma delimited file. At the Data Load Mapp…
-
What type of changes are recorded in below artifacts?Summary: When we extract the "Artifact Updates" report from Navigator > Migration > Reports > Artifact Updates, we identified some artifacts with Artifact Types as below…
-
Auto Submit of one reconciliation on the basis of another ReconciliationWe want to auto submit and auto approve one reconciliation on the basis of another reconciliation in order to avoid duplication of efforts. I used attribute for this, bu…
-
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… -
Tracking /Audit of "Transaction Date" updates for RC AdjustmentsSummary: We have a requirement to track changes performed on transaction date in Reconciliation Compliance adjustments. We have tried searching in Rec history, audit rep… -
Whether any functionality is available in ARCS to accumulate balances every month until year end ?Summary: Whether any functionality is available in ARCS to accumulate balances every month until year end and reset the balances each financial year? Content (please ens…
-
Purge all unmatched transaction in Transaction Matching if profile related to Rec ComplianceIs it possible to Purge all unmatched transactions in ARCS Transaction Matching if the profile is related to Rec Compliance? We tried Transaction Matching Jobs "Purge Tr…
-
Data load for a locked period in ARCS applicationHi, In our current data load process, we are loading data for one closed period(Dec) and current open period(Apr). Since, the period (Dec) is closed for data loads to ha…
-
Why Oracle is using source system instead of General Ledger since its an account reconciliation toolSummary: Why Oracle is using source system instead of General Ledger since its an account reconciliation tool, why they cannot adhere to the accounting terminology Could…
-
user login reportSummary: Is there any limitation (date) on exporting user access report in ARCS.
-
Unable to add the Profile segmentsSummary: I initially created Profile segments ( 3 of them). Now i wish to add few more but the Add option is greyed out. Is this as per design ? Is it possible without d… -
Has anyone else experienced the need for an annual or bi-annual preparer frequency in ARCS?Summary: We have a request from our controller team to set profiles to annual or bi-annual for recon preparer frequencies so that auto reconciliation happens during off …
-
What is maximum transaction limit if direct connection data source with Oracle ERP cloud (custom)?Summary: What is maximum transaction limit if create the direct connection data source with Oracle ERP cloud (custom)? Content (please ensure you mask any confidential i…
-
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…
-
Matched In-Transit in Custom ReportSummary: I am trying to build a custom report for pulling status information similar as Balance Report Transactions. In the first column of this system report, it contai…
-
Is there a way to do transaction matching in Bulk for manual matching in Transaction Matching moduleSummary: Client has an ask if it is possible to match the transactions in bulk in transaction matching module Content (required): For the transactions which did not auto…
-
Mapping additional currency to Subledgers in Data managementSummary: Hi Team - we have added a new primary ledger(china entity) in the source system with currency as CNY in Data management. Our requirement is to perform the recon…
-
Prior period is not reflecting in Variance period balance in Variance analysis method reconciliationSummary: Hi Team - we have created a variance analysis method format with Prior balance frequency as Monthly and also created a profile with frequency as monthly. When w…
-
EPM Password ExpirySummary: Hi Experts, Can EPM login passwords be set to "Not expiring passwords". Content (please ensure you mask any confidential information): Version (include the vers…
-
Pulling in Accounts Payable (AP) and Accounts Receivable (AR) transaction detail into ARCSSummary Trying to load AP and AR Subledger Transactions into ARCS systemically via Data ManagementContent I am attempting to leverage the systemic ability to load subled… -
ARCS - Direct Connect with Oracle Cloud ERP SubledgersSummary We are able to Direct Connect to the Oracle Cloud ERP General Ledger. But can we Direct Connect to the Oracle Cloud ERP Subledgers (AR, AP, FA)?Content We have 3… -
Do we have out of box subledger reports in ERP to extract data and load in ARCS to perform GL/SubSummary: Content (required):Do we have out of box subledger reports in ERP- Fusion to extract ending balances and load in ARCS to perform GL/Sub in reconciliation compli…
-
Account reconciliation cloud - Exchange ratesSummary: Can we automatically load exchange rates needed to translate, revalue and show values in required currencies for reporting transactions and reconciling at month…
-
Unable to change time zone in "Reconciliation Audit Trail" reportHi ARCS Experts, I am trying to generate the report "Reconciliation Audit Trail", where the time zone is showing as UTC, but I want to change it to "ET", I tried to chan…
-
Can you push currency exchange rates from FCCS to ARCS? Is there a workaround?Summary: Looking for a way to push/pull/load currency exchange rates from FCC to ARCS. Content (required): We currently use the FCC and Planning applications and are in … -
Updates to Fusion ERP Cloud Data Adapter in 21.10Summary: Updates to Fusion ERP Cloud Data Adapter in 21.10 Content (required): Attached file demonstrates how to link a custom ESS Job encapsulating a BIP Report in Fusi… -
Is there a table we could use to build a report for all Unexplained Differences?Summary: Is there a table we could use to build a report for all Unexplained Differences? Content (please ensure you mask any confidential information): After reviewing …
-
ARCS - How to delete job page historyHello All, I noticed a strange behavior of the ARCS application when the entire snapshot is migrated from one ARCS environment to another. Since the profiled users are d…
-
User able to extract Custom report other then His/her accessSummary: We have created a custom report and we have given access to the users to extract those report. The user should be able to extract the accounts to which they are…