Data Integration
Discussion List
-
Is there any EPMautomate command to update period mappings in FCCS?Summary: Clients wants to update the period key under period mapping for one of the target application on everyday basis. They also want it to be automate. How can we do…Harshith J Rao 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Is there a way to create the reports folder under the outbox folder in the Data management EPM FCCS?I have mistakenly deleted the reports folder in the outbox folder in the Oracle EPM FCCS data management. I was trying to delete the reports generated in the reports fol…RatnaMaruboina 43 views 6 comments 0 points Most recent by Vinay Gupta-Oracle Financial Consolidation and Close
-
How to lock a POV for several periods in Data ManagementSummary: Content (please ensure you mask any confidential information): Hi all In Data Management for EPM there is a option to LOCK a POV for a specific period, but I do… -
EPM Platform Job Job Type for Planning Jobs to run integrationsHi, We have a requirement, where we need to run the integration/Data Load Rule present in EPBCS from FCC using Pipeline. Could you please me know if there is a way we ca…Prem Siva Kumar Reddy Rami Reddy 11 views 2 comments 0 points Most recent by Prem Siva Kumar Reddy Rami Reddy Financial Consolidation and Close
-
How to integrate secondary ledger of of Oracle ERP to FCCSSummary: There is a requirement in our project to integrate secondary ledger of Oracle ERP in FCCS. Is it possible to have a direct connection like Oracle primary ledger…Pooja Jain 16 views 1 comment 0 points Most recent by Preston Oakes Financial Consolidation and Close
-
Can we hold SO if customer is having past overdue invoices?Summary: While creating the sales order need to put hold if customer having any past due invoices Content (please ensure you mask any confidential information): Version …Varalakshmi N 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How can we remove shared entities from a Data Management extract?Summary: We need to generate a SOX control from Data Management. Content (required): The shared entities are duplicating the results. We have tried using mapping to filt…Michelle Wagner 92 views 9 comments 0 points Most recent by Michelle Wagner Financial Consolidation and Close
-
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
-
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 41 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…
-
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 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 21 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
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…NK2025 41 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 32 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
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… -
Invalid Intersection in DM - Output FileSummary: Hi, When data is loaded on an invalid intersection in DM, it marks the process as failed on Export step and creates an output file of the invalid rows. In this …Alyssa Longo 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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
-
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 21 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
-
Import Format "Factor" expression working twice for Admin Users for FCCS.Hi All, We have an import format , where the source amount is getting divided by 1000 (Factor = 0.001) and then getting loaded into FCCS. Ex. Source amount =12345678 , T…Twink-Oracle 1 view 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Data Exchange Source Expression - How to Concat + Transform the same column?Hello, Currently, we have a client who is migrating from HFM to FCC, and they used to rely on FDMEE scripts to transform data during the import process Now, in Data Exch…Guixdx 21 views 3 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data Exchange: Check member in target application before mappingSummary: Data Exchange: Check if the member exists in target application before mapping. Content (please ensure you mask any confidential information): I'm looking for a…
-
Using API Key Instead of Basic Auth in FCC Connection to Call OIC EndpointProblem Summary: We are triggering an Oracle Integration Cloud (OIC) REST endpoint from FCC using a Groovy script and a connection configured via the "Other Web Service …Vijay_Babu 42 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Guidance Required for Setting Up OAuth2.0 Connection Between FCC and OIC with Different IDCS DomainsHello Oracle Community, As part of our current project, we are working on establishing an OAuth 2.0 connection between Oracle Integration Cloud (OIC) and Oracle Financia…Vijay_Babu 16 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close