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
-
"Send Email on Update" rule - Not sending email to users if specific reconciliation is approvedSummary: Despite configuring "Send Email on Update" rule at the format, profile, and reconciliation levels, emails are not being sent to users with the reconciliation wh… -
Selecting the target values for the Source Type dimension from a drop-down list in DM.(New feature)Hello Everyone, In ARCS, Dec'24 release there is a new feature : when using Data Integration to configure a data load mapping, you can now select the target values for t…
-
EPM ARCS Solution Architecture DiagramSummary: Is there any available EPM ARCS Solution Architecture Diagram? Can you provide me a link where I can take reference? Content (please ensure you mask any confide… -
Drill Through to Source and Open Source Document is not working in ARCSDrill Through to Source and Open Source Document is not working in ARCS. For Drill through - we are seeing Error in Fetching details For Open Source Document - The downl…
-
There is any way to export amortization Schedule, exactly how it looks in front end in ARCSSummary: While I exported the amortization schedule from ARCS, In the exported file it is giving only the amortized amount, how to get exact amortization schedule which …
-
Is there a way in ARCS to setup a warning if a job is in "PENDING" status before the cycle starts?Summary: Is there a way in ARCS to setup a warning if a job is in "PENDING" status before the cycle starts? Content (please ensure you mask any confidential information)…
-
Is there a way to export format rules?We'd like to do an export of the custom rules for each format. Is there a way to export the format rules? Seems like there isn't an export option but wondering if there'…
-
How to reconcile data imported from ERP into ARCSHello, We import GL balances and Subledger Balances from Oracle fusion ERP into ARCS module. We are looking for a system generated report that would give us reconciliati…
-
How to export Views from Reconciliations Page to Data Exchange FolderIs there a way to export saved "Views" from the Reconciliations Page and have it sent outbound to a SFTP Folder using data exchange or otherwise. The goal is to automate…
-
How can I enable or get an "Age" column in "Balance report transaction" in Transaction Matching?To be able to use Transaction Matching files for reconciliation, we need column age available in download. As we need to support aged items. Attached is download from EP…
-
could we connect PowerBI directly to Oracle DB via "DirectQuery" to help alleviate some ETL concern?Summary: One of the initial activities involves compiling and dashboarding ARCS data to analyze and present particular findings utilizing Power BI. working with Reconcil…
-
Unmatched transactions email notificationsHi, The users wants to receive email notifications whenever there are variance between new unmatched transactions in POS x Bank (See image attached). We searched Oracle'…
-
ARCS - Late Category Not Working as ExpectedSummary: In ARCS, we track the late reconciliations. We track what's late for the preparer, what's late for the reviewer and what's late (in global). Content (please ens…
-
Export all Transactions from Reconciliations more than 500000Summary: Hi, we are trying to export the transactions of Reconciliations but while exporting the transactions which are more than 500000, its only exporting 500000 lines…
-
Account Reconciliation amortization schedule shows undefined periods & unable to create scheduleI have created an amortization schedule in my client's prepayments reconciliation for March however, I am only able to select Jan - Mar as the start date period. Any per… -
Adjustment to Subsystem Error - Possible to Turn Off or Avoid?Summary: Is it possible to turn off the warning for Adjustment to Subsystem on either a Profile basis or enterprise-wide? Or is there something we should do different to… -
Can the task of Period management (Open, close) be given to others than Administrators?Summary: My customer wants the Power Users to handle Period statuses Content (please ensure you mask any confidential information): I am implementing AR to a new custome…
-
How to bring Total / percentage of reconciliation counts based on the attribute?Summary: We are trying to simulate the custom dashboard. It defines the number of Reconciliations spot check completed/Failed against each reviewer. We were able to get …
-
Bank Statement Verification Option for CAMT.053 Statement Balances in Data IntegrationSummary: In recent ARCS release notes Oracle provided information on 'Bank Statement Verification Option for Bai Statement Balances in Data Integration' can you please l…
-
Announcing: New How Do I?... Help Center Page for Account ReconciliationSummary: A new How Do I?… Help Center library page is now available for Account Reconciliation. Content (please ensure you mask any confidential information): We are ple… -
Automate the workbench file to load it into ARCS applicationSummary: Hi, In "ARCS" we are setting up an application where source is "FCCS" and target is "ARCS" but the source application mapping is little bit tricky where the map…
-
Team Member Cannot Reopen Auto Reconciled ReconciliationsSummary: We have some reconciliations that are not Reopening as expected. These have the following attributes: Auto Reconciliation Method = Balance is zero and no activi…
-
If Application Roles are assigned to Viewers in EPM, will they all work as expected?Summary: Will assigning Application Roles to Viewers work? Content (please ensure you mask any confidential information): If Application Roles are assigned to Viewers in… -
Is there a way to copy a rule from one format to another?We have rules set up on various formats in ARCS. We'd like to use the same rule in one format in another format. Is there a way to copy a rule from one format to another…
-
ARCS RC - Reassignment Requests automationHello, Is there a way to automate reassignments in the ARCS RC module? We’re dealing with a flood of reassignment requests from users each month. While some can be self-… -
Reconciliation between balances (ERP) and workbench data (FCCS)Summary: I would like to know the best way to set up a reconciliation between ERP ending balances and a workbench data file from FCCS in order to ensure that mapping bet…
-
How to pull Instructions for a profile on a custom report / view?in ARCS How to pull Instructions for a profile on a custom report / view?
-
BAI vs. BAI2 file formatSummary: We are trying to load both BAI and BAI2 files into transaction matching accounts, via integrations using a BAI Format Bank File Transactions target application.…
-
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…
-
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…