Data Integration
Discussion List
-
how to use application substitution variables in PipelineSummary: We want to use substitution variables (Start month, end month) that defined at at application level in Data load rule. not able to find how to use it in pipelin… -
Removal of Support for Custom Application in DMSummary: Removal of Support for Custom Application in DM Content (required): Can you please let us know how to create custom target application in Data Integration? If w…Ramsha Ansari 31 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
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 102 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 123 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…