Data load
Discussion List
-
Assistance on how to pass PERIOD as a parameter for Oracle Cloud ERP (custom) in Data ManagementContent We are using Oracle Cloud ERP (custom) to integrate Fusion Cloud ERP Fixed Assets, Cash Mgmt, AR and AP subledgers to ARCS, and have used $END_PERIODKEY[YYYY-MM-… -
Transaction Matching Target Application in Data ManagementSummary Data Management setup to load BAI transaction file for Transaction MatchingContent I am unable to get rid of this error message (see screenshot) while trying to … -
Adding Attribute Columns to Premapped Data LoadsContent Hi Everyone :) Is there a way to add additional attribute (data source) columns to the premapped data load files? I tried just adding the ID of the attribute and…User_2025-01-31-02-27-25-352 22 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Reconciliation Compliance Transactions via Data ManagementSummary Loading Reconciliation Compliance Transactions via Data ManagementContent Hi, I have configured DM to load BEX to reconciliations. I see that the transactions ar… -
Transaction Matching between two Flat fileSummary Need to perform match operation between two flat fileContent Hi All, I have a simple query : I have two files, Can I create a transaction matching between two fi…Prakash Singh-145122 27 views 1 comment 0 points Most recent by RahulBansal-Oracle Account Reconciliation
-
BAI Bank Statement Import Format in Data ManagementContent Hello There,Would anyone have an example of what the import format would look like in Data Management for Source Type = JLBAI Format Bank File Transactions. I'm …User_2025-01-31-02-27-25-352 77 views 3 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
ARCS-TM Data Management Supported date format is dd-MMM-yy ERRORSummary using CDM a source date of mm/dd/yyyy is failing to load with error of Supported date format is dd-MMM-yy.Content Using CDM a source date of mm/dd/yyyy is failin…User_2025-01-28-19-17-59-040 212 views 5 comments 0 points Most recent by User_2025-01-28-19-17-59-040 Account Reconciliation
-
Automatic data load from ERP Cloud to ARCSSummary Guidance on how to automatically pull data from ERP Cloud to ARCSContent I'm currently integrating balances and transactions from ERP Cloud to ARCS. I have succe…
-
AR integration issueSummary ARCS AR integration is not pulling in the correct balances from ERP seeded reportContent I'm integrating AR, AP, and FA balances into ARCS by connecting to ERP s…
-
How to view Historical DataSummary How to view Historical DataContent After creating a new Column that reflects the net amount for each transactions. The column is only reflecting the net amount f…
-
Amount showing in the Reconciliations list Source System BalanceContent Hi all, We noticed an unusual behavior where an amount is showing on the Reconciliations list Source System Balance for a specific profile, but when we open the …yanni vossos 33 views 8 comments 0 points Most recent by Neeraj Lahoti-Oracle Account Reconciliation -
Legacy Data Conversion to ARCSSummary Legacy Data Conversion to ARCSContent Hi, We are trying to convert the historical data from legacy reconciliation system to ARCS. Can you suggest the mechanism o…
-
Maximum number of of Match Type in ARCS and IntegrationSummary System capability for Number of match type and integration requirement to be fulfilled before working hoursContent Hi Team We have a requirement for transaction …
-
Loading bank balances daily issue with balances being overwrittenSummary Daily bank statement file (csv) does not have all the bank accounts listed on Saturdays therefore previously loaded balances are getting removed and replaced.Con…Raj Madha-Oracle 35 views 9 comments 1 point Most recent by Ramesh Kumar.S-Oracle Account Reconciliation
-
Transaction Matching\Data Management ExportSummary New Transaction matching export from DM failing on Amount AttributeContent Hello, I'm running into an snag with the Export of Data for transaction mapping from D…Amanda Lackman 51 views 10 comments 0 points Most recent by RahulBansal-Oracle Account Reconciliation
-
Import Pre-Mapped Balances to a Group ReconContent Hello, Does anyone know if there is a way to use the Import Pre-Mapped Balances feature to load balances for a Group Recon? For instance, My group recon is GRP-P… -
Loading Bank Balances questionContent Hi, Client wants to load bank balances to perform GL to Bank balance comparisons. They are not using Transaction Matching. Is it possible to use the pre-built BA…Sloan Nunziato 92 views 10 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
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. …Asif Mohammad 266 views 2 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
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 : …Prakash Singh-145122 50 views 2 comments 0 points Most recent by Asif Mohammad Account Reconciliation
-
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 …
-
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,…User_2025-02-07-07-43-38-876 36 views 3 comments 0 points Most recent by Thejas Shetty-Oracle Account Reconciliation
-
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…
-
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…
-
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…amaresh salagundi-Oracle 423 views 7 comments 1 point Most recent by Kishan K A Account Reconciliation
-
Convert Functional Currencies into reporting currency of loaded balances in source/sub systemContent Dear Team We have a requirement to convert functional currencies loaded balance into Reporting currencies using exchange rate with help of rate type. We tried us…Jaimin Parghi 63 views 1 comment 0 points Most recent by Nick-Boronski-Oracle Account Reconciliation
-
ARCS Data ManagementSummary Unable to retrieve members in mappingContent Hi, I am trying to set up data management in ARM. While I try to create mappings in Data load Mapping I get error sa…