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
-
DFFs not displayed when mapping adjustments from ARCS to a context-sensitive DFF for GL journalsSummary: DFFs not displayed when mapping adjustments from ARCS to a context-sensitive DFF for GL journals Content (please ensure you mask any confidential information): … -
Does ARCS have reporting capabilities for Alerts, including Alert comments?We have users that would like a report on the Alerts, including Alert comments. Is there an option in ARCS or an epmautomate script that will give us this information? -
How to Use Net Activity in Auto-Submit Rules?When creating an auto-submit rule for a quarterly rec, we would like to use the Net Activity balance as one of the rule conditions. However, Net Activity does not appear…
-
ARCS Match Rules Help Critical (GL vs Bank)Summary: We are trying to build a Match Rule to match detailed transactions from GL with Bank data. The rule goes as below: Many GL to 1 Bank: GL side : If uid= PAC and …
-
Transaction Matching Balancing Report - confusing when multiple currenciesSummary: I am working on a proof of concept to test feasibility of a customer use-case: reconciliation is a Balance Comparison with Transaction matching, data from both …
-
Feedback on Account ID format when source GL accounts that contain dashesSummary: Feedback on Account ID format when source GL accounts that contain dashes Content (please ensure you mask any confidential information): We're currently undergo… -
ARCS Artifact updatesSummary: ARCS not logging all the data load mapping changes for the Artifact 'Data Load Mapping' updates, we do the data load mapping changes on daily basis, but in few …
-
Oracle ARCS-archive ARCS to third party archival softwaresSummary: Hi all, We are looking to download data from Oracle ARCS, like Recons, Profiles, Attachments, etc. and archive them to a third party archival softwares like Inf…
-
Split Profiles and Reconciliations – Manage role accessSummary: Is there a way to restrict profile access while still allowing the Power User to manage reconciliations? Content (please ensure you mask any confidential inform…
-
Custom Warning Message in Oracle ARCS Transaction MatchingWe have a requirement in oracle ARCS where we need to have a warning message for Users in Oracle ARCS Transaction Matching when User is matching 1-1 transactions for cer…
-
Which Oracle Database table gives user information in ARCSSummary: Which Database table captures information like Email Id, last updated by, Last updated date, etc in ARCS. Content (please ensure you mask any confidential infor…
-
TM: Unmatching/discarding suggested matches in bulkSummary: in transaction matching, users will have daily data load, do we have the functionality to discard suggested matches in bulk so that they can be considered for m…
-
How to separate amount and currency from a combined balance field (example: 500.00 EUR)?Summary: Hello Everyone, I’m looking for ideas and expert opinions on handling a combined amount + currency field that is displayed in the following format: SourceSystem… -
Is there a limit to number of mappings allowed in Data Exchange?Summary: Is there a max number of mappings allowed by Data Exchange? Content (please ensure you mask any confidential information): Transaction matching process where tr…
-
Multiple string operations in SQL for Data Exchange failsSummary: Transaction matching process: one of the columns coming from a data source needs some transformation. I need to transform a text value from AAAAAA-BBB format to…
-
how can i change font colour in appearance now after redwood theme.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to schedule ARCS Activity Summary notifications on specific business days (BD7–BD9 / BD14–BD17)?Summary: Hi Everyone, We are trying to understand how Oracle ARCS handles Activity Summary email notifications, and whether there is a supported way to control when thes…
-
Max limit of transactions in Transaction Matching Custom report output in excelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Delete massively Transaction uploadedSummary: Deleting Transactions uploaded the previous month to upload a new file in order to avoid duplications. Content (please ensure you mask any confidential informat…
-
Are there any AI features currently available for Oracle ARCS?Hi Team, I am attaching a PDF shared with us regarding Oracle EPM AI features. However, this document does not clearly mention whether any AI / ML capabilities are curre…
-
Match transactions across reconciliation IDsSummary: We need to match transactions across reconciliation IDs. For example, we need to match transactions that exist in Rec_ID_1 with transactions that exist in Rec_I…
-
Discrepancy between workbench data and TDATASEG tableHi Team, I am trying to generate a report for a location. However, while validating the amount values I am seeing 4 cents discrepancy between workbench and TDATASEG tabl…
-
How is Aging calculated if Close Date is left blank?Summary: How is Aging calculated if Close Date is left blank? Content (please ensure you mask any confidential information): If business does not put a close date in rec…
-
Copy transaction from prior period creating transaction for Functional bucket in new periodSummary: A Nov-25 transaction is created in the reconciliation with only an amount in the entered currency bucket - nothing for functional. This is intentional. When thi… -
oracle Account Reconciliation REST API how to delete Associated import Job ID DataThe Data Loading API (OIC to ARCS) currently supports loading data but does not provide options for rollback or deletion Please let us know any REST API available for th…
-
How do I import group attribute values into transaction matching screenI have created a group attribute table and can see the "new" attributes in the transaction matching screen. However, I cannot get the values to populate when importing d…
-
Why can't the group profile be used for a transaction matching method?Summary: Group Profile checkbox is greyed out for all methods that include TM. Content (please ensure you mask any confidential information): Hello, we are using the TM …
-
Any supported method to switch an account to a new Match Type w/o loosing past informationSummary: Is there any supported method or functionality that would allow us to switch an account to a new Match Type without losing any information (transactions, reconc… -
How to configure daily FX rates in ARCSSummary: I am trying to configure ARCS to load daily FX rates, but the system only provides an option to load a single rate for the entire period. I need to set up a pro…
-
Group Details/Balance Explanation for Account AnalysisSummary: Wanted to understand the purpose of Balance Explanation for Account Analysis if we have Group Reconciliation Enabled Content (please ensure you mask any confide…