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
-
ARCS Bulk Approval ReconciliationsSummary: Require Bulk Approval reconciliations options to Users to approve multiple reconciliations of same nature in one go. Content (please ensure you mask any confide… -
Balance Explanations doesnt allow to load more than 500K records - that too without Merge/AppendSummary: For an Inventory Account using Account Analysis method, while trying to import balance explanations (which are more than a million each month), the Load rule fa…
-
To Update AR Interface Table DataHi Oracle Community, We have a requirement to update the 'MemoLine' field in AR interface table in Oracle fusion. We have tried the below rest API but in the response pa…
-
Transaction Matching - Maximum number of transactions matched for many to many ruleSummary: For Many to Many matching, what is the maximum number of transactions that can be matched in one side? In one of the projects, we are facing challenge with resp…
-
Not receiving "Status Change" email notificationSummary: Under "Status Change Notification" settings, I have set my notification for "You are the reconciliation preparer and status changes to open with preparer" and "…
-
Exclude members from selected hierarchy(But Not All Hierarchies) using IGNORE mappingSummary: The requirement is to ignore member from selected hierarchy for GL direct integration but not all hierarchies. Context: We have a member 119001 which is in mult…
-
Can we add more than 60 attributes in application under data exchangeWe need to pull data from BIP Report to ARCS and BIP report contain more than 60 attributes but not able to add more then 40 attributes and 20 UD in the application unde…
-
Create a report of detail balance which will have unexplained difference on 11 Dimension levelHi Team, I want to create a report for below scenario:- Our ARCS system have reconciliation configured based on 6D, however, the mapping is done on 11D. Hence user can d…
-
Activity Summary emails are no longer being sentSummary: Activity Summary emails are no longer being sent consistently to our users and this has been happening since (we believe) sometime in October of 2023. Users use…
-
How to create a report of detail balance.Hi Team, Can we check if a reconciliation was autosubmit and autoclosed by a rule or manually submitted/closed in report? Is there a table which store highlighted column…
-
Reset service command : Does it affect the ARCS configuration setup?Summary: Due to some performance issues, we had to perform epmautomate Reset service command on the ARCS instance. Post which, we observed few issues: 1. Few mappings in…
-
Only enable the notification for reconciliation RejectionsSummary: Only enable the notification for Reconciliation Rejections Email Notifications is turn On There is no way to stop late notification ( there is no option as Neve…
-
How can I require recs to stay open even if they meet auto requirementFor example If a rec is auto/rule reconciled 6 months in a row, it will automatically require attention the 7th month even if it meets auto/rule reconcile criteria.
-
What are the available AI capabilities in ARCSSummary: We are exploring the AI within the ARCS and wanted to know, what are AI capabilities in oracle ARCS & how can we integrate AI in ARCS in order to make the proce…
-
Is there a way to delete Match Process in Transaction Matching?Summary: We have created a Match type withing which we have created Match processes. When we tried deleting it, the same always errors out saying "Unable to delete the M…
-
Rest API to download the audit log from ARCSSummary: Is there any rest API available to download the audit logs from ARCS. We have a SOX requirement that we want to automate. Content (please ensure you mask any co…
-
Camt.053 xml Balances file period mapping to ARCSSummary: We have a requirement to load CAMT.053 bank file balance data into ARCS Reconciliation compliance .We have selected the Out-of-box adapter to configure the data…
-
Has anyone explored the possibility of integrating Narrative Reporting with ARCS?Summary: Has anyone explored the possibility of integrating Narrative Reporting with ARCS? I would appreciate it if you could share any challenges you faced. Content (pl…
-
Question on BAI Format Bank Files feature in July 2025 releaseHi Everyone, I was testing the July 2025 release feature on "Length of Bank Text Column Increased to 1200 Characters When Using BAI Format Bank Files". It is mentioned a…
-
Reopen the reconciliation based on filter using epmautomate commandHi Team, I want to reopen the reconciliation based on the filters set in the Oracle ARCS using epmautomate command. However, we are not updating any attribute but reopen…
-
Add survey question for specific period in formatHi Team, We want to add a survey question but it should only be displayed for Oct-25 period and not all the periods before and after that. Could you please help us to de…
-
Workflow Email NotificationSummary Email Notification when Submitting, Approving, and Rejecting ReconciliationsContent We would like to send email notification to the Preparer when a reconciliatio…
-
Place to specify journal source as filter and out of box adaptor for GL transaction from Fusion?We want to add journal source as filter which is only visible at application registration option only. I do not see that option in integration. Is there any other place … -
ARCS how to remove spaces in a calculated attributeSummary: I have a calculated attribute : SUBSTRING({attribute6},0,6) which can contain spaces. It's used in a rule and I need to remove spaces, otherwise the rule doesn'…
-
Can ARCS Custom Reports generate a multi-query workbook output?Each week we are manually piecing together an Excel workbook that uses multiple views, dashboards, and custom query outputs from Account Reconciliation. Is there a way t… -
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… -
Calculate Age days for TransactionHi Team I have created an attribute in Match type of Age_days which is calculating based on a different date and not accounting date. Calculation type:- Scripted Formula…
-
How To Change Data Type and Perform Data Fix for Match Type ConfigurationSummary: Due to an incorrect setup, the data type of the "Data Source Attribute" in the Match Type was set to Integer instead of Text. We would like to request a change …
-
ARC to FCC Enterprise Journal creation is refusing to connectSummary: Create Journal page refuses to connect to pull the template in ARC, however connection is successful in configuration settings Content (please ensure you mask a…
-
Role Field in ARM_QUESTIONS tableSummary: We are building a custom report to show results of a specific reconciliation question. When querying ARM_QUESTIONS field ORDER_SEQ =2, the results show both Pre…