Reporting
Discussion List
-
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… -
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…
-
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 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 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…
-
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
-
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 …
-
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
-
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…
-
FIELD_ID labels from ARM_HISTORYSummary: Does anyone know how to get the labels (names) for FIELD_ID from the ARM_HISTORY table? The reference doc for ARM_HISTORY mentions: “The field ID which states w… -
What ways can I report on match metrics during my purge process?Matched transactions can only be archived and purged if 100% of the transactions for that Match Type and Account ID are matched with an accounting date that is earlier t… -
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…
-
Is there a way to see the last generated or usage date of Custom Report IN ARCS?Summary: Client has a large number of custom reports created since the beginning and would like to know when was the last generated date of all the reports so that they …
-
Is there a report for Viewer/Commentator access?I would like to audit the Viewer and Commentator access that's been granted by Reconciliation and Profile without having to click into each. Is there a report or view th…
-
Links to previous Account Reconciliation webinars & trainingsHello everyone - see below for all the relevant previous EPM Account Reconciliation events into one place: Mar 2025 - Contains Matching Operator, User-defined Balance At…Tim Gaumont-Oracle 2.4K views 11 comments 10 points Most recent by AS2870-Oracle Account Reconciliation -
Subledger Integration not pulling the right ReportWe have 2 Integrations - GL & Sub-ledger and the period mapping has been added as shown in the screenshot for Aug FY25. We see that the GL balance is pulling the right r…
-
How to export workbench data for specific location in DM using epmautomate command?Summary: How to export workbench data for specific location in DM using epmautomate command. Content (please ensure you mask any confidential information): Version (incl…Saritha Mannnajirao 51 views 5 comments 0 points Most recent by Dave Jesky-Oracle Account Reconciliation
-
Power User has no access to add new Custom Dashboard created in ARCSWe created a couple of custom Dashboards and provided access to them in the Dashboard settings. We also added them to the Application Role to Manage Dashboards. Yet, the…
-
Need details on matched count and other details in balance summary report in TMSummary: Need details on matched count and other details below in balance summary report Number of records Number of Matched counts Number of unmatched counts Matched Am…Saritha Mannnajirao 61 views 5 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
There is any way to export amortization Schedule, exactly how it looks in front end in ARCSSummary: While I exported the amortization schedule from ARCS, In the exported file it is giving only the amortized amount, how to get exact amortization schedule which …SAI SAKETH KANCHERLA 11 views 1 comment 0 points Most recent by Dave Jesky-Oracle Account Reconciliation
-
ARCS reports are not populating prompt valuesSummary: OOTB reports such as Rejected Reconciliations with Comments Report is no longer populating the prompt values in the rendered report, that were entered while run…
-
How to reconcile data imported from ERP into ARCSHello, We import GL balances and Subledger Balances from Oracle fusion ERP into ARCS module. We are looking for a system generated report that would give us reconciliati…
-
Is it possible to have matched in Transit transactions details in custom report output?Can we configure a custom report in ARCS that gives output of matched in transit transactions.SAI SAKETH KANCHERLA 11 views 1 comment 0 points Most recent by Kedar Mahajan-Oracle Account Reconciliation
-
REST API - generates the report but doesn't emailSummary: The POST call completes successfully however doesn't send the report in the email address provided in the body. The Jobs console also shows that the report gene…