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
-
Pull Peoplesoft Balances hourly into ARCS for reconciliationSummary: We have a requirement from business where we have to pull Peoplesoft Balances every hour for reconciliation specially on BD3. Below is the process that we are f… -
Epmautomate to export data from data management for particular locationSummary : Epmautomate to export data from data management for particular location
-
Missing Profile not visible to Application Role UserSummary: Hi, We noticed that a service administrator is able report on Account-IDs are loaded from DM but does not have a corresponding profile. Reconciliations → Detail…
-
Automation is required in capturing balance explanation in GL accounts (ARCS module)As part of our ARCS implementation, we have a requirement for reconciling GL accounts under the Account Analysis method. Currently, users need to manually provide Balanc…
-
Enterprise journal connection in ARCS failingSummary: Enterprise Journal Connection in ARCS failing Content (please ensure you mask any confidential information): I am trying to connect FCCS to ARCS using Service a…
-
automate download of invalid mapping reportSummary: Currently in the Oracle ARCS application, the user has to log into the application and manually download the Invalid Mappings Report for a given period. Is ther…
-
ARCS Integration on Data Exchange fails if there are no rows to loadSummary: When we execute a file based integration in ARCS, there are scenarios when the Data Map Rules reject all the rows and this is a valid scenario. However the inte…
-
Is it possible to see transaction attribute in reconciliationSummary: In Attributes we have scorecard criteria attribute when we add unknown disposition action plan attribute in transaction level, we are not able to see that colum…
-
Error in Alert SubmissionSummary: I am trying to create alert for a closed reconciliation as part of evaluation process by team of reviewer. 10 Mandatory questions are added to this alter type a…
-
AI in ARCSWhat are AI capabilities in oracle ARCS & how can we integrate AI in ARCS in order to make the processes more efficient and easier? Please provide some documentation if …
-
Create Reconciliations Processing Attachments - performance issueSummary: Why does Processing Attachments stage of Create Reconciliations process takes so long - we have about 50k Recs to open and this laste stage of the job to Proces…
-
3 Data Source Match with ARCSWe are configuring 3 Data Source to match 1 line of transaction from source 1 to match with source 2 & 3 The requirement is to match A=B=C (A:B and A:C) without loading …
-
How to reference a field loaded as an AttributeSummary: My General Ledger balance file is loaded with several fields as attributes, such as "ENABLED-FLAG", "Unit Desc", and others. However, I cannot select these fiel… -
Is there a way to upload attachments to existing reconciliations using web services/REST API?Summary: We have a use case where we have extracted attachments from another reconciliation tool and we would like to upload those attachments to their respective reconc…
-
How to assign Profile in ARCSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
loading multi-column Numeric data as amountSummary: loading multi-column Numeric data as amount Content (please ensure you mask any confidential information): We have a source file with a receipt and payment colu…
-
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…
-
Moved: API to download activity ReportThis discussion has been moved. -
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 …
-
Is there a way we can Export Forex Rates loaded in ARCs?Summary: We are looking to export Forex Rates loaded in ARCs to do internal validation. is there a way we can export FX Rates to csv/excel? Content (please ensure you ma…
-
Schedule from close date vs end dateHi, Could you help me understand setting in profiles called "Schedule from"? I see that there is option to choose end date vs close date but I don't know the difference.…
-
Hide Sub-ledger column for Reporting CurrencySummary: Is it possible in ARCS to have the Format with Method as Balance Comparison however hide the sub-ledger column for Reporting Currency? The Functional Currency s… -
Period Mapping in ARCS for loading FCCS balanceWe are setting up data load rules on the ARCS end to source the balance from FCCS. The rule is querying the source FCCS correctly for the period however its not able to …
-
How to add an attachment to more than 100 transactions at onceI am trying to add an attachment to more than 100 transactions at once in ARCS. However, it is giving an error that you cannot attach to more than 100 transaction. Could…
-
How to remove carry forward of comments updated by Users whose access is removedSummary: We noticed some accounts in ARCS where comments are getting carry forward, but the current preparer/reviewer cannot edit or remove them as the title shows "Admi…
-
Is it possible to systemically extract data from a saved detail balance's viewSummary: We currently have two saved views in the detail balances section of ARCS. We are looking for a way to extract data from one of the views so it can be used for a…
-
Daily-maintenance time windowSummary: Daily-maintenance time window post patch-updates Content (please ensure you mask any confidential information): Hi team, Could you please confirm if daily-maint…
-
[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 …
-
How to Create Alerts Based on Required Questions in a Reconciliation ReviewSummary: I need assistance with setting up alerts for required questions in a reconciliation review process. The questions are formatted as yes/no, and they must be answ…
-
Auto reconciliation options for reconciliations with no dataSummary: In ARCS, we do not load zero's in the system, due to several reasons. So often accounts do not contain data because the 0 is not loaded. Is there a way to auto …