To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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 … -
Is there any automation for support/Un support transactions in ARCS transact matchingSummary: The requirement is to automatically support transaction with age more than 60 days. Content (please ensure you mask any confidential information): Version (incl…
-
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…
-
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…
-
Can we create a custom report based on the "Questions" in reconciliation?Can we create a custom report based on the "Questions" in reconciliation?
-
Drill Down from ARCS to GL gives Error "Cannot perform cube view operation. Essbase Error(1260046):Build an integration between ERP GL and ARCS using Data exchange. The balances are coming over without issues but when using drill through to source, it is giving an err…
-
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…
-
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…
-
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 …
-
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…
-
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 …
-
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 …
-
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…
-
Drill Through on Ending Balance Fails with "Could Not Find Period key for given parameters"Summary: After loading data to an application in ARCS, I'm getting an error when I drill on the Ending Balance in Reconciliation after the load, screenshot below. I have…
-
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…
-
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… -
Ability to hide certain match process within a match type from showing in a TM account?We are wondering if there is a solution to hide specific match processes from appearing when looking at matching accounts. For example, if several accounts share the sam…
-
Send email notification to the Preparer when a reconciliation is Rejected ONLY by Reviewer.Summary: When a reviewer rejects a reconciliation, responsibility returns to the preparer, and the status changes to Open with Preparer. Reviewers should add a comment t…
-
Why is Reviewer and Frequence not showing on Profile in ARCSSummary: I am setting up ARCS from an empty system and has defined basic system setup and Match Types and formats. Now I am defining Profiles but when going to the Workf…
-
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…
-
ARCS Transaction MatchingIn ARCS Transaction Matching, what would stop the matching process from picking the transactions with the closest dates if all of the other required attributes have been…
-
can we use same ATTR1 data table column name in two target application (TM)Summary: when we use same ATTR1 in two target application. Getting error "ORA-00904: "ATTR1X": invalid identifier" . Content (please ensure you mask any confidential inf…
-
Conversion from monthly periods to daily periodsWe have an application enabled for both Reconciliation Compliance and Transaction Matching. We are currently using monthly periods where we are loading BAI transactions …
-
Moved: Unmatched accrual balances infolet on receipt accounting dashboard - No data availableThis discussion has been moved.
-
How to handle void payments from Bank file which are coming from BAISummary: From BAI receiving 252 reversal transactions(Void payment transaction) like 16,252,30,,,,REVERSAL 062-770 001016225 XXXXXX 533816 2024-04-02 207831502 88,005 NO…
-
Profile Template from NetSUiteSummary: We would like to update the NSAR profile template saved search to add additional segments. Client needs more than just sub and account. We need to add additiona…
-
ERROR: Field Is Restricted when using NetSuite with DMSummary: Hi, We are trying to load from a saved search in NetSuite to Data Management for NSAR. We created a custom text field for the Location to retun None if the fiel…