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
-
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.
-
Loading Transaction Matching for all profilesSummary: We receive a daily GL transaction file that contains transactions for 40 + profiles. It is the same scenario for bank files (1 daily file that includes all bank…
-
Need help to send email notification when the status changes to "closed" for TM reconciliationSummary: Need suggestion in sending reconciliation status "closed" email notification to users. Data from source gets loaded to a Balance comparison TM reconciliation/pr…
-
OCI - migration issueOCI - Migration issue. Out test classic environments are migrated to OCI. All out users do not have access to reset password in classic environments as we use SSO to sig…
-
Custom Reports with multi currency Balances , amount to be split into individual rowSummary: There's one custom report we are trying to generate in which there's one column Currency Balance. Ideally we want only one currency and amount to be shown in on… -
API Security in EPM cloudSummary: Could you please provide API security policy for EPM cloud as API is exposed by Oracle? And also please confirm API communication is going with proper security …
-
Is it possible to export excel from data load log/ warning from period screen using APIsSummary: Is it possible to export excel from data load log/ warning from period screen using APIs (Invalid Mappings, Unsupported currencies, etc) Content (please ensure …
-
EBS Inventory Subledger to ARCSHi We are trying to load EBS Inventory to ARCS via the Integration Agent and have developed the below query. Similar queries work well enough (we think) for AP, AR and F…
-
Custom Match Metrics DashboardSummary: Our stakeholders are requesting reporting for matching metrics. Currently, the custom dashboard for matching only allows us to select specific match type to cre…
-
Naming convention of Account IDs for Group RecsSummary: Hi All, We are currently working on creating group profiles for the recs which can be grouped together to sign off the balances at a group level with each code …
-
How to extract ARCS all months Audit ReportSummary: We need to Export all months ARCS Audit Report but application Was not supporting to Export all data in Excel. EPM Automate also we don't have any command for t…
-
Unable to Export More Than 49901 Rows in ARCS Audit ExportSummary: Hello , We are unable to export the data for all the months using the "Audit" tool . Note : We are able to export only 49901 Rows . Kindly assist . Thanks in ad…
-
Oracle fusion integration with EPM-ARCSSummary: Has anyone recently performed this integration after the latest 23d update? Content (please ensure you mask any confidential information): Version (include the …
-
Variance Analysis Group Recon alternate optionSummary: As we do not have the functionality of group reconciliation for the variance analysis method, has anyone implemented any alternate solutions? Content (please en…
-
Load Cloud ERP Journals Via OTBI More FrequentlySummary: Currently, we load our Cloud ERP Journals to ARCS on a daily basis. This is simple to achieve by pulling all journals posted the prior day. As we continue to ma…