Category 117
Discussion List
-
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… -
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… -
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…Srinivas Nuthi 12 views 2 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
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 …Kimberly Carranza 92 views 11 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
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…
-
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…
-
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 …Srinivas Nuthi 24 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
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…
-
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… -
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…
-
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.
-
Can you give Power Users access to Match Types?Summary: Business request to give Power Users access to Match Types. Content (required): Business request to give Power Users access to Match Types, and they do NOT want… -
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… -
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…
-
How to create report with group account along with group details in ARCSSummary: Client wants to view all the group account along with group account (sub accounts) details in a report format. We tried to create view but there is no such opti…Dipankar Malik - Accenture 253 views 21 comments 1 point Most recent by Dipankar Malik - Accenture Account Reconciliation -
Preparer End date(actual) vs Shown activity date in HistorySummary: In compliance on the face of the reconciliation in the Workflow tab, we can see the preparer has submitted the reconciliation at 9:30am AEST on Oct-30. On the R… -
Is there a ability to automate delete transactions from transaction matching page if load failsSummary: In the current scenario, we actually have to manually delete transactions whenever duplicate load happens or load fails. We want to eliminate manual interventio…
-
How to query ARCS TM Database directly to retrieve warning messages from ARCS TM Job log filesSummary: Hi Team, How to query the ARCS TM (Transaction Matching) Database directly in order to retrieve warning messages from the ARCS TM Job log files. Our aim is to a…Devaraju sabbithi-Oracle 107 views 3 comments 0 points Most recent by Devaraju sabbithi-Oracle Account Reconciliation
-
ARCS - fields suggested match - highlightSummary: ARCS - Possibility to highlight reconciliation fields for each rule level Content (please ensure you mask any confidential information): Hi everyone, the result…
-
How to have ARCS rules apply to multiple currency balances within single currency bucket?Summary: For the Entered Currency bucket, a number of reconciliations have multiple currencies that appear in that bucket. For example, in the attached screenshot this r…Steven Woods 104 views 4 comments 0 points Most recent by Bill Stevens - 1234 Account Reconciliation
-
How to schedule custom report for Transaction Matching?Summary: Content (required): How to schedule custom reports for Transaction Matching? the custom report contains only matched transactions. Thanks Version (include the v…
-
Need to find GL record count sent to ARCSSummary: Is there an ability to locate the record count from Cloud GL that is sent to ARCS for data load/integration completeness check? Content (please ensure you mask …
-
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…
-
how to make certain fields required so the system prevents the profiles to be saved with missing infprofile was updated and fields were left blank, system allowed the Power User to save it and it came back as invalid. Sometimes we don’t catch these items right away and…Denise with Penn Entertainment 11 views 3 comments 0 points Most recent by Braxton Sowell Account Reconciliation
-
Is it possible to do a one to many or many to many match rule with grouping on both sides?Summary: Is it possible to do a one to many or many to many match rule with grouping on both sides? I have read that grouping on both sides while using many to many resu…