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
-
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…
-
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…
-
Is there a way to turn off case sensitivity in transaction matching?Summary: We have some transations that do not automatically match due to the members having different cases (i.e. one starts with a capital letter the other doesn't) in …
-
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…
-
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…
-
ARCS audit logs for user access evidenceHi, Regarding the internal audit for ARCS user access provisioning evidence, is there a way to obtain information about the exact date and time when a user was granted a…
-
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…
-
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…
-
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…
-
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…
-
ARCS - Late Category Not Working as ExpectedSummary: In ARCS, we track the late reconciliations. We track what's late for the preparer, what's late for the reviewer and what's late (in global). Content (please ens…
-
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…
-
Passing Period to On-prem Oracle EBS DB using EPM On-Prem Agent from ARCSSummary: Passing Period to On-prem Oracle EBS DB using EPM On-Prem Agent from ARCS Content (required) We plan on using Agent as shown in https://us.v-cdn.net/6034893/upl…
-
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 filter reopened reconciliations in ARCSA history of a reconciliation is clearly showing that EPM_Batch scipt reopened reconciliation due to balance change. But we need an attribute that can show list of reope…
-
Possibility of the transactions upload by the user from the import transaction in the Job sectionSummary To make the user to upload the transactions in the import transactions area, when one or two transactions needs modification.Content In the Transaction matching … -
Drilling down to BIP report up to Journal EntrySummary: We were able to load Accounts Payable subledger ending balances from ERP to ARCS thru BIP report. We were also successful in loading GL balances. We tried to us…
-
Can we do Drilling down to BIP Inventory report from ARCS Reconciliations ?Can we do Drilling down to BIP Inventory report from ARCS Reconciliations ? Really appreciate your quick response...
-
Can we control access of ARCS Standard Dashboards?Summary Requirement : To limit users from accessing standard dashboards even though they fall under the workflow of the reconciliation Content (please ensure you mask an…
-
Group reconciliation not showing the "Group Detail" tabSummary: All the configs seem to be correct and I can see the data in the detailed balances tab in the reconciliations page but I am unable to see the details in the rec… -
Profiles and Reconciliation Creation for STAT vs GAAP AccountsSummary: Our ledgers are setup as Primary + GAAP Adjustments and Primary + STAT Adjustments. We currently have both GAAP and STAT Profiles and reconciliations in ARCS, h…
-
Any scheduling system within arcs for input vacation dates and set as unavailable automaticallyDo we have some sort of scheduling system within arcs where we could input our vacation dates and have system set us to unavailable for those periods. Sometimes when peo…