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
-
is there a way to load a specific profile/reconciliation and not reload all datawe often book journals well past when users start reconciling accounts. in the past this has caused the users to lose work as completed recs revert back to open status (… -
Feasibility for ARCS RC to Bulk upload of Balance Explanation and Exceptions (Source Adjustments)Hi We are looking to load Balance Explanation and Exceptions (Adjustment to Source system) through Data management in ARCS. Can you please let us know if this can be ach…
-
There is any epmautomate command to know the status of data load ?Summary: Is there is any epmautomate command to know the status of data load. We need a epmautomate command to add in script to know the status of data load . Content (p…
-
Many to Many rule does not function, please helpSummary: Many to Many rule does not function Content (please ensure you mask any confidential information): I tried the auto rules 1 to 1, 1 to many and many to 1. All f… -
How do we match open tolerance adjustments with the GL adjusting journal entries once booked?Summary: We have identified our unreconciled amount in a transaction-matching account is the result of tolerance adjustments that have been made in ARCS that need to be … -
Possible to use ARCS to reconcile statistical account balances between ERP and ASO reporting cubes?Summary: Can 'STAT' be added as a currency in ARCS for reconciling statistical account balance between the ERP Financial General Ledger and an ASO reporting cube? Conten… -
Can VPN be enabled to access the EPM Cloud URL for e.g. ARC(Account Reconciliation) applicationCustomer has a requirement to restrict the ARC application to certain IP addresses for security purposes. Is there a way to restrict the ARC application access to certai…
-
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…
-
How to send files as encrypted to EPM ARCS using epmautomate?Summary: How to send files as encrypted to EPM ARCS using epmautomate? Content (please ensure you mask any confidential information): We have a requirement to send 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 …
-
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…
-
Is any way can we load multiple data loads at same time for same period with different integrations?Summary: there is any way that we can load multiple data loads at the same time for same period with different integrations? The reason for asking is we have a business …
-
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…
-
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.
-
Create periods in bulk in under 3 minsOftentimes, you are having to create a lot of periods within EPM Cloud Account Reconciliation. With the help of Import Periods from file, you can create periods in bulk.… -
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…
-
Unmatched transactions email notificationsHi, The users wants to receive email notifications whenever there are variance between new unmatched transactions in POS x Bank (See image attached). We searched Oracle'…
-
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 …