Data Integration
Discussion List
-
Using Substitution Variables with Pipeline / REST API against ASO Target ApplicationSummary: Getting the following error when defining substitution variables for Pipleline variables or REST API periodname. EPMFDM-ERROR: {Month#Year} notation for Start/E… -
Oracle Tax Cloud - Bringing Tax & Finance TogetherSummary Oracle Tax Reporting Cloud can help you to meet increasingly complicated global tax reporting requirementsContent Globalization equals tax authorities fighting f…Susan Attar 65 views 2 comments 2 points Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax) -
File import - tab delimiter not availableHi All I am using Data Integration to define an integration with a flat file source. When I select Tab as the delimiter in the File Options, I get a warning (Delimiter n… -
Adding a space to the member alias when importing metadata to Data IntegrationSummary: The product alias is a combination of the product code plus the product description. Both are in a separate field and I want to concatenate those with: space hy…Jeroen Goudvis 41 views 4 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform -
Does anyone have a procedure for loading currency rates into FCCS using a spreadsheet?Summary: Does anyone have a procedure for loading currency rates into FCCS using a spreadsheet? Content (required): Does anyone have a procedure for loading currency rat…Phil Nibert 31 views 1 comment 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close -
Error in loading data from Erp Cloud GL (essbase db) to FCCS.Hi all, Its been a very straightforward scenario, where I need to load Actuals ERP cloud data in to FCCS, please see below all my data / member maps, this i swhat im get…yanni vossos 41 views 3 comments 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close
-
3 Data Management/Data Exchange questions regarding data export to fileSummary: We have a requirement to produce an external file from EPBCS (BSO) cube, and it must be in a specific format, ie column layout, fill a column with a variable. 1… -
For YTD data load in FCC, what are the different ways to set up movement dimension?Summary: Please help with this query. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support yo…Kartikey Panday 41 views 4 comments 0 points Most recent by Kartikey Panday EPM Platform and Freeform -
Menu Parameters for BIP Report IntegrationSummary: We are attempting to integrate with ERP using the BIP Report option in our Target Application in Data Management. The BIP Report we are utilizing uses a shared …Sawyer Teague 41 views 1 comment 1 point Most recent by Sawyer Teague Profitability and Cost Management -
Is it possible to move a Data Input form from an application to another?Summary: Content (required): Is it possible to move a Data Input form from an application to another? We need to move a data form from Test to the Live application, is t…FT96 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Are there plans to allows admins to run individual Stages in a Pipeline?Summary: The new pipeline functionality would be enhanced by allowing admins to either: A. Open a pipeline and run an individual stage manually Or B. Reference a pipelin… -
Drill through is not working properly for all entities in Oracle FCCS using data managementSummary: We have enabled drill region options in target application and used R13 as drill URL. Content (required): We are not able to see drill through option on data in… -
How Post Allocated Journals can be posted from PCMCS to GLSummary: Post Allocated Data needs to be send from PCMCS to GL. Can it be done using seamless integration ? Will it be loaded as unposted Journals in GL and users needs …Mohit Pahuja 101 views 2 comments 0 points Most recent by Nagarajut80 Profitability and Cost Management -
can we export data attribute dimension using data managementSummary: can we export data attribute dimension using data management Content (required): can we export data attribute dimension using data management Version (include t… -
Are there plans to add other Job Types to pipeline in future?Summary: At the moment, there's only a subset of job types available to add to a pipeline and our client is wondering whether this will be expanded in future. Content (r… -
Don't See Currency in Data Management Data Load MappingSummary: Need to update mapping for currency, but don't see the dimension in Data Load Mapping. Content (required): I have a multi data type file that I need to update s… -
Procedure to end date / deactivate a natural account in FCCSSummary: Procedure to end date / deactivate a natural account in FCCS Content (required): Checking to see if Oracle or anyone has a procedure to end date / deactivate a …Phil Nibert 51 views 4 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close -
Data Integration - MigrationHi all, I would like to ask you If anyone knows when the first stage of the migration to Data Integration in FCCS and PBCS will take place; In the previous Oracle Cloud … -
Does valid data still get loaded to FCCS if a data integration rule fails?Summary: We have always understood that if a user ran a data integration and it failed on export to FCCS (maybe because of invalid intersections) the WHOLE load failed. …Erringc 101 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
PCMCS - Data Management replaced by Data IntegrationSummary: Content (required): Hi, Since DM will be replaced by the new Data Integration by September, do you know where I can find it on PCM? I know that e.g FCCS has a m…Timestamp EPM Team 51 views 2 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management -
Mapping of Dimension Members between applications based on Alias to member?Summary: To my understanding, data can be pulled directly using DataExchange from Target Application. We are looking for a way to transfer data between 2 EPM Planning Cl… -
Lock Data Location in Data IntegrationSummary: Currently - I lock each data location in DM at the end of each month. Content (required): Switching to Data Integration - is there somewhere to lock the data lo…Casey Kempel 121 views 8 comments 0 points Most recent by Jose1234 Financial Consolidation and Close -
Data Management Location folderSummary: After cloning EPBCS, location folders and its files are missing in target environment. Is it expected behaviour? How to restore them? Content (required): After …Meenakshi Rajagopalan 61 views 4 comments 1 point Most recent by Abderrazzak IDLAHCEN EPM Platform and Freeform -
EPM Planning Dimension Export directly to SQLSummary: Greetings, is there a direct method of exporting a dimension in a Planning application to SQL (MSSQL or Oracle DB), via EPM Automate, ODI, Data Management/Integ… -
Jobs in EPM IntegratorSummary: I want to learn more about running integrations. Content (required): I have three questions regarding integrations: - Can integrations be scheduled from within …User_2025-12-19-01-50-28-141 41 views 1 comment 0 points Most recent by Brett Rooks EPM Platform and Freeform -
Data Integration between FCC and Planning app is not workingSummary: Integration is stuck with status "Current polled process status is: RUNNING" Content (required): Hello All, One of my existing integration between FCC and Plann…Fred_Mamadjanov 51 views 7 comments 0 points Most recent by Fred_Mamadjanov EPM Platform and Freeform -
Backup import failed due to special characters German Umlaut ä ü öI try to rename an application. My first attempt to create an empty application with the new name and import the backup file failed due to the error message there exists…Mueller 21 views 1 comment 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
Data Loads now appearing in JobsSummary: Content (required): I noticed today that when I ran a data load batch, the data load was showing up in the Jobs recent activity list. This never happened before… -
Adding Stages to PipelinesSummary: Trying to test the new pipeline functionality in a Gen1 TEST environment, but when I try to add a stage, I see a "Refreshing" window with no ability to add stag… -
Getting conflicting results performance tuning data map pushes, any Data Management gurus out there?Summary: While trying to performance tune running Data maps in EPBCS we are getting conflicting results, and we are not able to zero in on an optimal batch size. Content…Dawn Watson 81 views 5 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform