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
-
Load Historical GL balance to ARCS subledgerWe have historical GL balance in multiple accounts that is not available in source system subledgers. During reconciliations users are loading this balance as subledger … -
Can we make amendment in Report Binder layout or design?Is it possible to add Company's Brand logo in report binder? Can we remove some unrequired data from report output? Any approval mechanism can we add to report binder?
-
Can we increase the maximum file attachment size for ARCS individual uploads - It is 20MB as of now.Summary: We have received request if there is any possibility to increase the limit of 20MB for individual uploads for reconciliations. There are some excel file which a…
-
Loading Thai charactersSummary: Hi, My client data has fields with data in thai language. While loading thai characters become junk like Question mark, square boxed etc. Can we load thai chara…
-
Moved: How to Join Between Project Accounting Sub ledger and GL Sub Ledger Journal LinesThis discussion has been moved. -
Account Reconciliation Rejection DatesSummary: We are trying to pull in some metrics on account reconciliations that have been rejected and would like to see the dates they were rejected. Content (please ens…
-
Are we able to add an alert if an Action Plan Close Date has elapsed?Summary: Interested in enhancing the functionality of the Action Plan to allow notification if the date entered in the Action Plan Close Date field has passed. Content (… -
Pros/Cons of using FCC to Load ARCSHi - can anyone tell me what they have found to be pros/cons of using FCC balances to load ARCS?
-
Using ARCS for Cash Transaction MatchingSummary: We have a client that is implementing Oracle Cash Management as well as EPM ARCS. They want to implement transaction matching for the cash accounts. Content (re… -
ARCS Release 21.11: Create Custom User GroupsSummary: Custom User Groups are not listed in Workflow or Access sections of Profile Content (required): Release 21.11 includes an option to create custom user groups fr… -
Need to export reconciliations and Transaction using rest API or EPM automateSummary: Is there any way that we can export specific View of recon's and Transaction using EPM automate or any rest API Content (please ensure you mask any confidential…
-
In ARCS (EPM), an automated process of load of explanation is required for GL accountsAs part of our ARCS implementation (EPM), we have a requirement for reconciling GL accounts under the Account Analysis method. Currently, users need to manually provide …
-
Monitoring EPM Integration Agent healthSummary: Hello, I'm looking for a tool or method that proactively checks the health of the EPM Agent before running a Data Exchange integration. We use the EPM Agent to … -
DM Logic Accounts: need to prevent summarization of identical rowsSummary: We are duplicating transactions 1-by-1 using logic accounts and everything was working as expected, except with a recent load file that contained 5 rows which w…
-
Map 2 Source Amounts to Target for ARCS AP subledgerSummary: In Oracle ARCS, AR subledger Integration Setup/ Import Format maps source " FUNCTIONALAMOUNTREMAINING " to target "Amount". This works for existing account 1210…
-
ARCS DM Special Character ? only works when "Apply to Rule" is used. Why?Summary: ARCS DM Special Character? only works when "Apply to Rule" is used. Why? Content (please ensure you mask any confidential information): I had been exploring som…Conner Nations - Finacial Systems Manager 21 views 1 comment 0 points Most recent by BillHack-Oracle -
How to show 0.00 balance in the Group Detail list of Group ReconciliationsMy Reconciliation Profile is connected to a format with Group Reconciliation, this allow me to see a group of accounts in the Group Details of the Group Reconciliation. …
-
Is EPM job Scheduler available in ARCSSummary: Just curious to know if we have EPM Scheduler in ARCS Application? Content (please ensure you mask any confidential information): Version (include the version y… -
How to pass SYSDATE parameter to OnPremise database using EPM Integration AGent select queryHello, I have a question regarding EPM Data Exchange EPM Agent integration with On Premise Database where we are trying to load incremental data from ERP On premise to A…
-
Export Data management configurations - ARCSSummary: DM configuration export. Identify DLR for reconciliation balances with * to * mapping Content (please ensure you mask any confidential information): Is there a …
-
Using Send Email on Update rule, Preparer should be notified once every week for 30 daysSummary: Hi, We have a business scenario to send email to preparer on a weekly basis until the preparer duration (30 days) ends. The email notification is for reminding …
-
BAI Transactions Imported with Statement Date instead of Transaction DateSummary: BAI Transactions are currently imported with Statement Date which should be using Transaction Date Content (please ensure you mask any confidential information)…
-
Oracle ARCS Custom Report-Date parameterSummary: Client has a requirement wherein they want to generate report on month to date basis. Meaning when I generate report today (22/10/2024), it should fetch transac…
-
Transaction Matching - Export journals for many match typesI try to export all the journal adjustments of the day in one integration. The adjustments come from many match types. I have created an integration with source "Account…
-
Transaction Matching : How to transfer support attribute data into adjustment attributesWe want to use a one sided adjustment to self-match transactions. We need to define rules of adjutment type to create adjustments from supported transactions. Adjustment…
-
Report containing all unmatched transactions by period.Summary: We have a need of a report of all unmatched transactions over 90 days by period. This is a key control in our organization. We could use the Balance Report Tran…
-
Dash board issueI want to create a pie chart showing: 1.The percentage of reconciliations prepared on time and late. 2.The percentage of reconciliations reviewed on time and late. When …
-
EPM Data Management query to Accounting Foundation (AFCS) tablesSummary: EPM Data Management query to Accounting Foundation (AFCS) tables: how do it? Content (please ensure you mask any confidential information): Version (include the…
-
[ARCS] How to filter out other currency data in Reconciliation's Source System Ending BalanceWe have created an integration for our source system ending balance with ERP GL as our source. When we try to re-execute the Integration, we noticed that in some of our …
-
Bank verification issue with BAI file that does not contain currencyHi, We have a BAI file that does not contain currencies in the 03 records. When we run the integration with the "Verify Statement Balances" option enabled, it says "Appr…