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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Account Reconciliation
Discussion List
-
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…
-
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 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…
-
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…
-
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 …
-
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 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…
-
Reassignment request requires 'To' field to be mandatorySummary: When a user or admin creates reassignment request. both from field and to field were left optional which is a problem because users are not selecting any name f…
-
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 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…
-
Unique Transaction IDsSummary: Transaction IDs are not unique system wide Content (please ensure you mask any confidential information): Some users noticed that when using transaction matchin… -
automate updating group reconciliation balancesSummary: Guys, we are using a group reconciliation and in the normal routine the preparer user must update the summary balance by clicking on "run all" actions, our clie…
-
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…