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
- 
             Prevent notification on Late reconciliationSummary: Is there a way to prevent notification getting triggered to Users on late reconciliation , not as something individual set up from Preference but as Admin set u… Prevent notification on Late reconciliationSummary: Is there a way to prevent notification getting triggered to Users on late reconciliation , not as something individual set up from Preference but as Admin set u…
- 
             How to Drill to Subsystem in ARCS?Summary: I'm able to drill to General Ledger in ARCS, however, when I try to drill to Fixed Assets Subsystem, I'm getting 'Error fetching drill url' Where do you setup t… How to Drill to Subsystem in ARCS?Summary: I'm able to drill to General Ledger in ARCS, however, when I try to drill to Fixed Assets Subsystem, I'm getting 'Error fetching drill url' Where do you setup t…
- 
             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… 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…
- 
             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… 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…
- 
             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… 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…
- 
             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… 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…
- 
             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… 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…
- 
             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 … 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 …
- 
             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 … 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 …
- 
             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… 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…
- 
             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… 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…
- 
             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… 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…
- 
             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… 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…
- 
             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… 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…
- 
             Can preparers add attachment when recons have been auto closed?Summary: General Ledger balance and the Subledger balance have no variances triggering the auto reconciliation rule. Internal Auditors want all reconciliations to have a… Can preparers add attachment when recons have been auto closed?Summary: General Ledger balance and the Subledger balance have no variances triggering the auto reconciliation rule. Internal Auditors want all reconciliations to have a…
- 
             Reviewer not receiving notificationSummary: Reviewer not receiving notification Content (required): Reviewers/approvers are not receiving notification in Microsoft outlook when recons are submitted for ap… Reviewer not receiving notificationSummary: Reviewer not receiving notification Content (required): Reviewers/approvers are not receiving notification in Microsoft outlook when recons are submitted for ap…
- 
             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… 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…
- 
             Compulsory to provide Justification on Rejection of the ReconciliationSummary Compulsory to provide Justification on Rejection of the ReconciliationContent Hi All, The requirement is when the reviewer rejects the reconciliation it should b… Compulsory to provide Justification on Rejection of the ReconciliationSummary Compulsory to provide Justification on Rejection of the ReconciliationContent Hi All, The requirement is when the reviewer rejects the reconciliation it should b…
- 
             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 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
- 
             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… 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…
- 
             Does ARCS Support Translation?Summary Reconciling Translated BalancesContent My client has its headquarter based in US and has branches across the globe (in Europe etc). They want to reconcille balan… Does ARCS Support Translation?Summary Reconciling Translated BalancesContent My client has its headquarter based in US and has branches across the globe (in Europe etc). They want to reconcille balan…
- 
             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… 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…
- 
             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… 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…
- 
             Is there a way to add periods in DM using import file? For Both Global/Application mapping?Summary: Currently we have to manually add periods under DM-->Set up--> Period Mapping-->Global Mapping and Application Mapping, is there a way to load periods here? or … Is there a way to add periods in DM using import file? For Both Global/Application mapping?Summary: Currently we have to manually add periods under DM-->Set up--> Period Mapping-->Global Mapping and Application Mapping, is there a way to load periods here? or …
- 
             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… 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…
- 
             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… 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…
- 
             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 … 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 …
- 
             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… 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 … 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 …
- 
             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… 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…