Account reconciliations
Discussion List
-
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… -
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 …
-
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…Gert Hvarregaard 41 views 7 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
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…
-
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…
-
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 …Gert Hvarregaard 31 views 7 comments 0 points Most recent by Gert Hvarregaard Account Reconciliation
-
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 …
-
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 …Sivakumar Chowday K 38 views 4 comments 0 points Most recent by Sivakumar Chowday K Account Reconciliation
-
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…Julie Belurier 22 views 1 comment 0 points Most recent by Lakshmi Narayana Metla-Oracle Account Reconciliation
-
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…
-
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…HariKetha 31 views 2 comments 0 points Most recent by Lakshmi Narayana Metla-Oracle Account Reconciliation
-
How to Add Roles like PowerUser, Viewer, etc. to a New UserSummary: We have a new employee that needed to be setup as a preparer in ARC's. I went to Oracle Cloud, Default Domain, clicked the button to Create User. As I created t…
-
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…
-
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…
-
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…Bill Stevens - 1234 32 views 4 comments 0 points Most recent by Dave Jesky-Oracle Account Reconciliation
-
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…Gert Hvarregaard 25 views 1 comment 0 points Most recent by RahulBansal-Oracle Account Reconciliation