Data load
Discussion List
-
How to pass 12 months forecast in time format 2024M10 - 2025M09 in one process to DWSummary: Hi all, We are on a monthly basis reporting a 12 months rolling forecast to a Datawarehouse (DW) through the EPM Integration Agent. Date format in DW is like th…Bo Løve Langhorn 28 views 2 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close -
Open Reconciliation Job taking around 12 HrsSummary: We are working on RC project with 300K profiles , The Open reconciliation job triggered after open period and create reconciliation is taking 10+ hours. Content…Kunal Baikar 77 views 11 comments 0 points Most recent by Kurt-ARCS Support-Oracle Account Reconciliation -
Custom BIP Report for AP Subledger Integration with ARCSSummary: Good Day, We are attempting to utilize the Oracle Payables Trial Balance Report to integrate the AP subledger into our ARCS instance. We've noticed that the out…Jared Custer 37 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
BAI vs. BAI2 file formatSummary: We are trying to load both BAI and BAI2 files into transaction matching accounts, via integrations using a BAI Format Bank File Transactions target application.…
-
Getting adjustment period data from GL to ARCSSummary How to Get the Adjustment Period Data from GL to ARCSContent Hi Community, Good Day, Environment Involved : * ARCS * ERP Cloud (GL) Scenario: I have an adjustmen…Prakash Singh-145122 79 views 4 comments 1 point Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Pros/Cons of using FCC to Load ARCSHi - can anyone tell me what they have found to be pros/cons of using FCC balances to load ARCS?
-
ARCS - Output log (process details) is missingHi, In ARCS we load ICO transactions to match, often there are errors such as "Relonciliation does not exist for this period",… These errors are quite interesting for en…
-
Oracle Cloud Subledger Integration with ARCSContent Hi All We have Oracle AP, AR, and Cash subledgers and need to integrate them with ARCS application. Is there any way that we can have a direct integration from t…
-
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… -
[Transaction Matching] ARCS Transaction has 2 different period for Accounting DateHello, Would like to ask a question regarding the Accounting Date in ARCS Transaction Matching. We are encountering variance in ARCS in some of the reconciliations under…
-
"Generate all" action clears data on summary reconciliationWe work with summary profiles. In our mapping there was a mistake where data was going to the summary profile directly. We got some data load errors for this, but it see…
-
How to move individual integration between different ARCS environmentsSummary: We have a requirement were we have to move individual integration between different ARCS environments including (Import format, Mappings, Location, Data Load Ru…
-
How to remove negative symbol #SQL Data Mapping of Amount as Text FieldSummary: In some instances, the Entered currency is auto-matching while the CCY2 amounts are not matching, causing unexplained differences in the reconciliations. We bri…
-
How to prioritize EPM ARCS data management dataloadsHi, Is there a way to prioritize data management data load rules when they run parallelly? Ex: Scheduler triggers loads for every 30 mints and if somebody triggers manua…
-
Which Rest API to use to upload dataSummary: We need to schedule the upload and execution of rules in Data Management because the client requires these two jobs to be performed daily and automatically due … -
Map 2 Source Amounts to Target for ARCS AP subledgerSummary: In Oracle ARCS, AR subledger Integration Setup/ Import Format maps source " FUNCTIONALAMOUNTREMAINING " to target "Amount". This works for existing account 1210…
-
DrillThrough for SL throws error for past reconciliations in ARCS after migration to new PODSummary: DrillThrough for SL throws error for past reconciliations in ARCS after migration to new POD Content (please ensure you mask any confidential information): Hi F…Amit Agarwal-158816 41 views 4 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Subledger Integration not pulling the right ReportWe have 2 Integrations - GL & Sub-ledger and the period mapping has been added as shown in the screenshot for Aug FY25. We see that the GL balance is pulling the right r…
-
How to export workbench data for specific location in DM using epmautomate command?Summary: How to export workbench data for specific location in DM using epmautomate command. Content (please ensure you mask any confidential information): Version (incl…Saritha Mannnajirao 42 views 5 comments 0 points Most recent by Dave Jesky-Oracle Account Reconciliation
-
character limit for text column in transaction matchingHi All, We are trying to pull information of two description columns into one column for each transaction in TM. Column type is text. Can anyone tell me what is the maxi…Sonali Bhatia 25 views 3 comments 0 points Most recent by Lakshmi Narayana Metla-Oracle Account Reconciliation
-
How to integrate weekly data from Oracle ERP Cloud?Summary: We have daily, weekly and monthly reconciliations where we compare Oracle ERP Cloud GL data with external systems using Reconciliation Compliance. For daily and…Artjoms Braulovs 32 views 2 comments 0 points Most recent by Artjoms Braulovs Account Reconciliation
-
Closed Account Reconciliation is reopenedSummary Closed Account Reconciliation is reopenedContent An account reconciliation was approved and closed manually. However, it is reopened again even though there is n…
-
Can power user access already existing or saved data loads and run them in Oracle ARCS?Hi, As per project requirement, we need to provide access to power user to access existing/saved data loads and run them. However, using application roles in access cont…
-
Drill Through to Source and Open Source Document is not working in ARCSDrill Through to Source and Open Source Document is not working in ARCS. For Drill through - we are seeing Error in Fetching details For Open Source Document - The downl…
-
How to change Accounting Date mapping to another date field under existing match typeSummary: We have configured wrong date field as accounting date under source in Match Type. now when we are trying to change this configuraiotn/setup we are unable to ch…
-
ARCS Transaction Rule Allow Copying of Future Dated Transactions into New ReconciliationWe're trying to enable the ability to use future dates in ARCS transactions. Currently our rule does not copy anything with the closed date populated. In the rule config…
-
Is there a way to delete pre-mapped balances that have been imported?Summary: I'm testing out functionality related to importing pre-mapped balances in one of our ARCS test regions. It seems like once I've imported a pre-mapped balance, I…
-
Is any way can we load multiple data loads at same time for same period with different integrations?Summary: there is any way that we can load multiple data loads at the same time for same period with different integrations? The reason for asking is we have a business …Saritha Mannnajirao 47 views 4 comments 0 points Most recent by Saritha Mannnajirao Account Reconciliation
-
FCCS to ARCS - How can I filter only accounts and companies?Summary: Guys, I need to pull the data from the fccs (total equity of subsidiaries). I would like to bring the total of the account "FCCS_Owners Equity". Does anyone kno…
-
How to identify source system adjustmentSummary: Hello all I am just getting familiar with ARCS and have a question. We have a reconciliation profile ABC-MLHFS-Group that is made up of the following accounts: …