Data load
Discussion List
-
Replace Not Working for Reconciliation Compliance TransactionsSummary: When importing Transactions for Reconciliation Compliance, (not transaction matching), the Replace option in Data Integration does not work, and leaves old valu… -
Transaction Matching file size and transactions linesSummary: Content (please ensure you mask any confidential information) Hello, Client is having a data file which is more than 5gb so is there a limit for file size to lo…
-
ARCS instead of ending balance period activity loadingSummary: Hello Team, In ARCS instead of ending balances, period activity is getting loaded. Data is coming from the ERP report. Is anything we can do from ARCS side? bus…Samhitha Dantala-Oracle 23 views 1 comment 0 points Most recent by Dave Jesky-Oracle Account Reconciliation -
Configuring Period Mappings to Load BAI Daily but Reconcile MonthlySummary: Configuring Period Mappings to Load BAI Daily but Reconcile Monthly Content (please ensure you mask any confidential information): I'm currently working on deve… -
In ARCS application There are two different region and they want to lock the period independentlySummary: In ARCS application There are two different region and they want to lock the period independently Content (please ensure you mask any confidential information):…
-
Combining GL and SL transactions to create a custom report in the ARCS applicationSummary: We need to combine the GL and SL transactions to generate a custom report. Will it be an appropriate approach for the combined output for the unmatched transact…Subramanian Karunamoorthi 62 views 7 comments 0 points Most recent by Dave Jesky-Oracle Account Reconciliation -
ARCS transaction matching integrations - how to map period to transaction dateWe have a source file that does not contain a reliable transaction date column. We want all transactions in the file to map to the same date, which would also be the per…
-
ARCS Data Management CAMT.053 Load Fails.Summary: We are loading a CAMT.053 bank statement XML file into ARCS Data Management and encountering the following error: Caused by: org.xml.sax.SAXParseException; line…
-
How do match the transactions between GL and SL when GL having both Debit and CreditSummary: We need to match transactions between GL and SL where we are having debit and credit transactions in GL side and SL there is no signage involved in the amount. …
-
Drill through URL from ARCS Data Integration to ERP GL Trial Balance ReportSummary: We have implemented the GL Trial Balance Extract report in Dec 2025, now client is asking for drill through option. I see in the event documentation we have the…
-
Why does the balancing attribute of my data source not appear in the integration mappings?I am using ARCS (Account Reconciliation Cloud Service) specifically for Transaction Matching. I created a Match Type with two data sources, and during the setup of each …Gabriela Fernandez R 30 views 4 comments 0 points Most recent by Gabriela Fernandez R Account Reconciliation
-
ARCS Source Number of Record limitSummary: ARCS Source Number of Record limit Content (please ensure you mask any confidential information): We need to define our integration for ARCS Oracle Subledgers. …
-
How to View Subledger Balance DetailsSummary: I have connected our A/P Trial balance and successfully imported the trial balance report. But even though the overall balance appears on the reconciliation, ho… -
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… -
How to change filename in data load rule in ARCSHi Everyone, We are working on automating data load process through different files daily, we have explored some options but I could not find any option where I can pick…
-
Duplicate Profile Field in ARCS "Reconciliation Compliance Balance" ApplicationSummary: I’ve opened a ticket with Oracle Support regarding a duplication issue affecting the Profile field in ARCS under Reconciliation Compliance. The root cause remai… -
Source System Balances do not show in RC Recons.Apologies if this is a very Basic question, I am new to ARCS and need help understanding the background process involving . I have setup RC reconciliation for an account… -
Can we bring in data from SAP Datasphere into ARCS?Can we bring in data from SAP Datasphere into ARCS? From what i found in the web, it looks we have to export into flat file and then import it into ARCS. What other opti…
-
Invalid Start Period Error. Period not showing up for Start Period ParameterSummary: Hi All, We are facing an issue while running a Data Load Rule for pulling Balances from Source:Fusion ERP to Target:Reconciliation Compliance Balances. I tried …
-
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…
-
Multiple string operations in SQL for Data Exchange failsSummary: Transaction matching process: one of the columns coming from a data source needs some transformation. I need to transform a text value from AAAAAA-BBB format to…Daniela Alexandru-Oracle 12 views 2 comments 0 points Most recent by Daniela Alexandru-Oracle Account Reconciliation
-
ARCS Artifact updatesSummary: ARCS not logging all the data load mapping changes for the Artifact 'Data Load Mapping' updates, we do the data load mapping changes on daily basis, but in few …
-
Is there a limit to number of mappings allowed in Data Exchange?Summary: Is there a max number of mappings allowed by Data Exchange? Content (please ensure you mask any confidential information): Transaction matching process where tr…Daniela Alexandru-Oracle 12 views 3 comments 0 points Most recent by Mike Casey-Oracle Account Reconciliation
-
$START_PERIODKEY$ uses calendar dates, not fiscal.Summary: We use a fiscal calendar in Global Period Mapping, and the Period Key is derived from that fiscal calendar. ARCS is integrated with Oracle ERP reports executed …