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
-
Connecting ARCS to ERP Subledger ReportsSummary: For Balance Comparison reconciliations in Rec Compliance, we want to pull in AR subledger balances from the seeded Receivables Aging by General Ledger Account R… -
How can I use wildcard in a multi dimension data load mapping?Summary: In Data Management, I want to define the value of the 'Profile' dimension based on two other dimensions (the dimensions 'Segment 4' and 'Segment 8'). Content (p…
-
Email notifications on bulk updatesSummary: Users do not receive email notifications when bulk actions for Submit and Reject are used. When the same recs are submitted or rejected individually then the em…
-
ARCS - how to proceed with Reconciliation for Expenses and income accounts in ARCSSummary: Reconciliation for Expenses and income accounts Content (please ensure you mask any confidential information): we have a requirement to add Expenses and income …
-
BAI file format error while loading to ARCSSummary: The BAI file load balances fails in ARCS if the file has no 015 or 010 tags on the 03 row for eg. 1234 is the account no on the 03 row but the row has no 015 or…
-
Creating a dashboard in ARCSSummary: How to create a dashboard in ARCS which can provide detailed information such as list of Integration jobs, Their current status (Pending, Completed, Failed), No…
-
Customized report data integration error in ARCSSummary: We are uploading ERP GL clearing data using a customized report for the ARCS system for reconciliation purposes. When I upload and run the file, it shows 'compl… -
TM: Unmatching Items re-opened reconciliations for yearSummary: We are using Transaction Matching to assist with the daily reconciliation of a profile\account. There were a list of transactions that were matched back on 12/2…
-
ARCS feedback - anonymization dataSummary: ARCS feedbakc to SR Oracle - anonymization data Content (please ensure you mask any confidential information): Hello All, I need to provide a feedback to SR Ora…
-
Issues with Uploading Pre-Mapped Balances and Invalid Columns ErrorWhen uploading pre-mapped balances, the system is unable to recognize the columns I added. It shows an "Invalid columns" error, even though I included them in the match …
-
Client wants to use Cash Management for external transactions but ARCS for reconciliationSummary: Client wants to use Oracle Cloud Cash Management to automate creation of external transactions but wants to do all reconciliations in ARCS. It is not best pract…
-
Diff in RTF custom reportSummary: We are trying to difference in two columns in RTF but not getting desired result. Answer should be 0 Content (please ensure you mask any confidential informatio…
-
Able to have an A/R rec where we can see each balance explanation in aging bucket?Summary: We have a requirement to reflect detailed transactions bucketed in the defined aging buckets Content (please ensure you mask any confidential information): We a… -
Intercompany balance reconciliationSummary: Process for creating Intercompany balance reconciliation setups in both DM and ARCS Content (please ensure you mask any confidential information): Please let me…
-
EPM Module Licence monitoring - can i find out which users have never logged in?I have users I know have never used the module, but need to know so to remove access. how can I tell? in EPM and/or Fusion? many thanks
-
Data load mapping: Two lines showing under All mapping type instead of Like- how did that happen?Summary: We use "Like" mapping type for all of ARCS. Two lines have appeared under type "All" for one of the administrators. How did that occur? We always go to like tab…
-
Drill through from Group Details is showing multiple records instead of only one lineSummary: Drill through from Group Details is showing multiple records instead of only one line, It is showing all transaction contributing to balance available on summar… -
Can we add more than one preparer, group or team on one profile (TM)?Summary: For the organization's transaction matching process for intercompanies transaction loads, we have 2 entities loading into one profile. Change when we create the…
-
How can I identify duplicate payments (two debit amounts) using TM in a single data sourceI am trying to identify duplicate payments in a single data source. Is there a way to configure the match rule to identify two debits with the same invoice number and am… -
Auto reconcilation for closed periods.Hi Team, Our April month period was in closed state, but we observed lot of April month reconciliations were in open (with Preparer) state. When we checked the Auto reco…
-
1-M and M-1 with Subset Match RulesSummary: We need to understand how the 1-M & M-1 with subset match rules is trying to identify transactions on the Many side. For instance, say there are 100 transaction…
-
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…
-
How to automate the Import Premapped balances data loadSummary: Hi All, We want to load ending balances & using Import Pre-mapped balances we have tries loading the same. We want to automate this load in ARCS Prod. Kindly he… -
Different starting period Frequency setup for profiles in Account reconciliationHi All, I have requirement to setup frequency for profiles. Example : In the current system, Quarterly setup period is Mar-Jun-Sept-Dec Along with for few profiles i nee…
-
Individual reconciliations with “Unexplained Differences” are not allowing to submitHi Team, Individual reconciliations with “Unexplained Differences” are not allowing to submit, same should be applied to groups. Please check and suggest, how to we fix …
-
Need Clarification on ARCS New feature as part of 23.11 patch - ARCS Match Type application rolesAs part of 23.11 patch update , oracle has provided below new feature for ARCS 1. The Match Type – Manage role enables users to manage match types, adjustment attributes…
-
Editing PeriodSummary: csv update for periods does not work after a period edited through screen. Content (please ensure you mask any confidential information): I found that once a pe…
-
Is there a way to delete matched transactions?Summary: We need to initialize and clear all data from ARCS. Is there a way to delete matched transactions or all the data in the application. Thanks! Content (please en… -
Source Account value displaying twiceSource Account value displaying twice when I import data to Account reconciliation. Also when I run the period it says as "Unmapped Accounts" for all accounts. Please le…
-
Export mode doesn't availableIn Data exchange section "No export" is only available for Export mode. Please let me know if you know how to get other export modes.