Data Integration
Discussion List
-
support for exclusion in options->filters for an integrationWe have a very specific requirements for filter criteria for data export integration which is requiring us to hard code 100's of members in a filter. It would be great i…MKhade 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Why do I have to refresh the FCC Database after making a mapping change in Data Management.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Alan Hall-251497 41 views 5 comments 0 points Most recent by Alan Hall-251497 Financial Consolidation and Close
-
PCM Essbase data load on member with Chinese charSummary: Our application has products with chinese characters in the member name (not alias), so when we are trying to load data to the PCM_CLC cube its throwing error s…HarryEPMUser 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Need to have an automated process to export Journal Entries into a file or database.Summary: Need to have an automated process to export Journal Entries into a file or database. Content (required): In HFM we were able to extract Consolidation Journal En…Zenithz 81 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS DM access provision and controlSummary: Hi Folks, We are looking for details how to segregate roles in FCCS Data Management. We would like to provision user with Drill through option to connect to Ora…Sud VJ 111 views 22 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data Exchange Data Mapping Target Expression SQL Case statementSummary: In an EPM Planning Data Exchange integration, I need to replace a parent value and member value of “T” with another value like “T_Fund”. I cannot use Replace() …
-
How to populate agentContext["INTEGRATION"] for File based source systemSummary: We've a required to pickup the file from agentinbox folder into Data Integration. We're using EPM agent event script (BefExtract.py) Jython scripting to copy th…Kishan Kesanakurthy 21 views 2 comments 0 points Most recent by Ganesh Karri EPM Platform and Freeform -
Loading allocation results to ERP GL CloudSummary: Loading allocation results to ERP GL Cloud Content (please ensure you mask any confidential information) We have a need to load the results of our EPCMCS alloca…SAW23321 21 views 2 comments 0 points Most recent by Pat McCarty-Oracle Profitability and Cost Management
-
Custom Application FDMEE - File Name CustomizingSummary: Custom Application FDMEE - File Name Customizing Content (please ensure you mask any confidential information): Hi All, I have a question related to a Custom Ap…Antonio Barbaro 21 views 4 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Capture error/.out file from Data management processWe are encountering an issue in the Oracle EPM Data Management process while executing a data load rule. The process fails, and the detailed error is logged in the .out …Poorna durga 22 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data integration issue with Intercompany dimension from fusion to FCCSHi Team, We are in the process of performing data integration between Oracle ERP Cloud and FCCS. While the integration setup has been completed successfully, we are faci…Suresh V 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCC - Drill Through to SAP URL parametersSummary: The client has provided a custom SAP URL for us to set up a Drill Through feature. During the configuration, I replace the placeholders for "Account" and "Entit…Joao Carlos Monteiro 22 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
can we validate if TB is equal to zero before loading into FCCSHello Experts, Can we check if the Trial Balance loaded into FCCS can be validated before exporting to FCCS in Data Integration ? We've a requirement to check if the TB …Kishan Kesanakurthy 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
EPM FCCS Case-InsensitiveWe are migrating from HFM (11.1.2.1.0) to EPM FCCS (FDMEE 24.11.07). I have come across an issue that is painful to say the least. Everything is case-sensitive in EPM FC…Brian Duncan 1 view 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Data Integration Pipeline - EPM Platform Job - Clear Data not working / need additional parameters?Hello, We have an FCCS "Clear Data" task that exists in the local FCCS application & runs fine manually via "Overview" -> "Clear Data" from FCCS, but we cannot get it to…Trey Daniel 699 views 22 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
audit EPM planning query changesSummary: Is there an audit of the changes to the Data Exchange queries in EPM? We need to be able to review these changes on a weekly basis. Content (please ensure you m…Steven Taylor 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
How to pass 12 months forecast in time format 2024M10 - 2025M09 in one process to DWHi all, We are on a monthly basis reporting a 12 months rolling forecast to a Datawarehouse (DW) through the EPM Integration Agent. Date format in DW is like this exampl…Bo Løve Langhorn 1 view 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Viewing Historical Process IDs in Oracle Data ManagementSummary: Hello, We are currently experiencing an issue with one of the Oracle Data Integration process IDs. Example: Process ID 1627 was used during yesterday's integrat…VikramMed 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 92 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 196 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