Reporting
Discussion List
-
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 139 views 10 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation -
Links to all previous Account Reconciliation webinars & trainingsHello everyone - wanted to get all the previous events into one place for you. Here they are: Jun 2024 - BAI Bank Statement Balancing, Daily Period Tips, Object Storage …Tim Gaumont-Oracle 1.7K views 11 comments 8 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 46 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 2 views 1 comment 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… -
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 63 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 12 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 11 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 46 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 -
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 31 views 4 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Account Reconciliation
-
Is Oracle BI Publisher is free / Licensed software ?Content Hi All, As we all know Creating custom report templates in ARCS will be done in Microsoft Word with Oracle BI Publisher Desktop installed in it. Do we required t… -
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…