Data Integration
Discussion List
-
pipeline change logSummary: Is there a log (hopefully in the Audit Log) that shows date/time/UserID of changes to an existing pipeline Content (please ensure you mask any confidential info…Russ 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Exporting attribute values while exporting data into a file using DMSummary: While exporting data into a file from EPM application using data Integration, is it possible to export attribute values as well. For example, If we have Project…
-
The form RestDataGrid_xxxxxxxxxx is invalid.Summary: We are seeing this error when loading the data into FCCS from ERP. What does this error mean? Can you please help us? Content (please ensure you mask any confid…Divya_Masoodi 41 views 2 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
Map default_movement in accounts dimension to a movement member in data exchangeSummary: We have created customized movement dimension members for our current client and utilized the default movement attribute in the account dimension. However, we e…Jane Wang 61 views 11 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Drill Through from summary not working in FCCSummary: I've set Create Drill Region and Enable Drill from Summary to "Yes" and reloaded the data. Drill through works when you try drilling from a base-level member bu…Joao Carlos Monteiro 32 views 2 comments 0 points Most recent by Joao Carlos Monteiro Financial Consolidation and Close
-
Integration fails with not so common error msgWe have a file based data load to FCC system and it has failed with a very strange Error msg: ERROR [AIF]: The rest service request has failed: 400 - {"status":400,"deta…MKhade 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Filter out amount less than 0.0001 in Data extract in FCCSWe need to filter out records that are between 0.0001 and -0.0001 while extracting data from FCCS application. We explored Skip row , however it is available in Data Int…
-
created the schedule but not able to see it under the worklist once I created itSummary: We are testing in a Test POD and a schedule was created but it is not in the Worklist Content (please ensure you mask any confidential information): Version (in… -
When zero is loaded to a Historical Amount Override account, the zero is not recognizedWhen zero amount is loaded to a Historical Amount Override account, the zero is not recognized in FCCS in Parent Currency after consolidation runs. Instead, the Parent C…Jacalyn Munyon 11 views 4 comments 0 points Most recent by Jacalyn Munyon Financial Consolidation and Close
-
How to Set Up Integrations from Workday to Oracle EPM CloudSummary: We are trying to figure out how to set up an integration from Workday Financial Management to Oracle EPM Cloud. My only search result is to use Oracle Integrati…
-
Availability of Reference Tables in EPM PBCS for Scripting/MappingHello All, In On-Premise Oracle Hyperion Planning, we have / can access the following tables that can be referenced in scripts: Table --> Info HSP_TEXT_CELL_VALUE --> Ce…
-
FCCS YTD Data Extract from FCCS to a file using Data Integration produces file with only headersI am trying to pull YTD data from FCCS into a file using Data Integration. I see rows in workbench with correct periodic numbers but the data file that gets generated on…Karthiga Devi Ramanathan 32 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Are there technical specs available for the file based import method under data integration?Summary: Is there a technical doc that outlines the EPM system controls used in the file-based integration method? Content (please ensure you mask any confidential infor…MarshaH 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Extracting Data from FCCS for YTD without Data ExchangeSummary: Hi, Currently, users use HFM Extract data load option to extract data from HFM. However, they want to have similar option in FCCS but they do not have access to…Sud VJ 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Pipeline feature using EPM commandSummary: Pipeline feature triggering EPM command and EPM automate command triggering pipeline Content (required): Is there any EPM Automate command to trigger pipeline? …Ramsha Ansari 831 views 13 comments 3 points Most recent by DJ Banga Financial Consolidation and Close
-
Recommended Approach to Data Pull if Primary Ledgers & Secondary Ledgers are in Different CurrenciesSummary: In our current set-up we are pulling Primary Ledger data in functional currency for all countries using standard PBCS data integration (into No Multi GAAP dimen… -
Task Manager connection to Oracle ERP fusionSummary: Task Manager Integration to Oracle ERP fusion Content (please ensure you mask any confidential information): Hello, I am trying to integrate FCC Task Manager wi…Rashmi Subash 82 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Push EPM Cloud data to HFMSummary: We need to push planned data from EPM Cloud to HFM Content: What is the best approach to push data from EPBCS to HFM. The most ideal situation would be that we …
-
Is It Possible to Set Password Expiry to Never for a Specific PBCS Admin Account?Hi All, Could you please confirm if it’s possible to configure the password for a specific admin account in PBCS (Planning and Budgeting Cloud Service) so that it never …
-
Can we load .xlsx file format in FCCS data management?We want to load .xlsx file format into data management? Is there any work around available apart from converting the format externally using macro into .xls or .txt form…Utkarsh Choudhary 21 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
DATA EXPORT OUTPUTFILE(I.E CSV) MOVE TO DM FLODERSummary: Hi All, We created one data export rule and we want the export output file i.e csv it is automatically move to one particular dm folder after completing the dat…
-
are special characters in Multi Dimensional Mapping allowed in ePCM?hi, the below 2 articles seem very conflicting. in the first one: "the target values for multi-dimensional mapping must be an explicit member name. Wildcard or special c…StevenRigby 41 views 7 comments 0 points Most recent by Kapil K Nankani-Oracle Profitability and Cost Management