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 sum of two columns as amountSummary: Hi All, We have a report(flat file) as shown below which has two types of assets. We need to load sum of those assets as amount into Reconciliation Compliance t… -
How to subscribe to object storage for ARCSSummary: We have a large database with several GB of attachments, so we're realizing quickly we'll need to use the Object Storage Bucket option in the future. How do we …
-
Unexplained Balances roll-up to parent account type of the hierarchy for the particular account typeSummary: How to show the Unexplained Balances roll-up to parent account type of the hierarchy for the particular account type of profile For Reconciliation.. Content (pl…
-
Transaction matching daily loadSummary: Client wants to load transaction daily along with GL Balance. For Transaction to load every daily along with GL balance, in the parameter for Start date we had …
-
Multiple DLRSummary: Multiple DLR in Transaction Matching Content (please ensure you mask any confidential information): We have EPM automate scripts for different DLRs for Transact…
-
Can a user that has not claimed a reconciliation upload transactions to it?Summary: We are seeing an instance where a user has submitted balance explanations through the Reconciliation Compliance add in to Reconciliations that he has not claime…
-
Adding Fields to ARCS ReportsOne of our users was recently looking for aging transactions in ARCS and they found a report title "Transaction Aging Analysis" They wanted to add more fields to get mor…
-
Retrieve "Invalid Mappings" file after Data loadSummary: We are trying to retrieve the "Invalid mappings" file using REST API which will be available below the Result column after doing "Import Data" for a period. Do …
-
how can reviewers flag transactions?Summary: In Oracle docs it states that Reviewers of reconciliations can Flag transactions What are the steps involved as i can not find any documentation saying how this…
-
What's New & Transaction Matching to Reconciliation Compliance Integration Deep DiveHi everyone, As mentioned on the Feb 1st, 2024 webinar "What's New & Transaction Matching to Reconciliation Compliance Integration Deep Dive" I wanted to attached the do… -
Is there a way to turn off notifications for late reconciliations?Summary: Currently, only option for late notifications is to receive 1 email a day, however, we have a lot of users who have daily recs and if they have these notificati…
-
Loading Daily Balance from GLSummary Automatically scheduling Daily load of balances from GL to ARCS -Balance ReconcilitationContent Hi All Need your suggestion on the configuration Scenario- Client… -
data load mappingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Need help with "Map Members" for Dates coming in blankSummary: I am needing assistance mapping a new date column for one of our Transaction Matching sources. I believe I am getting an error due to dates coming in as null an… -
Adding of the users in ARCS application through REST APIWe are trying to automate the process of adding the users and assigning teams in ARCS application using REST API. For that we need the information regarding the URL. Ple…
-
RPAD Function in Data ExchangeSummary: RPAD Function not working in Data Exchange Content (please ensure you mask any confidential information): Hi All, Has anyone successfully used the RPAD function…
-
Enable end-user to load balances in ARCSAt present, the client is loading pre-mapped balances in ARCS. I am seeking guidance on how to restrict a user's access to only loading pre-mapped balances, without gran…
-
Moved: Oracle ARCS - AD groupsThis discussion has been moved.
-
how to hide rows when values in all columns are 0 in custom report in account reconciliation?I want to hide rows when values in all columns are zero. The condition I want to use is below:- to hide policies rows from the output that have both of the following cri…
-
How to make matched transaction to unmatched status in account reconciliation match typeHi All, I have made changes in the match type by adding contact number exactly matched condition in the existing rules. now before adding this condition, 20,000 transact…
-
Excessive ARCS email notifications on creation - how to reduce?Summary: We have all ARCS recons assigned at a team level and use the claim/releaser functionality. We have approx 4k recons in total per month to action in ARCS. What o…
-
ARCS - Reconciliation BalanceSummary: Few years ago, during a demo, we saw that we can created reconciliations as below : Meaning having a source system balance and a reconciliation balance (which i…
-
How to generate report with high volume in multiple excel tabsSummary: I am getting error "maximum limit reached" in ARCS report which has 1.6 M records in XLSX format. Is there a way we can split the records in multiple sheets / t… -
Ability to bulk update transactions in ARCSIs there a way to bulk/mass update the attribute details for the transactions loaded into ARCS instead of updating manually one by one? Transaction Matching file is sent…
-
Functional Currency showing USDSummary: We have a client that wants to load their rec compliance balances into the functional bucket in ARCS. On the rec the functional EUR is blank but the Functional …
-
ARCS Profile Default ConfigurationSummary: Can you please provide confirmation that in order to have a valid profile in arcs, a preparer and reviewer must be assigned and that it is default functionality…
-
Need to know on ARCS, can we connect use file other then CSV whist we're using Custom Integration?When we do custom Integration, we use file which is in CSV format by running the report as ESS job. Is there a way where we can integrate the file as per the output whic…
-
EPM Automate Command to extract custom reportSummary: We are looking for a EPM automate which will be used to extract Custom Reports in the ARCS Content (please ensure you mask any confidential information): Versio…
-
Maintenance activity of User Credentials to connect to the On premises DatabaseSummary: We have approx 70+ Applications with Category as Data Source and Type as On premises Database. For every application on this screen, we have to populate the Use…
-
Need Norway timing in Jobs which are running in the systemWhen we were Loading data for specific month, we observed that the job time shown in the System are the different one rather the original one (Norwegian time); however, …