Data Integration
Discussion List
-
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 31 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 31 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 81 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
-
Upload file to data management inbox via rest API using power user accessSummary: We need to upload file into data management inbox using rest API. However the upload file is only applicable for administrators. https://docs.oracle.com/en/clou…
-
Hi, what is the approach used for regression testing for Oracle PrimaveraSummary: what's the period Oracle expects the customer to complete the regression testing Content (please ensure you mask any confidential information): Version (include…Imadeddin Jamali 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
File based to Freeform application which has no period dimensionHello, We have a freeform application which has no period dimension but year dimension exists. Year members are like Y01. We have a source file which contains data for m…
-
EPCM with Approval Flow and Task ManagerSummary: How to set up EPCM with Approval Flow and Task Manager? Content (required): I try to set up an EPCM process with a guided process like in task manager and to sa…Mueller 141 views 4 comments 0 points Most recent by Tom LeFebvre-Oracle Profitability and Cost Management