Data Integration
Discussion List
-
Default Movements Enabled - FCCS_Retained Earnings child accounts creating out of balanceSummary: Balance Sheet out of balance is system generated by children input accounts under FCCS_Retained Earnings in new year. The Default Movements rule is enabled and …TAMMY_L 62 views 4 comments 0 points Most recent by Harpreet Singh Arora Financial Consolidation and Close -
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 11 views 0 comments 0 points Started by Deepthi G-Oracle Financial Consolidation and Close
-
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…
-
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…
-
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.
-
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 …
-
Is there a way to load adjustments from Oracle ERP to FCCS in different data source members of FCCS?Is there a way to load Period 13, Period 14 and Period 15 adjustments from Oracle ERP to FCCS in different data source members of FCCS? Basically I am looking to load p1…
-
Automated Task for Pipeline execution in FCCS NOT WORKINGHello, I am trying to schedule pipeline automated tasks using task manager in order to schedule the integrations using holiday rules. Even after the start data and start…
-
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 …
-
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…
-
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… -
How can I leverage groovy to execute the Data Integration in FCCSSummary: I am trying to use groovy to run an integration using groovy in FCCS. I was able to do the same easily in EPBCS. Same is not working in FCCS. Appreciate thought…Srinivas Bobbala 34 views 6 comments 0 points Most recent by Srinivas Bobbala Financial Consolidation and Close -
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 12 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 32 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 30 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 37 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 5 views 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 27 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 50 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 14 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Mapping Audit ReportIn FDM we used to have custom reports for audit mappings. How do we create custom reports in FCCS? The standard mapping audit report in data management is formatted in a…Brian Duncan 21 views 2 comments 0 points Most recent by Brian Duncan Financial Consolidation and Close
-
How to schedule Automated Data import from Oracle Fusion to FCCSSummary: We import data from Oracle Fusion to FCCS every month, and we do this manually by executing a job from Data Management for each location separately. However, we…wojciech.furmanek 12 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
audit log changes property of accountSummary: We want to track the changes on the property for the account members in the audit logs. Content (please ensure you mask any confidential information): When upda…Silvia Vilchis 71 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCC multi cubeSummary: FCC multi cube was trailed at KScope 24 as 'coming soon' but we can't see it on the road map now - what is the current status? Content (please ensure you mask a…Ben Walwyn 144 views 3 comments 2 points Most recent by Anand Thota Financial Consolidation and Close -
How do you obtain last modified date for a data integration within data exchange within Freeform?We only see the last executed date within the data exchange screen and we our audit report does not pickup any modifications we made to the data integration. Looking to …C Vincent 14 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Historical Rate disappears after data reload from DM using the replace modeSummary Historical Rate disappears after data reload from DM using the replace modeContent Hi all We are experiencing a strange behaviour from FCCS to which we would lik…NK2025 49 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Dummy dataSummary: Request for FCCS Dummy data for testing purposes. Content (please ensure you mask any confidential information): I do require sample multi-periods trial balance…Sarwar 51 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Reference Attribute values in Mapping ScriptSummary Reference Attribute values in Mapping ScriptContent Loading GL balances data using a file into FCCS. I want to flip the sign of Liability (L), Owner's Equity (O)… -
EPM agent is getting StuckSummary: EPM agent is getting stuck/Freeze Content (please ensure you mask any confidential information): Dear all, One year ago, we configured an EPM Agent and it was w…Ethien Eid 41 views 8 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close