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
-
Can we enter filter conditions based on member description under source filters in DLR?We are creating an integration with GL where we want to filter out "product" on the basis of "product description" by using the condition : if contains "variable". Expla… -
Restrictions on number of Organization unitsI have couple of questions related to organization units. Is there any restrictions to number of Organization units that is allowed in ARCS ? Can there be download optio… -
Creation of SubSystem Adjustment DLR Fails with Internal Server ErrorSummary: On creating a data load rule to import subsystem transaction adjustments, when we go to save the integration after defining dimension mappings, the save hangs i… -
How to migrate the historical reconciling items from a 3rd party systemSummary: We are about to start our Oracle ARCS project. We are currently using a 3rd party solution to perform the GL and SL Recons. We been using our system from past 1… -
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… -
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? -
New Date Format and Decimal Separator feature in Data Loads creation in ARCS after May'25 patch.Hello Everyone, After the May'2025 patch update, there are two new fields which have to be selected while creating the data loads in the ARCS. It also changed the existi… -
Moved: How to Join Between Project Accounting Sub ledger and GL Sub Ledger Journal LinesThis discussion has been moved. -
Reconciliation Audit Trail report does not show timestampIn Reconciliation Audit Trail report we have below concern, We have one attribute where user can select from yes/no, if someone clicks yes, then changes to no, then chan… -
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 … -
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… -
ARCS- Unable to select more than 30 columns in reconciliations, profiles, etc cardsSummary: User is unable to select more than 30 columns (using Action->Select Columns) in Reconciliations, Profiles etc cards. Please let us know the reason why users are… -
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 … -
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 … -
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 there a way to automate the download of Balance Summary Report for Transaction Matching ?Summary: The requirement is to automate the download of the "Balance Summary Report" of the Transaction Matching > Matching tab > for each Account ID as on Day 1 of a mo… -
Moved: After April patch, Data Exchange ping shows up as log inThis discussion has been moved. -
Will Results be added back to the dataload execution window?Summary: Notice that with the May 2025 release pushed to test environments last weekend, the Result section no longer shows on the Dataload Execution window when accesse… -
ARCS - reviewer 1 has blank end dateSummary: In reconciliation one of profile has showing a blank end date for reviewer 1 which is still open with preparer. Kindly see the screenshots provided. Please give… -
Question on adding auto-certification rules and still being able to add supportSummary: We would like to add auto-certification rules to our balance comparison format reconciliations, but still be able to upload subledger reports as support. Conten… -
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… -
How to translate Subsystem Input Balances in ARCSSummary: Hi Team, In our current ARCS implementation, we have a scenario where client would like to input Sub-System Balances, so we have enabled necessary configuration… -
Where in the LCM Snapshot are Profiles and Reconciliations Kept?Summary: Where in the LCM Snapshot are Profiles and Reconciliations kept? Content (please ensure you mask any confidential information): I am looking at the artifact lis… -
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 … -
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… -
Can a user view the profile for which they are assigned reconciliation in the ARCS ?Can a user view the profile for which they are assigned reconciliation in the ARCS, without even providing them the application role - Profiles - View. -
Data Load is missing records even though ESS Job file had it in themSummary: We created BIP report which was used as ESS Job to pull data to ARCS. File loaded all the records when we manually load it into ARCS, however it ignore lines wh… -
Timing issue for assigning periods to auto-loaded filesSummary: We are setting a cash reconciliation flow in ARCS. Daily, a lot of files are loaded trough OIC into EPM. The issue is because the files often contain data of pr… -
Auto Match Rules Fail without a valid reason in the log.Summary: For one of our French clients where we have defined match types for 1. bank statements and 2. clearing accounts, we continue to encounter several issues when ru… -
How to Refresh Currency Conversion Rates During a Reconciliation ProcessSummary: I currently have an entered CAD bucket and a USD conversion rate for the functional bucket in place. Source ending balances are refreshed daily as part of the l…