Data Integration
Discussion List
-
Pipeline email: is it possible to print the value of the substitution variable?Summary: The March 2025 update added pipeline variable definitions to the email notifications generated from pipelines (see Oracle Fusion Cloud Sales Planning March 2025… -
In EPCMCS, data is not getting pushed to REP cube using Data ManagementI'm pushing data from the Oracle Planning Cloud to the EPCMCS Reporting cube using "Data Management", I'm getting the below error, my metadata is Refreshed, and there is…Kumari Soni Umesh 391 views 11 comments 0 points Most recent by NKW Profitability and Cost Management
-
Is it possible to decrypt a PGP encrypted file available in EPBCS data exchange inbox?Summary: We are getting PGP encrypted employee data file from Workday. It is placed in SFTP folder. We plan on using the OIC to load that encrypted file to EPBCS inbox f…Ravinder Singh-63390 3 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
How to Dynamically Pass Multi-Year Range from Pipeline to Business Rule in Oracle EPM?Summary: I am working with a pipeline in Oracle EPM where I have attached a business rule to the pipeline execution. The pipeline itself is configured to run over a spec…Deepthi G-Oracle 41 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to process Blank rows in TRCS from Source EPM EnvironmentSummary: Assigning NZP expression allows processing ZERO's during the data-load process from Source Environment (FCCS) to Target Environment (TRCS) And for NZP expressio…RitanshuBarik 21 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Tax Reporting (Direct Tax) -
SDM Validation Unable to Retrieve FCCS Account Balance ValuesWe are currently facing an issue where, Supplemental Data Management validation process is unable to fetch account balance values from FCCS. Despite having the necessary…
-
Using Conditional Expressions in FCCS Import Format to Handle Empty ColumnsI need to perform an integration in Oracle FCCS where I have a third-party dimension. The issue is that from the source system (NetSuite), the information for this dimen…User_F8Z0S 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Custom entity variable in pipelineSummary: We have the requirement to trigger the pipeline in FCCS in 2 times, once for a subset of entities, once for all a couple days later. Instead of copying the pipe…Pieter-Jan Vandendriessche 31 views 6 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
Data Exchange new dimension metadata refresh errorSummary: Content (please ensure you mask any confidential information): Hi All Under Data Exchange under the application section, there is an option to create additional…NKW 51 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
(Resolved) Triplicate data when performing a YTD data import from FCCS to TRCS via Data ExchangeSummary: When running a data integration from FCCS to TRCS. Data was first coming through on a periodic basis. Based on the administration of data integration guidance I…
-
Is it possible to use @UDA function in source filter in DLR - EPBCSI would like to use @UDA function in source filter of DLR? Is it possible? If yes, can you please provide the detail info.
-
Load to FCCS_ClosingBalance_Input Replace mode creating reversal in first period for Expense AccountSummary: Expense account is set up under FCCS_Acct Receivable parent. When loading data for the first period of the new fiscal year, if the amount is missing, a reversal…KimJenkins 41 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Can we load data if period and year are in rows and columns"This is the file format, and I want to load the data into the respective year and period. Could anyone please assist me with this?"
-
Java Version for EPM Agent and DriversSummary: I am trying to find out how the EPM Agent assigns the JAVA_HOME variable and if it will require a higher version of Java after the TLS 1.3 update, as well as wh…
-
Issue with Data Management MigrationSummary: I am receiving the below error when trying to migrate an Application from Test to Production Content (please ensure you mask any confidential information): I am…Matthew Gregory-137392 61 views 9 comments 0 points Most recent by Ramaguru B EPM Platform and Freeform
-
Substitution variable for period reference is not working in fccs pipelineHas anyone used substitution variable for period reference in fccs pipeline? I am trying to do it but it fails. My variable is &Period_Year with Feb-24 as value. When I …
-
Member formula performance after DSO MigrationHi everyone! I am looking for some advice. We have several member formulas on the Account dimension that we used prior to the DSO migration that used to run less than a …
-
FCC to Planning Data ExchangeWe are trying to transfer journals from FCC to Planning using an integration. It is all working except for the load to Planning where we see the following error in the l… -
HCM Integration with Oracle EPCMCSWe have been trying to load Headcount data to EPCMCS by Integrating with Oracle HCM. There is no documentation available to load data to EPCMCS from HCM. I would like to…P Avinash 21 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Profitability and Cost Management
-
DATA COPY ISSUE SummaryRequirement: As per the client requirement we need to copy from aggregated parent members to base level stat members for 4 dimension(Account, Profit Center, Functional A…Jayshree Maloo 31 views 8 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Drill Through between EPM Cloud: Planning to FCCS using Smartview Drill through optionSummary: Content (please ensure you mask any confidential information): Hi all We have an integration set up EPM Cloud and ERP and that works fine, but now we want to us…
-
Add "Is Like" Mappings to Data Maps for Cross Application DataSummary: We are trying to simplify our export process from our Planning application to our Essbase application. Currently, we use data integrations to create export file…
-
Change from decimal separator to comma from dot in FCCSSummary: Currently FCCS system is designed with default decimal separator as dot(.), However we would like to update it to comma(,) as the decimal separator. In simple w…Venky55 23 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we setup different email IDs to be sent in case of pipeline failure and Pipeline success in FCCSCurrently, we are not able to setup different emails for success and failure. SEND_EMAIL variable gives the following options- On failure, On Success, No, Always, and ba…Jayshree Maloo 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close