Data Integration
Discussion List
-
EPM Integration Agent Query data from JDEThe EPM Integration Agent was built and the data was queried from JDE. Our requirement is to TRIM and concatenate the data using a CASE expression. Are there any suggest…Dharanidharan M 72 views 13 comments 0 points Most recent by Narayan Financial Consolidation and Close -
DM: Data load is taking over 1h to load data when it used to take 30 secondsSummary: Content (please ensure you mask any confidential information): Hi all We have an issue where data load from EPM Data Management is taking over 2 hour to load wh…NK2025 91 views 32 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
Error log Limit 1000 linesSummary: EPM has a limit of error lines for importing data into data management which is 1000 lines. We suggest this limit be parameterizable since in many cases informa…David Mata 26 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Integration execution failed, Outline load finished with errors.Hi, I am trying to import data using data integration. Once I have run the integration. I am getting this error in log "Outline load finished with errors" Here is the lo…Noah01010101 133 views 10 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Request for list of ERP service user 'roles / Privileges' for Direct integrations to FCCSSummary: Hi, Can anyone suggest what the Oracle suggested roles to be assign while creating a Service user in ERP, which we use for ERP to FCCS direct integrations. I ca…Anand Rasa 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS integration with Microsoft dynamicsSummary: Customer is looking for an option to do direct integration with MSD ( Microsoft dynamics ) - can we utilise integration agent? Content (please ensure you mask a…Alok P DAMAC 66 views 5 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data export of same combination to two different targets drops export for second targetWe are trying to export data for a combination to two different target members. It exports data for the first Target member but does not export for seconds Target member.
-
Enable Default Movement Setup FCCSummary: Enable Default Movement in FCC. Currently we manually set up our movements in FCC when new accounts are created. To avoid manual process, we would like FCC to p…Sanjana Soni 375 views 38 comments 0 points Most recent by Sanjana Soni Financial Consolidation and Close -
@ILvl0Descendants() function extracting Dynamic calc memberWe have DLR to extract numbers from FCC. We have defined @ILvl0Descendants("[Custom1].[Total Custom1]") for Custom1 dimension in source filter and expecting level 0 memb…
-
EPM Agent Seeded QuerySummary: From Planning I set up a app with the "EBS GL Balance" app and can execute the Preseeded Query against the agent, I see the query string it in the log. How do I…
-
FX rates pull from ERP to FCCS - Dimensions mapping questionSummary: I have this request from my client to Pull FX rates from ERP to FCCS application. and am following this document: am stuck at Dimension Mapping (step #9 in the …Kemp2-Oracle 12 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Correct amount is not being retrieved in Data IntegrationHello, In Financial Consolidation and Close, when I ran Data Exchange>Data Integration. The correct amount is not being retrieved. I have attached my mapping and the scr…Noah01010101 73 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error connecting to FCCS from Data Management of on-prem HFMI am getting below error when connecting to our Cloud POD and I am pretty sure, all the details I entered are accurate. Both the source and target are in same domain.SR912 92 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How can Data Integration Pipeline or Integration be copied?Hi! I need to copy couple of Data Integration Integrations and Pipelines from Test environment to Production. Is there a way to do that without copying anything else (so…
-
Snowflake to FCCS integrationIs it possible to integrate data from Snowflake to FCCS? Are there any reference documents/whitepapers around this?SR912 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
DI: Drill Through does not work with FCCSSummary: Content (please ensure you mask any confidential information): Hi all We are trying to rul a Drill through in FCCS via Data exchange but we are getting this err…
-
Usage of Drill throughHi There, We have enabled the Drill through option in FCCS and loaded the data through data integration(Current period). We are unable to drill through for the previous …Sashidhar Reddy 21 views 3 comments 0 points Most recent by Sashidhar Reddy Financial Consolidation and Close -
Deletion of IntegrationsIs there any faster and fastest way to delete integration from Data Exchange/Data Integration? In data management terms, we have 5 DLR connected to a location , moreover…MKhade 12 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Error while import application (data source) ERP fusion CloudError while import application (data source) ERP fusion Cloud (test environment) in FCCS (test environment) Data Exchange for integration. The log issue is below; 2024-0…
-
What is the size of FCC Outbox?Summary: What is the size of FCC Outbox? Content (please ensure you mask any confidential information): What is the size of FCC Outbox? What happens to the files in outb…Vidhi Nenwani 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Functional Currency under Location DetailsSummary: Exchange Rates via BIP Report from GL to FCCS Content (please ensure you mask any confidential information): We wanted to check if and confirm if the Functional…Kenneth John Asper-Oracle 31 views 4 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close -
Planning to FCC load for 12 periodWe have an integration that pulls data from Planning custom to FCC. The process works when we run integration for one month at a time and gives correct numbers in FCC. (…MKhade 31 views 5 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
How to auto disable user in FCCSSummary: Hi, We have a requirement to auto disable/inactive user in FCCS/OCI. Is there any API or configuration available to fulfill this requirement? We have a requirem…Andika14 32 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
posting journal via data exchangeSummary: Content (please ensure you mask any confidential information): Hi all Can someone please let me know if there is an option to post consolidation journals via Da…
-
What setup should perform to enable the drill through to Summary Level in EPM FCCS?Summary: The drill through is working fine in EPM Report but not in data form. Content (please ensure you mask any confidential information): Version (include the versio…User_ZCB13 63 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCC integration to SAP BW Hana (On-premise) using EPM Integration AgentSummary: FCC integration to SAP BW Hana (On-premise) using EPM Integration Agent Content (required): We wanted to know if we can connect to On-premise SAP BW Hana using …SenthilSSN 411 views 6 comments 0 points Most recent by Fabio Fiore Financial Consolidation and Close
-
On-Premise File Integration Agent - does not contain a header recordSummary: On-Premise File Integration Agent is not working, log file show 'does not contain a header record', but csv file in epm agent inbox has a header. Content (pleas…AA_AlfonsoGonzalez 22 views 3 comments 0 points Most recent by AA_AlfonsoGonzalez Financial Consolidation and Close -
Creating an outbound integration from FCCS to Third Party SystemSummary: We have a requirement where in we need to run a Report in FCCS and push the output to a third party SFTP. What are the ways to achieve this? Content (please ens…Mandeep Mittal 6 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
Error while running BR with IntegrationWe have added consolidation and transaltion rule with data load rule to consolidation numbers after data load but getting below error for a rule which we have not added …
-
Data exchange export not working from Workbench ActionsSummary: Has anyone else experienced that you cannot export the view data data listing from the Workbench in data exchange/integration? It works if you use Data Manageme…