Reporting
Discussion List
-
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 22 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 161 views 12 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
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… -
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…
-
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 53 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
-
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 14 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 55 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 -
BI publisher is free for ERP Fusion implementation?Summary: BI publisher is free for ERP Fusion implementation? We are implementing a fusion project with cutom reports to be built. In case we need to install the BI publi…
-
Matched In-Transit in Custom ReportSummary: I am trying to build a custom report for pulling status information similar as Balance Report Transactions. In the first column of this system report, it contai…