Reporting
Discussion List
-
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 161 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 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 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 all previous Account Reconciliation webinars & trainingsHello everyone - wanted to get all the previous events into one place for you. Here they are: Feb 2025 - New features with Match Rules, Transaction Search, and Unmatched…Tim Gaumont-Oracle 2K views 11 comments 9 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 42 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…Wilson Chelakadan 3 views 1 comment 0 points Most recent by Ryan Lunde-Oracle 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 …
-
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 15 views 1 comment 0 points Most recent by Dave Jesky-Oracle Account Reconciliation
-
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…
-
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 12 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…
-
Is there a debugging instance available to connect to Database to run SQL queries to test?Summary: I have a custom report which now is taking over 6 minutes to run and generate the report which earlier used to take around 3 minutes. The technical team wants t…
-
ARCS tables/views for custom reportsSummary: ARCS tables/views for custom reports Content (please ensure you mask any confidential information): Hello community, I have been struggling to find below column…
-
Parameter Query is not available in ReportsSummary: Parameter query is not available in Reports Content (please ensure you mask any confidential information): I created a query using the type: Parameter Query. It…
-
To add header and trailer in Basic CSVSummary: Hello, our custom report in ARCS contains more than 1 million records and as per ARCS admin guide CSV formatted is only meant to support 10k records. Basic CSV …
-
Project subledger - tables or views for distribution linksSummary: I am looking to construct queries to pull subledger detail for Projects Content (please ensure you mask any confidential information): I am looking to construct…Robert of STAU 49 views 2 comments 0 points Most recent by Robert of STAU General Ledger & Intercompany
-
Except reconciliations compliance we are not able to access other data component in ARCS-SmartviewWe are able to import unexplained balances data adjustments through reconciliations compliance. However, we are unable to access other data components such as reports, m…
-
Duplicate responses to mandatory question when submitting a reconciliation.Hi Folks, I created a mandatory question to track how long it takes to preparer a reconciliation to give Leadership visibility on man hours. I have been running into an …
-
Is it possible to separate Amount column and Currency column in Transaction Tab under ReconciliationSummary: In ARCS Transaction Tab under Reconciliation card, usually, we see that the Amount and the Currency code are in a single column. But we want to segregate the Am…Md Munibur Rahman 33 views 1 comment 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
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…Arjunayan 54 views 4 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Account Reconciliation