Reporting
Discussion List
-
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… -
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… -
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…
-
Is Oracle BI Publisher is free / Licensed software ?Content Hi All, As we all know Creating custom report templates in ARCS will be done in Microsoft Word with Oracle BI Publisher Desktop installed in it. Do we required t… -
How can I email custom reports from Oracle ARCS with Oracle Analytics/BI Publisher?Summary: We need to create about 10 custom reports with data in Oracle ARCS and then email the reports to hundreds of contacts daily. How can this be done within Oracle …
-
Total duration attribute in ARCs is not excluding weekend and holidaysSummary:Total duration attribute in ARCs is not excluding weekend and holidays Please suggest how can we exclude holidays and weekend from total duration in attribute or…Neha Talati-267028 33 views 5 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
What is the best way to automate monitoring data load process details from Data Integration?We have a large number of data load jobs running each day, and we need a more efficient way to monitor the success of these jobs than scrolling through the Process Detai…
-
Amortization Schedule Report for PrepaidsSummary: In order to reconcile the prepaid accounts, we need a schedule of system generated multiperiod accounting amortization. Create multiperiod accounting generates …Marcelo Cardoso 102 views 3 comments 0 points Most recent by CA Nirmal Choudhary Account Reconciliation
-
Report ConfigurationSummary Invalid Query attached to the ReportContent Hi Team, I am trying a build a custom report in ARCS. The query is working fine in SQL. I have even validated it in R…Nilakshi Sarma-194684 96 views 4 comments 1 point Most recent by Kunal Baikar Account Reconciliation
-
Links to previous Account Reconciliation webinars & trainingsHello everyone - see below for all the relevant previous EPM Account Reconciliation events into one place: May 2025 - Fusion ERP Integration to User-defined Balance Attr…Tim Gaumont-Oracle 3.5K views 12 comments 11 points Most recent by JAGADISWAR-Oracle Account Reconciliation -
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?Mayank97167 22 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
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…Mayank97167 45 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
How to Join Between Project Accounting Sub ledger and GL Sub Ledger Journal LinesSummary: We would like to know the most optimal way to join Project Accounting Sub ledger and GL Journal Lines. We understand we can join either by events or by distribu…
-
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…Courtney Van Winkle 21 views 4 comments 0 points Most recent by Courtney Van Winkle Account Reconciliation
-
Report containing all unmatched transactions by period.Summary: We have a need of a report of all unmatched transactions over 90 days by period. This is a key control in our organization. We could use the Balance Report Tran…
-
Is there any reporting option in ARCS that we can run for different periods?I want to view the reconciliation status of my reconciliations for different periods. Like the matched and unmatched transaction in both sides. Is there any option we ca…
-
Multiple Period in Report Columns in ARCS ReportSummary: We have business requirement to get net differences in ARCS Custom Report as separate columns along with other details. Example if user gives period range in pa…
-
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…
-
ARCS- Amortization Schedule Report for all companiesSummary Extraction of Amortization schedule report from ARCSContent Can we extract Amortization Schedule Report for all the companies? Or do we have any pre-built report…
-
Reconciliation Comments in single line in report.Summary: We are trying to customize reconciliation comments report based on business requirement, in that we want to have each row for each reconciliation ID and in case…
-
Is it possible to add closing balance column in the index page of Report binder.Is it possible to add closing balance column in the index page of Report binder.
-
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…
-
ARCS - How to Build a Report on Matching TransactionsIn ARCS, I loaded transactions in Matching Transactions : I thought that a report would be the best way to perform data quality controls. So I tried to build a report sh…
-
Multiple values for attachment count column in Reconciliaton Manager (ARM)I am showing multiple values (0, 1, 2, and above) for the attachment count column for a specific period. If I am trying to get the total number of attachments, should I …Patrick Pontillas 21 views 1 comment 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
Oracle ARCS custom report: how to schedule report execution and routing to an external folder?In Oracle ARCS how to schedule report execution and routing it to an external folder?
-
Error on extracting data from Fusion ERP into ARCSSummary: Hi Team, ERP Finance team had implemented a new ledger for AED currency in Apr-24. When we are trying to extract data into ARCS from the ERP seeded report "Paya…
-
Issue in artifact level migration for Transaction matching custom reportsSummary: Transaction Matching custom report query Issue is artifact level migration for Transaction matching custom reports is not working when we migrate artifact level…Neha Talati-267028 21 views 3 comments 0 points Most recent by Neha Talati-267028 Account Reconciliation
-
Is there any option available to export Custom dashboard through ARCS in a PDF format?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
ARCS Nov'24 patch feature - "Support for Calculated Balance Attributes in Custom Report Queries"Support for Calculated Balance Attributes in Custom Report Queries: Service Administrators can now select the following calculated balance attributes when creating custo…Srikanth_Sudha 163 views 12 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation