Data Integration
Discussion List
-
Data is getting loaded partiallyWhen loading data to freeform BSO cube through file based integration, partial data is getting loaded. For one our dimension, example member name is LVMH TEST and in the… -
Data Integration-Global Periods error for RuntimeError: The Current Process Status '' is InvalidUsing a groovy rule to trigger a dataload rule that exports data to file. Rule prompts for scenario, version, entity. Start/End Year on Scenario drives periods to cycle …
-
FCCS Import Data with member not allowedHi all, i'm trying to copy an application and i need to copy data, so i'm using import functionality. The import job is failing due to not allowed members (all reporting…MS. 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Failing Drill-through from GL on pod 1 to pod 2Summary: Hello, I'm having an issue with the drill-through. Although I was able to successfully implement a drill-through from the GL to pod 1, my new drill-through is f…Zut Alors 21 views 3 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Integration> Load from FCCS to TAX fail due to COMMA in the Account nameSummary: Content (please ensure you mask any confidential information): Hi all Could someone please let me know how to go about this limitation: In Planning it is possib… -
How to pull the data of a specific date from Oracle GL Average Daily Balance cube?Summary: Client wants to pull data of a specific date from Oracle GL ADB cube. They do not want to pull the data from last day of the month. For example, Today they want…Harshith J Rao 101 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
FCCS - File based FX rates load through Data Management best practice.Hi Team, We have recently set up the DataManagement process to load FX rates file to FCC. The steps we followed 1.Created FCC Rates target application 2.In target applic…
-
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 405 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 1 view 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 22 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
-
(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 44 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 81 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