Reporting
Discussion List
-
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…
-
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 11 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 81 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… -
How to get automatch rule status via REST APISummary: Need a way to know whether automatch for all records are successful. How to downloags logs of automatch rule Content (please ensure you mask any confidential in…
-
Queries to update the columns in ARCS Report - Reconciliation ComplianceWe need the queries to be updated to add additional columns - Preparer (Actual) and Reviewer 1 (Actual). Please assist. Thanks.
-
ARCS Reports ( Standard/ Custom) execution/ updates historyHi Experts. How to check the ARCS Reports ( Standard/ Custom ) execution / updates history , while checking jobs & Audit reports there is no field exists for the report …
-
Adding Fields to ARCS ReportsOne of our users was recently looking for aging transactions in ARCS and they found a report title "Transaction Aging Analysis" They wanted to add more fields to get mor…
-
how to hide rows when values in all columns are 0 in custom report in account reconciliation?I want to hide rows when values in all columns are zero. The condition I want to use is below:- to hide policies rows from the output that have both of the following cri…
-
How do you Report on group details in the Account Monitor ?Summary: Is there a subject area or SQL someone can share that can show us how to report on the data in the Account Monitor? I'm trying to get at the details for each gr… -
How to generate report with high volume in multiple excel tabsSummary: I am getting error "maximum limit reached" in ARCS report which has 1.6 M records in XLSX format. Is there a way we can split the records in multiple sheets / t…
-
EPM Automate Command to extract custom reportSummary: We are looking for a EPM automate which will be used to extract Custom Reports in the ARCS Content (please ensure you mask any confidential information): Versio…
-
Data Integration from ARCS to FCCSI'm investigating the feasibility of integrating data from ARCS to FCCS. Although we've confirmed the possibility of integration from FCCS to ARCS, our specific requirem…
-
Diff in RTF custom reportSummary: We are trying to difference in two columns in RTF but not getting desired result. Answer should be 0 Content (please ensure you mask any confidential informatio…
-
Customized report data integration error in ARCSSummary: We are uploading ERP GL clearing data using a customized report for the ARCS system for reconciliation purposes. When I upload and run the file, it shows 'compl… -
Custom Reports with multi currency Balances , amount to be split into individual rowSummary: There's one custom report we are trying to generate in which there's one column Currency Balance. Ideally we want only one currency and amount to be shown in on…
-
How to schedule custom report for Transaction Matching?Summary: Content (required): How to schedule custom reports for Transaction Matching? the custom report contains only matched transactions. Thanks Version (include the v…
-
Is there a way to prevent comments from displaying when generating the report binder?Summary: Client would like to keep comments out of the report binder. Content (required): Version (include the version you are using, if applicable): Code Snippet (add a…
-
ARCS Data Validation for Source System with ERP for SOX ControlSummary: ARCS Data Validation for Source System Balance with ERP for SOX Control Content (required): Hello Everyone, I would like to ask what best practices are you foll…Karan Varshney 71 views 3 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Seamlessly transfer Reconciled items from ARCS transaction matching to ERPSummary Possible ways of transferring reconciled items from ARCS transaction matching to ERP on daily basis at prompt timeContent Hi Team Can ARCS manage to work as the …
-
How to add security clause for TM custom reports created on Match Type View (TM_<MATCH_TYPE_ID>)Summary: Security clause for TM reports created on match type view Content (required): Dear Team, Need guidence on adding security clause in TM custom report preapared o…
-
Is there a report that shows which recs were auto submitted/auto approved in a certain period?Summary: We are trying to see how many and which specific reconciliations typically get auto submitted each month. Content (required): I have ran the reconciliation audi…