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
-
Amortization Schedule Report for PrepaidsSummary: In order to reconcile the prepaid accounts, we need a schedule of system generated multiperiod accounting amortization. Create multiperiod accounting generates …
-
How to make a hyperlink clickable in unmatched/ matched transactionsSummary: Hi Team, We have configured the Primary Ledger (PL) Drill link for a match type (Bank to GL), where the hyperlink is provided only on the GL Side for the transa…
-
Query on Balance Comparison and Transaction MatchingSummary: Query on Balance Comparison and Transaction Matching Content (please ensure you mask any confidential information): In what business scenario for a profile with…
-
Report ConfigurationSummary Invalid Query attached to the ReportContent Hi Team, I am trying a build a custom report in ARCS. The query is working fine in SQL. I have even validated it in R…
-
Moved: How to set up email notify to receive announcement monthly updates patch applications for AR…This discussion has been moved.
-
How to Restrict Manual Account Entry in Adjustment/Write-off Match Type in ARCS?In EPM ARCS, when we manually match the transactions with variance a write off/adjustments will be created , users currently have the ability to manually enter accounts …
-
In Account reconciliation can journals posted as adjustments can be pushed back to source system?Summary: We know that journals can be posted in ARCS but can those journal posted in form of adjustments in ARCS can be auto write back or pushed back directly to source…
-
Moved: When importing an ARCS snapshot, 18000: Invalid application name - Financial Close ManagementThis discussion has been moved.
-
ARCS Amortization beginning functional amount?In ARCS, our reconciliations have entered, functional and reporting currencies. When creating an amortization schedule, how do you modify the beginning balances for Func…
-
Why is calculated attribute not filtering properly?We created a calculated attribute for % Variance that's used for our Variance Analysis recs. The attribute is calculating correctly, however, the filtering and rules tha…
-
Need to know on ARCS, can we connect use file other then CSV whist we're using Custom Integration?When we do custom Integration, we use file which is in CSV format by running the report as ESS job. Is there a way where we can integrate the file as per the output whic…
-
Pull Peoplesoft Balances hourly into ARCS for reconciliationSummary: We have a requirement from business where we have to pull Peoplesoft Balances every hour for reconciliation specially on BD3. Below is the process that we are f…
-
Transaction Matching Like Matching Conditions for Text Strings in Oracle ARCSSummary: Is there a way to map Text Strings for Matching Rules in Oracle ARCS for Transaction Matching. For Eg including Contains or Starts With in matching rules? Conte…
-
Ability to define a custom Bank Statement Import Format in ARCS (csv/txt file) ?Summary: Hello For a french customer, we are going to use ARCS to match Bank Statement Lines against GL Lines. Regarding Bank Statement Lines, our bank statements are no…
-
Question on adding auto-certification rules and still being able to add supportSummary: We would like to add auto-certification rules to our balance comparison format reconciliations, but still be able to upload subledger reports as support. Conten…
-
Create Folder permissionHello, we have users in our instance, this users should can create folders in the inbox of data exchange. Which permission we can add to enable create folders? They aren…
-
Business wants the ERP GL Journals import latest in ARCS applicationHello Everyone, In the current configuration the data load runs daily once from ERP (GL Journals) to ARCS through OIC job run, Business wants the ERP GL Journals import …
-
Is there a limit on the volume of balances and transactions that can be imported into ARCS?Summary: Is there a limit on the volume of balances and transactions that can be imported into ARCS? Content (please ensure you mask any confidential information): Hello…
-
P13 adjustment data load Mode in ARCSSummary: Hi, We are using Oracle E-Business Suite (EBS) as our source system, which follows a P13 calendar. We are attempting to load P13 adjustment data (ending balance…
-
Transaction Matching Adjustments in Rec ComplianceSummary: How to see adjustments created in TM (dure to Tolerance) in RC Content (please ensure you mask any confidential information): Hi, For Account analysis with Tran…
-
Smartview for ARCS reportsHello ARCS Experts, Currently Importing Transactions Directly From Excel Using the Smart View Extension for Reconciliation Compliance , however we would like to create a…
-
How to exclude specific members (subset) from selection in Oracle GL direct integration?Currently, we use the ILvl0Descendants function to retrieve all values from the company hierarchy. However, we now need to exclude specific records from being imported i…
-
Can we upload comments as well when bulk uploading balance explanations in ARCS?Instead of manually uploading attachments or commenting on each line can we add comments while importing balance explanation in EPM ARCS?
-
ARCS Transaction Matching data load errorTrying to load GL transaction lines from source for transaction matching only profile. From the data exchange it says failed with error. however in the job section data …
-
how can I get SAST report for oracle cloud ARCS/OIC application?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Debit & Credit Amounts not populating for an EJ created for amortized balance explanationSummary: I'm encountering an issue when creating an Enterprise Journal from a Balance Explanation that is an amortized entry—specifically, the debit and credit amounts a…
-
is Summary Rec the way to identify not mapped subsegmentSummary: I am thinking setup Summary Rec entity-account under entity-account, there will be subsegment named e.g. cost center if one cost center(child reconciliation) is…
-
EPM ARCS data maskingDoes oracle EPM ARCS application support data masking? We are trying to find solution that can mask sensitive data in non-production environments. - this link calls out …
-
Data load failed due to invalid sub-segment values in the source data?We have an integration from SAP to ARCS which was working fine from the past few years until the 16th of May. The data format, the integration setup has not been modifie…
-
Oracle Cloud ERP subledger balance auto feed to ARCSSummary: Is there a way to automate the feed from Oracle Cloud ERP subledgers AR, AP, Fixed Assets into ARCS in 2023? Content (required): We are currently manually enter…