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
-
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… -
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… -
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… -
How to eliminate zeros while creating the TB report in DM as the total records exceeds the limitWe are currently facing an issue where we are unable to generate a Data Management (DM) report for a Rule using the epmautomate runDMreport command. The report includes … -
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… -
Closed Reconciliations are Reopening in ARCSSummary: In ARCS, we are facing an issue where the closed reconciliations are reopening. Even if there is no balance change closed reconciliations are reopening for that… -
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… -
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 … -
Peoplesoft integration with ARCS using OICSummary: Hi Experts, We are exploring the ways to connect the Peoplesoft to Oracle ARCS using the Oracle Integration cloud (OIC) and EPM Agent. What will be the best app… -
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… -
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… -
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… -
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… -
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… -
Application Max Size (GB)?Is there a published or theoretical maximum application size? I understand that Oracle recommends best practice to use OCI Object Storage for attachments; however, users… -
Inquiry Regarding Increase in 20MB Attachment File Size Limit in Oracle ARCSSummary: We are currently using Oracle ARCS and would like to understand how the 20MB attachment file size limit can be increased, as our client is unable to attach thei… -
When New Role for Managing Data Integration Administrator feature has introduced?Summary: As a part of July 2025 patch release (07.2025) notes, which mention a new feature called “Data Integration Administrator” has been added. However, we have notic… -
Further aggregate results of a SQL query in BI Publisher RTF templateSummary: I have successfully created a SQL query to report on the number and amount of unmatched transactions by period and aging bucket but it seems we are still seeing… -
Transaction Matching with Balance ComparisonHi team, I have currently created the setup for Transaction Matching with Balance Comparison. However, I wanted to check whether we can have a tab of group detail balanc… -
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 … -
A Rule on Format is not working as expectedHello, We have a file based data load to subsystem. In which a profile has data to multiple currencies and it is loading perfectly. We have a format rule to "Prevent Rec… -
Moved: Different ship to address on AR invoice for supply chain financial orchestrationThis discussion has been moved. -
Process for Upload Ending BalanceSummary: I uploaded the Ending Balance data for a total of 3 profiles. Later, I wanted to update the Ending Balance for only one of those profiles. I tried uploading dat… -
Need API Details for certain team management functions in ARCSSummary: We have been able to locate APIs related to managing users, groups, and roles—specifically for adding and removing users from teams within Account Reconciliatio… -
How to import Data Source Attributes with Calculations to existing Match Type in Oracle ARCS?Is there a way to import changes to an existing Match Type in Oracle ARCS? I tried exporting existing Match Type, made changes to the 'MT_DSAttributes.csv' file and 'MT_… -
Unable to edit the match type to pending statusSummary: After performing a clone from Production to Lower instance I m unable to change the match type to pending status in the lower instance. Error- An error has occu… -
Need Best Practice for Creating Multiple Manual Match Rules with Different Tolerance in Single MatchSummary: Need Best Practice for Creating Multiple Manual Match Rules with Different Tolerance in Single Match Process Hi Team, I am working on a Transaction Matching set… -
ARCS - dashborad/reportIs it possible to create a report/dashboard that only shows matches with non-zero variance? Below is an image of a case that should appear in the report/dashboard yours … -
Oracle ARCS Custom Dashboard gives random resultsHello, I am trying to create a custom dashboard for transaction Matching data with pivot view.,When trying to view the output, it gives random results. One time the valu…