Account Reconciliation
Discussion List
-
Role provision report returning date for provisioningSummary: The requirement is if the role has been provisioned in EPM ARCS application, e.g. "Data Loads-Manage" then where the "provision date" and "provisioned by" data … -
Invalid period mappingWhen I try to import balances using "Periods" I get the following error message: "Invalid period mapping. Make sure the period is defined in Data Management Period Mappi…
-
Encryption EPM Automate/ARCSSummary: How does EPM Automate and ARCS handle encrpted files? 🔒️ Content (required): We have transaction matching files coming in from a cloud service into an SFTP. To … -
could we connect PowerBI directly to Oracle DB via "DirectQuery" to help alleviate some ETL concern?Summary: One of the initial activities involves compiling and dashboarding ARCS data to analyze and present particular findings utilizing Power BI. working with Reconcil…
-
When loading Reconciliation transactions we need to filter the data loadedSummary: The load file contain transactions that should not be loaded to ARCS. In the file I have an attribute containing the Status with values: Approved, Canceled or A…
-
Can we create a group containing service admin roles and remove the Prepare and approver accessSummary: Is there any possible way to create access group containing service admin role and remove the Reconciliation Prepare and Approver access.
-
Export Profiles using EPMAutomate & Profile folder path in the Snapshot fileSummary: Hi All. How to export profiles using EPMAutomate ? Is it possible to export profiles? What is the profiles data location folder in the Artifact Snapshot files ?…
-
Adding attachments to "Supported Balances" section instead of Overall Reconciliation SectionSummary: Do attachments in the "Supported Balances" section of a reconciliation get deleted at any point after the period has closed? Are there any time limitations for …
-
Does ARCS support Turkish and Arabic languagesSummary: Hi team, Does ARCS support Turkish and Arabic languages? Content (please ensure you mask any confidential information): Version (include the version you are usi…
-
Quantify low vs high volume of transactions for reconciliation compliance?Summary: In making the business case for compliance vs transaction matching, is there a rule of thumb for transaction volume? The docs I've read mention low-volume (comp…
-
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… -
Restricting access to attachmentsSummary: Apart from being able to download the reconcilaitions without attachments using generate report binder (which is great), is there a way to restrict a user (audi…
-
Can we create a custom report based on the "Questions" in reconciliation?Can we create a custom report based on the "Questions" in reconciliation?
-
Is there a way to have more than one "Service Time Zone" based on different users in ARCSSummary: Hi ARC Experts, while configuring "Date and Time" under configuration settings there is an option for setting the "Service Time Zone", is there a way to set dif…
-
Merge option for data load in ARCSSummary: Has anyone tried the newly released MERGE option for loading data into ARCS? Content (required): I am trying to use this functionality but it's not working for … -
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…
-
Bring group attributes into Data Exchange to use in mappings?Hi, We are wondering if it is possible to bring fields from group attributes into Data Exchange, and populate values for those fields based on the value loaded for the c…
-
ARCS custom dashboardsIs there an option to add in calculated fields and Andon's to the dashboards in ARCS custom section? Currently we are performing ARCS metrics via excel and would like to…
-
In ARCS we have the Account Analyze format enabling users to explain the end balance of an account.I have a customer who wants the Balance explanation to be copied to the next period when opening reconciliations, is that possible? If an account balance is $ 2.000.000 …
-
ARCS - Build Report on TransactionsSummary: In ARCS, I'd like to build a report on the transactions and display the matched transactions next to each other (based on the match ID). Content (please ensure …
-
Need Oracle SQL query to pull Project Subledger transactionHi All, We need a query to pull Project Subledger transaction by Accounts. Please provide us some leads for the same if the query is not available. This is needed as par…
-
How to bring Total / percentage of reconciliation counts based on the attribute?Summary: We are trying to simulate the custom dashboard. It defines the number of Reconciliations spot check completed/Failed against each reviewer. We were able to get …
-
How do you turn on audit for data exchange in ARCS?Summary: Is it possible to turn on audit for data exchange in ARCS? Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Can we post adjustments back to Cash Management from ARCS Transaction MatchingHi All, Can we Post adjustments back to Cash Management from ARCS Transaction Matching. Thanks in advance..!!!
-
SOD configurations verificationSummary: To verify SOD, proof must be provided that the test and production instances follow the same configurations. Preparer and reviewer can not be same for the same …
-
Data file download of >1GB using EPM REST API for Oracle ARCSWe have a requirement to extract Transaction Matching match type tables in ARCS and load it to a warehouse. The anticipated data volume is huge and downloading the extra…
-
Locking a period for importing of dataSummary: Hi We have had a few issues where we in mistake loaded data to the incorrect period. We would like to be able to lock a period for importing data (data exchange… -
ARCS - Is it possible to match transactions with opposite amounts?Summary: In ARCS, we load intercompany transactions. The transactions have positive amounts in the source system and the transactions have negative amounts in the subsys…
-
Intercompany Bulk submissionsSummary: Hi Team, If all intercompany accounts in a company XX are in one bulk reconciliation, customer will submit the bulk reconciliation in one go which save more tim…
-
Available fields when using Transaction Matching formatSummary: Hi everyone. We implemented transaction matching and thus needed to update our account rec format. When using the "TX matching" format, there does not appear to…