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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Account Reconciliation
Discussion List
-
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…
-
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 …