Data Integration
Discussion List
-
Data Exchange - Clear Region broke after Jan-24 UpdateHi, Unable to select members from the hierarchy in the 'Clear Region' option in Data Exchange on all DLR's. Anyone else notice this? Our last successful run was Jan 19th…Hyperion_Junkie 71 views 8 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform -
Super user cannot Export data using Call AIP. Getting error that user doesn't have privilege.Summary: We wanted use API Call to export the information created in the Jobs. Super user has Data integration roles (Drill Through, Run, Create) but still we are gettin…wojciech.furmanek 31 views 4 comments 0 points Most recent by wojciech.furmanek Financial Consolidation and Close -
Pipeline Move from Outbox OR Download/Upload File OperationSummary: Pipeline as per 23.09 includes 'Move' from Inbox. Could we know about 'Move' from Outbox? OR Download/Upload File operation availability? Content (required): Pi…
-
Pipeline Start and End Period failing though REST API but successful when executed manually.Summary: Pipeline variables for start and end period work properly when executed manually but fail whenever the job is executed through a REST API call. Content: I've cr…
-
DLR Members Selected if no Source Filter GivenI have a DLR which is pulling data from an FCCS application to a TRCS application. The DLR has no Source Filter specified for the dimension Data Source. The structure of…annaschmult 51 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Can a User run a pipelineSummary: Is there any way that a "User" can run a pipeline, removing the dependency on the Service Administrator? Content (please ensure you mask any confidential inform… -
Where can I see jobs scheduled via Data ManagementSummary: I schedule jobs via Data Management but I cannot edit or see the schedule. I can only see jobs that have run. Is there a way to schedule jobs and see the schedu…Catherine Arnold 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Currency for Data Import in FDMEEHi, I am using FINCLOUD as the source for FDMEE location, with the destination being a text file. In the Data Load Rule's Source options, I specified the Currency as "En…Sneha Mallick 53 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to export Data Load Workbench details, Process Details and Logs in FCCS Data Management?Summary: To understand the process to export Data Load Workbench details, Process Details and Logs in Data Management from one FCCS instance and import it into another F…Sujith Kandukuri 91 views 2 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
Errors importing Data Management report templatesSummary Not able to import modified report template files to Data ManagementContent Hello everyone, In Data Management I've extracted and modified a report template (rtf…User_MB094 20 views 2 comments 0 points Most recent by JeroenDrupsteen Financial Consolidation and Close
-
Can we still use the same data load if the flat file is changing?Summary: We currently have a flat file provided to us from a vendor. This flat file is loaded via a data load rule. We have the import format mapping defined based on th…Casey Kempel 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to view update details for report querySummary: How to view update details for report query Content (please ensure you mask any confidential information): The query for our Process Monitor Report was updated …Ryan DeFilippi 91 views 5 comments 1 point Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Is Oracle Decommissioning Data Management in FCCS?Description: To understand if the end users need to perform any activities in case Oracle is decommissioning data management in FCCS and shifting the functionalities to …Sujith Kandukuri 91 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Run integration export mode only None availableSummary: When trying to run the integration and load a csv file to FCC, the export modes Replace and merge are not visible, only a lot of None. Content (please ensure yo…Joost Mellegers 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Data Management file to FCCS - Power users unable to export the data.Hello, We have a group of people as Power Users in FCCS, even though their access to the dimension is fine, while trying to load the file data in Data Management (DM), t…yanni vossos 261 views 9 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform -
Is there a check reports to set a condition for data load via Data Integration / Management?Summary: Content (please ensure you mask any confidential information): Hi all in FDMEE we could use this check report: https://docs.oracle.com/en/applications/enterpris… -
Copying select data from one scenario to another complicated by journalsSummary: I want to copy a subset of data from one scenario to another scenario. Using the Data Copy function, the problem I'm having is with the journals. If a journal h…
-
Is it possible to generate .dat to .csv in DM?Summary: In data management, Is it possible to generate .csv instead of .dat ? Content (please ensure you mask any confidential information): Version (include the versio…Subhojyoti Chakraborty 41 views 4 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Pipeline option to pull a file from third party serverSummary: Currently in data load Automation script, we have a third party server for maintaining the file (loading the file based integration) from e.g. like PeopleSoft. …
-
Frequency of quarterly data loads from Oracle Fusion Cloud ERP GL to FCCSSummary: Hi all, We have a request from the business to load financial data for the quarter into FCCS from ERP GL every hour instead of the current frequency of every 3 …Irfan Ali Gangjee 21 views 1 comment 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close
-
Unmapped records failing load despite account being mapped to IGNORESummary: Has the solve order changed such that ALL members must be mapped, even if one of them maps to IGNORE? Content (please ensure you mask any confidential informati…
-
How to extract data file with date timestamp in data managementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Subhojyoti Chakraborty 31 views 2 comments 0 points Most recent by Subhojyoti Chakraborty EPM Platform and Freeform
-
How to ignore Header and Footer rows in Flat Files for Data IntegrationHi team, Using the new UI of Data Integration. How do you ignore header and footer rows of a flat file? I know with multi-column load you can have it in the expression, …Peter Joelson 782 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
How to set pipeline substitution variable for Week Period combinationSummary: Our PBCS application period holds data in a different way. I.e in Weeks format. Eg: 01/05/2023 01/12/2023 11/02/2023 We have started integrated EPM with Snowfla…Praveen Reddy 111 views 8 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Need information regarding EPM AgentSummary: Hi , we are using EPBCS , we are getting salary data from a view and it’s a multi column data for account, in a file integration , we can define the import form…
-
Customize Data Management Log FileSummary: If any errors in data load rule running, the log file will show the error message. But the file is too tech with coding words. Is there any way to customize the…Xu, Angela Menglei 11 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
How to access Map Monitor Audit Reports within Data ExchangeSummary: Currently within Data Management, there are a series of audit reports that we regularly run for Audit and Controls purposes (See Data Management > Workflow > Re…John Herbert-271036 62 views 3 comments 3 points Most recent by Tbian7577 Financial Consolidation and Close
-
How to Import data in HFM application from FCCSSummary: Is there any out of box integration available to import data in HFM application from FCCS Content (required): Hi Team, We have a requirement where parent entity…
-
Pipeline Copy from Object Store File NamesSummary: We're currently trying to set up the pipeline to import current period trial balances for specific locations into FCCS data manager via the Pipeline Copy from O…
-
DM Update 19.06, Producing Flat-File Extracts out of Cloud Data ManagementSummary As an EPM Administrator or Implementation Specialist, we have all had that moment when someone comes to us and asks for the dreaded extract out of an Enterprise …User_2025-01-30-05-17-11-782 70 views 2 comments 2 points Most recent by Neha Talati-267028 Financial Consolidation and Close