Reporting
Discussion List
-
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 83 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…
-
Activity Summary emails are no longer being sentSummary: Activity Summary emails are no longer being sent consistently to our users and this has been happening since (we believe) sometime in October of 2023. Users use…
-
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 76 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…
-
[OCI Gen2 Migration Issue]. ARCS Default Preparer Attribute Has User ID Invalid During CloningSummary: [OCI Gen2 Migration Issue]. ARCS Default Preparer Attribute Has User ID Invalid During Cloning from Classic Content (required): [OCI Gen2 Migration Issue]. ARCS… -
Custom Report needs to be placed directly to the Data ManagementSummary: Custom Report needs to be placed directly to the Data Management Content (required): I would like to load the balances into FCCS for some validations against lo…
-
Is there an option to choose select users when publishing a list?Summary: I have a specific group of users looking for a custom view to be created in reconciliations. I know the Admin can create a list and publish it for end users use…Christina Steward 61 views 4 comments 0 points Most recent by Christina Steward Account Reconciliation -
Valid quereis are not validated on my machineSummary: Content (required): Hi everyone, When validating some queries, the query validator screen closes, the browser page refreshes and the validation does not complet…RezaNS 31 views 1 comment 0 points Most recent by Pat Malay - Oracle EPM-Oracle Account Reconciliation
-
Anyone has build the custom report for traditional Bank Reconciliation in ARCS.Summary: ARCS Custom Report for Bank Reconciliation Content (required): Anyone has build the custom report for traditional Bank Reconciliation in ARCS. Below is the form…