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
-
what is the best way to find out unexplained balanceSummary: we are using Balance comparison with transaction matching (Recon between Ledger to Bank) at month end , Rec compliance module shows up unexplained balance there… -
ARCS direct integration to BI publishSummary: Need to create direct integration to set up a data flow from ARCS to BI publisher Content (please ensure you mask any confidential information): Client is doing…
-
How do you overwrite a system translated balance in ARCS?For testing purposes, we are trying to import reporting balances (USD), from a different system, into ARCS. We are importing balances for individual and summary reconcil…
-
Can we use OTBI report in ARCS data integration to load balanceWe can load data to ARCS using BIP reports. Can we also use OTBI report for the same.
-
Smart view import for power user roleSummary: Does SmartView support power users who are also named preparers on reconciliations to upload balance explanations/adjustments Content (please ensure you mask an…
-
Has anyone found the Act As This Role preference for Service Administrators?Summary: According to this article https://docs.oracle.com/en/cloud/saas/readiness/epm/2025/epm-mar25/25mar-epm-wn-f37500.htm as of the March 2025 update in ARCS I shoul… -
Role for workbench accessHI Team, Is there a role which can be given to user for only workbench access, they shouldn't run the integration? Kindly help me with the above query
-
ARCS Data Load error after May2025 Patch"Data load failed due to invalid sub-segment values in the source data. Ensure the sub-segments do not contain the dash character (-)." After applying May 2025 patch, ou…
-
How to add more than 63 columns for ARCS Report Template.rtf fileSummary: When creating a report in ARCS I am unable to add more than 63 columns to the report template Word .rtf BI publisher file. The report is used to feed to a power…
-
How to generate report with high volume where it says report exceeded maximum limitSummary: We are trying to generate a report with transactions imported during last 35 days for a match type. We are getting an error saying Report exceeded maximum limit…
-
Bulk delete prior month adjustments posted in EPM ARCSSummary: Can we bulk delete prior period adjustments posted in EPM ARCS? If so could you please help us with this Content (please ensure you mask any confidential inform…
-
Creating AdjustmentsSummary: How to include the Comments and Attachments from the Adjustment Type to the Matching→Transactions. The comments and attachments from the adjustment form is not …
-
Account Reconciliation - Bypass Format Rules for a profileHi Team, I have a requirement to bypass few of the format level rule in a Profile. Can we not execute few format level rule for a particular profile?
-
Migrate ARCS reconciliation and Transaction matching in a single applicationSummary: How to migrate ARCS Recon Compiliance and Transactions Matching into single application during enterprise edition? Is it possible? please let us know the proces…
-
ARCS Bank Statement Verification — Does it support previous day closing=current day opening check?Hi all, We are reviewing the Bank Statement Verification feature in ARCS Data Integration (introduced in 2024 for BAI files). Based on the documentation, it appears the …
-
How can I use "fill=EuroToUS" with attribute balance?Summary: How can I use "fill=EuroToUS" with attribute balance? Content (please ensure you mask any confidential information): Hi, I am using attribute balance (Type: "Nu… -
Multi Select in List Type AttributeSummary: Is there any option in ARCS to allow users to select more than one option from the List Values when using a List type Attribute? We have an attribute "Explanati…
-
ARCS Data Export - Pipeline to export workbench dataHi team, Do we have any option in pipeline to export workbench data in ARCS?
-
Is it possible to import only certain pieces into ARCS from Data Integration Artifact MigrationSummary: We recently built new integrations in Data Management/Data Integration that we would like to import into Production, but it doesn't appear to allow us to select…
-
Period Mapping for Balance Explanations – Fusion GL Date Outside Period RangeSummary: I am bringing in balance explanations from Fusion into Account Reconciliations. For this example, my Fusion period is JUN-FY-25. In Account Recs, my period mapp…
-
Cannot invoke "com.essbase.api.dataquery.IEssCubeView.createIEssOpMdxQuery()" because "cv" is nullSummary: Hi Team, We have implemented a GL integration using the "Trial Balance Report" (an out-of-the-box report) and leveraged the new balance attributes for Credits a…
-
Do links to internal network drives not work in ARCS?Summary: Can you provide a link to an internal site or share drive in ARCS as an attachment? Content (please ensure you mask any confidential information): We have defin…
-
Can URL attachment links not be modified?Summary: Once a link attachment is created, can the URL not be modified? Content (please ensure you mask any confidential information): Question is pretty straight forwa…
-
Can ARCS Report binders be customized as per the user requirements?Summary: Customization of Report binders Content (please ensure you mask any confidential information): This is regarding Report Binder customization — does Oracle provi…
-
View Source Document in WorkbenchSummary: By clicking the View source document option in workbench, how many days back / months back files user can able download. Content (please ensure you mask any con…
-
We want to know, how open/active recon rule is getting is executed? we want to know the schedule.Summary: We want to understand, how open/active recon rule is getting is executed? we want to know the schedule. Content (please ensure you mask any confidential informa…
-
ARCS FA Subledger report integrationSummary: Issue with period parameter in OOB FA sub ledger report. The period value is the period name and not in a standard date format. Content (please ensure you mask …
-
Reassignment Requests in ARCSIs there a way to auto-approve reassignment requests that workflow users submit? We do not want to have a service admin, power user or user approving these.
-
ARCS Detail Balance - Is there a way to autoclose rec based on core dimensionHi Team, I wanted to create a rule for auto submit in profile/format if the reconciliation contains only 1 unique value for a dimension highlighted in below screenshot I…
-
Is it possible to set match rules to run for specific profiles within transaction matching?Sometimes our one to many confirmed match rule pulls in incorrect transactions and a user was asking if it was possible to make it suggested match instead for his specif…