Data load
Discussion List
-
Seeking solution to Data Integration.... where date filed may contain character.Summary: Working on data integration and I'm running into an issue where the Date field may contain characters throwing the error "ORA-00911: invalid characters". Has an… -
Generation of log errors for Failed task using EPM automateSummary: I am trying to load data using EPM automate for one of my clients, implementation of Intercompany reconciliation - Transaction matching module, for them the tas…
-
Unable to add transactions - Adjustments to Source systemsSummary: New transactions icon is disabled in Adjustments to source system so user is unable/not allowed to add a transaction. Profile is still Open with Preparer and it…
-
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… -
Loading BAI Files from ERPSummary: Content (required): Hi All, My client is utilizing cash management to reconcile all bank accounts but one, which will be done in ARCS. They are loading BAI file…
-
ARCS Data Validation for Source System with ERP for SOX ControlSummary: ARCS Data Validation for Source System Balance with ERP for SOX Control Content (required): Hello Everyone, I would like to ask what best practices are you foll…
-
ARCS Production to test Backup and cloning questions:Summary: ARCS Production to test Backup and cloning questions: Content (required): Our EPM instances are being migrated to a new data center so we have been asked to do …
-
How to calculate Net Accounted Column from Source Data?Summary: Hello All, We are working on AP to GL reconciliation. We have integrated the AP Invoices and AP Payments data successfully. While Integrating GL Data, Source Da…
-
How can we apply a filter when loading balance to reconciliation complianceSummary: We are trying to filter out some of the data in the csv file and load the rest of the data as the balance for a account in Reconciliation compliance. Content (r…
-
EPM ARCS - Data Rule is getting warning statusSummary: Hi Team, In EPM ARCS, After the August patch, In test instance, while executing the data load rule in the Data Management for one "CIP" Location, It is processe…Sesha Sailini 32 views 4 comments 0 points Most recent by Randa-Support-Oracle Account Reconciliation
-
Does importing pre-mapped balances wipe out all other balances?Summary: We are having an issue at a client where Power Users (who have access to all profiles) are loading pre-mapped balances to a specific set of reconciliations but … -
Seeking correct way to migrate newly created data integration from PROD to TEST...My 1st question to the 3C... "Hello!" By utilizing the Migration tool within ARC, I'd like to find documentation, an external link, or direction on the specific objects …
-
ARCS - Data Load Rule Error "DEBUG [AIF]: Error opening Data file"Summary: Data Load Rule Error upon importing file from Inbox Content (required): Hi everyone, I am currently trying to manually import .csv file through Data Load Rule I…
-
How can I ignore the transactions that it was loaded previously?Content Hi, In my data load, is there a way to ignore a transaction that it already was loaded previously in the last data load? i'm asking this because: 1 - If I load t… -
Incremental data load for Transaction Matching from BIP report data sourceSummary: Loading data from BIP report data source into Transaction Matching module. Content (required): I am loading the transactions using the out of the box ERP BIP re…
-
Can we load the journal lines from ERP to ARCS to do TM using native integrationSummary: Can we load the journal lines transactions data from Oracle ERP to ARCS to do transaction matching using native integration between ERP GL and ARCS Content (req…
-
How can we load file from ERP Fusion to ARCS Data management folder using OICSummary: Content (required): Hi, can anyone please provide a document or link to understand the steps for loading the CSV file from ERP Fusion to ARCS Data management fo…
-
Seamlessly transfer Reconciled items from ARCS transaction matching to ERPSummary Possible ways of transferring reconciled items from ARCS transaction matching to ERP on daily basis at prompt timeContent Hi Team Can ARCS manage to work as the …
-
Importing CSV File with Comma (,) in the DataSummary: Is it possible to import (in Data Management) a CSV file which contains comma (,) in its data? For example, the amount column has a data of 1,000.00. Content (r…
-
User access to Data ExchangeSummary How do I provide users with access to Data Exchange?Content Data Exchange was added in the May release. The Admin guide on Data Integration indicates that Users …
-
Can I import "Reconciliation Reference" from ERP GL into ARCSSummary: We would like to get the field "Reconciliation Reference" from ERP using Account Reconciliation Manager into ARCS. Content (required): We're trying to get the "… -
Custom Report needs to be placed directly to the Data ManagementSummary: Custom Report needs to be placed directly to the Data Management Content (required): I would like to load the balances into FCCS for some validations against lo…
-
Auto Reconcile on accounts with no balancesSummary: Hello, We are using ARCS to reconcile between our primary and secondary ledger to search for unexpected differences. By doing so we have set up all of our accou…
-
Translate manually entered Balance into higher currency bucketSummary: I want to know why the manually entered Balance can not automatically Translate into the higher currency bucket like what Data Load does. Content (required): In…
-
ARCS: Extract Adjustment data from ARCS using Data ManagementSummary: Hi All, We needed to retrieve adjustment data that was submitted in reconciliation (Reconciliation Compliance). Can we extract data from ARCS using data managem…
-
What's the best practice to Restore TM and Adjustments after Archiving and purging a Match type?Summary: We are building an EPM Automate process to archive old TMs records form the system. As part of the requirement is to test the restoration process. As per my res…Claudio Caceres M. 42 views 2 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Can you push currency exchange rates from FCCS to ARCS? Is there a workaround?Summary: Looking for a way to push/pull/load currency exchange rates from FCC to ARCS. Content (required): We currently use the FCC and Planning applications and are in … -
What methods are available to extract ARC data tables?Summary: Are there any methods, outside of custom reporting, to extract data from the tables within ARC? Content (required): Our business users have a desire to be able …
-
Assets in ARCSummary: Assets in ARC Content (required): Asset is listed as a source in ARC, is there any documentation on how to configure ARC to import cost summary, cip summary and…
-
Mapping to IGNORE in Data Management showing in ARC as Invalid MappingContent My client has certain accounts that they would like to map to IGNORE in ARC. We loaded data for the first time since the new release and all of the ignored accou…