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
-
EPM Automate command to generate audit reportSummary EPM Automate command to generate audit report in ARCSContent Is there any EPM Automate command in ARCS that we can use to automatically download the audit report…
-
Match Types in Transaction MatchingContent Hi All, I have a general question about the way transaction matching rule types work. Currently, I have the following rule types configured in this order: Many t…
-
NZP for Transaction Matching Import FormatContent Hi All, Has anyone used NZP for a transaction matching import format? My client is missing 46,000 rows in their transaction matching reconciliation because it is…
-
P13 Setup in ARCS - Our Customer has year end adjustments in Period 13(Oracle Fusion Financials) DoContent Hello, P13 Setup in ARCS - Our Customer has year-end adjustments in Period 13(Oracle Fusion Financials) and want to pull over data into ARCS for reconciliation. …
-
Copy forward Prior Ending balance($Total) for Account Analysis recons to Current PeriodContent Hello, I see there is an option to copy forward transaction for Account Analysis recon from the Prior period but it does by an individual transaction. Is there a…
-
Prior Quarter balance % ChangeContent I've created a calculated attribute for Prior Period balance % Change which takes (current period source system balance - prior period source system balance)/ pr…
-
Getting P13 ( CFP ) period data in ARCSSummary Getting P13 ( CFP ) period data in ARCSContent Hi All, I have a query : In ERP I have one period as P13. ( December 31) I want to import P13 in arcs. Solution : …
-
Unexplained Difference Exist , however ARCS shows You have no unexplained differencesSummary Unexplained Difference Exist , however ARCS shows You have no unexplained differencesContent Hi Everyone, Even though an un-explained difference exists the syste…
-
New Cloning FunctionalityContent Hi Team, I tried cloning the prod environment to test using the new cloning functionality but it got failed with message that application version mismatch. So is…
-
Rule to pull forward Balance Explanations based on end dateContent We would like to create a rule that pulls forward all balance explanations if the end date is AFTER the period start date or reconciliation start date. Is there …
-
Auto Approve and Auto Submission Rules in Variance Analysis formatSummary Close out Reconciliations when the difference between Current period balance and Previous period balance falls within a particular rangeContent Hi All, We have s…
-
Manually Enter Subledger DetailsContent Hi All, My client has Balance Comparison reconciliations that are grouped with a subledger balance that is entered manually. They would like to manually enter mu…
-
Passing Adjustment should not impact the Unexplained differenceSummary Passing Adjustment should not impact the Unexplained differenceContent Hi All, I have a requirement in the Reconciliation Compliance module. Recon has 1.Ending b…
-
Drillback not working properly and contains unnecessary rows of balancesContent I am setting up a direct integration with the Oracle ERP Fusion GL to ARCS. The drillback on balances on the Summary tab of the reconciliation displays the Java …
-
Calculated DatesSummary DATE_DIFF can use 'NOW' or 'TODAY' but can DATE?Content Has anyone had luck creating a calculated attribute in transaction matching using DATE? I'm trying to get…
-
The cloud service you are trying to access has controlled access.Summary the cloud service you are trying to access has controlled access.Content Hi All, I am getting issue of The cloud service you are trying to access has controlled …
-
Select Columns - BalancesContent Guys, we need to add the column “Current Period Balance” on the reconciliation screen so that the user has visibility of the loaded balance when the reconciliati…
-
Period Activity Added with Ending Balance in ARCSSummary Period Activity Added with Ending Balance in ARCSContent Hi All, I am pulling Period Activity and Ending Balance in ARCS profile (Account analysis). But Instead …
-
Loading Transactions to Prior Month during close - Transaction MatchingContent Hi All, I have a client that is utilizing daily periods to reconcile their loan level balances using Balance comparison with Transaction Matching. They will be c…
-
Payable Transaction data load failureSummary Payables Transaction errorContent I configured "Payables Transaction" as a target, when I run a DLR I get this error which comes after the parameters are passed,…
-
Intercompany Transaction MatchingContent Hi All, I am currently implementing intercompany transaction matching at a client and have a question on matching rules. We have it set up as a single source mat…
-
Possible performance issue while importing Source and Sub System files in to EPM-ARCSSummary Possible performance issue while importing Source and Sub System files in to EPM-ARCSContent Possible performance issue while importing Source and Sub System fil…
-
Data Management - NZP Values from ERP - what accounts are included? Any account that has ever had dSummary What 0 value is ERP including during a pull from ERP, any account that ever had data? All accounts?Content I have a direct connect set to Oracle ERP. I have disa…
-
ARCS - Need help with Importing Transaction fields from SharepointSummary We would like to know how we can import transaction files from Sharepoint for our Account ReconciliationContent Recently we started to store our files in Sharepo…
-
Data Source without Reconciliation ID columnContent Hi Team, In transaction matching we have data source in which there is no such column which can be used as Reconciliation ID. Is there any work around through wh…
-
TM: Prevent submission of reconciliation when Suggested Matches have not been clearedSummary TM: Prevent submission of reconciliation when Suggested Matches have not been clearedContent Hi there, Is there a way to prevent a reconciliation from being subm…
-
Passing Parameters to a custom BI report through Data ManagementContent Hi All, For transaction matching, we are using a custom BI report to load one day of transactions at a time. We have monthly periods configured but want to load …
-
How to change the date format in ARCSSummary How to change the date format in ARCSContent Hi All, We are using Data Management to connect to "GL/Fusion" to bring the "PayablBalanceReport" and load into ARCS…
-
Auto Reconciliation RulesContent Is there any method available in ARCS to change the blank values in reconciliation to Zero value or any method available to auto reconcile or auto submit when th…
-
Best RPA tool for Oracle EPMContent Please help me with the best Robotic Process Automation (RPA) tool that supports for Oracle EPM cloud. Which is also preferred by Oracle. Thanks, Vasanth