Reporting
Discussion List
-
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 55 views 5 comments 0 points Most recent by Dave Jesky-Oracle Account Reconciliation
-
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 63 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 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 67 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 31 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…
-
Unable to change time zone in "Reconciliation Audit Trail" reportHi ARCS Experts, I am trying to generate the report "Reconciliation Audit Trail", where the time zone is showing as UTC, but I want to change it to "ET", I tried to chan…Shimona Gupta 12 views 1 comment 0 points Most recent by Kiran Nagaraja-Support-Oracle Account Reconciliation
-
Is there a table we could use to build a report for all Unexplained Differences?Summary: Is there a table we could use to build a report for all Unexplained Differences? Content (please ensure you mask any confidential information): After reviewing …
-
ARCS - How to delete job page historyHello All, I noticed a strange behavior of the ARCS application when the entire snapshot is migrated from one ARCS environment to another. Since the profiled users are d…
-
User able to extract Custom report other then His/her accessSummary: We have created a custom report and we have given access to the users to extract those report. The user should be able to extract the accounts to which they are…
-
What methods are available to extract ARC data tables?Summary: Are there any methods, outside of custom reporting, to extract data from the tables within ARC? Content (required): Our business users have a desire to be able …Braxton Sowell 96 views 6 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Need table with Period and supported frequencies for RC report buildSummary: Dear Team, I am looking for table with Period name and supported frequencies for RC report development. Content (please ensure you mask any confidential informa… -
Matched In-Transit ReportsSummary: Content (required): We are currently building a report to pull Unmatched Supported and Matched In-Transit transactions for a specific period. During our testing… -
Can you create a custom report binder or modify how the report binder is generated?Summary: We have a client who is requesting to modify what is generated in the report binder. They want to exclude some information that may not be necessary for their r…Performance Architects 11 views 1 comment 0 points Most recent by Dave Jesky-Oracle Account Reconciliation -
Multiple parameter selection option as radio button in ARCS ReportsSummary: While creating custom reports in ARCS, can the query be updated to include parameter which can be executed for only few set of items from the parameter drop dow…