Data Integration
Discussion List
-
How to migrate FDMEE reportSummary: We built FDMEE in a Dev environment and want to move to QA. We copied over the FDMEE application folder and I used LCM to import. I don't see the reports under … -
What is the limit on the number of records that Data Exchange can import?Summary: What is the limit on the number of records that Data Exchange can import? Lets say we have a Oracle EBS source system from where we are importing 3million recor…
-
EPM Integration Agent - Cloud Credentials Vs FileSummary: Have used EPM Integration Agent in past with Cloud as credentials in DM filters but it does not work anymore and only File works. What am I missing here? Conten…
-
How can we load data directly from SAP cloud to FCCS using APISummary: Client want to have a API based connection where they can load the SAP files directly to FCCS. Is there an option to achieve this currently without using any mi…AniN 91 views 10 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
Loading of Adjustment period from ERP GL to FCCSSummary: We have P13 period enabled in FCCS and we're planning to load the adjustment period from ERP GL to this period. The connection we used was the native or out of …User_ZCB13 203 views 3 comments 0 points Most recent by User_ZCB13 Financial Consolidation and Close
-
Is there a way to automate data validation for all Entities and Accounts between Fusion and FCCS?Summary: Curious if anyone has found a way to automate data at all levels between Fusion and FCCS for Entity and Account? I don't think this is available standard out of…Greg Hull 71 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Does integration between PCM_CLC and PCM_RPT timeout more often because of enormous data size?Could the timeout issue in the integration between PCM_CLC and PCM_RPT be caused by the large dataset stored in PCM_CLC, which is slowing down the query performance? Cur…Supanut Sinphatsirikul 31 views 3 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Data Exchange: How to Change Encoding?I have a data source setup as a "File" type. Sometimes UTF-8 makes sense to use on an integration uploading data via a file and other times I need to use UTF-16LE using …
-
Data Management - loading Debit and Credit using delimited fileHi All, I am able to load credit and debit from Delimited file in Data management using the below SQL but one of the issue i am seeing is change sign is not applying bec…Prem Siva Kumar Reddy Rami Reddy 41 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
EPM Integration Agent connection with JDE on IBM DB2Summary: I'm trying to configure the Integration Agent to pull data from an IBM DB2 Table on-premises into FCC (Data Exchange). I couldn't find any relevant documentatio…Claudio Caceres M. 41 views 6 comments 0 points Most recent by Claudio Caceres M. EPM Platform and Freeform -
integration between EPCM and Planning Cloud failing with 401 errorSummary: Content (please ensure you mask any confidential information): Hi all While running and integration between Profitability [source] and Planning [target] cloud a… -
Mapping for amount based on accountcurrent setup is to receive amount in different columns. "Amount1" and "Amount2" If accounts are between 1000 and 2000 then Amount to be mapped as (Amount1 value divided…Dharanidharan M 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCC to PBC refresh members using REST APISummary: We need to automate the process of 'Refresh Members' for the Target application within FCC. An API will need to be established to call this function. This is to…
-
[Data Integration] Trouble pulling ONLY adjustment period (P13) data from Oracle ERP Cloud into FCCHi everyone, I am trying to pull adjustment period (P13) data from Oracle ERP Cloud into FCC. However, when I do so, it also pulls Dec data. Does anyone know how to avoi…Matt Maurer 202 views 3 comments 0 points Most recent by User_ZCB13 Financial Consolidation and Close -
Any performance tuning service provided by Oracle Support?My client possesses a vast amount of retail data combined with a highly complex data model, resulting in numerous intricate data intersections. The whole process of load…Supanut Sinphatsirikul 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Pipeline moved on before job finshed and sets pipeline to failed (even though no error)Summary: Our pipeline emails are showing as failed if a job is still running when it ends. It is also moving onto the next job rather than waiting for the job to finish.… -
TRCS Entity to Reporting Currency Translation Methodology best PracticeSummary: Looking for input on suggested best practice for frequency and methodology of Entity Currency to Reporting Currency translation Content (please ensure you mask …Brian Robinson 92 views 3 comments 0 points Most recent by Brian Robinson Tax Reporting (Direct Tax)
-
How to Pull Incremental Metadata from Fusion to PBCS via Data ManagementHello Team, We are working on integrating metadata (Account, Entity, Custom) from Oracle Fusion to a PBCS application using Data Management in Oracle Cloud. Our goal is …
-
Data Integration with conditional factoring of the data/amount columnContent: We load multiple accounts worth of data, value-based and score-based. Both accounts come from the same csv-file and have the same formatted amounts, however sco…
-
How to integrate oData with EPM Integration Agent using REST call.Issue SAP REST API response will be in JSON format. Data Management can only import delimited files and not JSON files. Requirement Load JSON file to Data Management usi…
-
NetSuite Integration with FCCS1.Our goal is to load trial balance data directly from NetSuite ERP into FCCS. 2.We understand that there is no specific documentation available for integrating NetSuite…K Maheswara Reddy 215 views 1 comment 0 points Most recent by Sunil Gavvala-Oracle Financial Consolidation and Close
-
Substitution Variable - Not Working in Custom Application FDMEESummary: Issue with using Substitution Variable in FDMEE Content (please ensure you mask any confidential information): Hi All, we noticed an issue with a Custom Applica…Antonio Barbaro 23 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close