To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Financial Consolidation and Close
Discussion List
-
How to run consolidation for current year skipping impacted prior period consolidationSummary: Client unable to run the consolidation for current year as prior period is impacted and need consolidation. Client is not willing to re-open the prior period an… -
Slow execution of DELETE FROM TDATASEG_THello, We are experiencing a performance issue in our FCCS environment (Data Integration). The execution of the following query in the backend is taking an unusually lon… -
Error loading Exchange Rates to FCCS Rates Cube via AutomationHello All, I have an Integration defined to load Exchange Rates to the Rates Cube in FCCS from an On-premise Database using EPM Agent, but the rates are failing to expor… -
Long loading time to open a data form on FCCSUser requests to have an extra column showing last year's Period12 YTD as a reference on all data forms. So, I created a Dynamic Calc Scenario member with member formula… -
We need to limit LOV for import process to a specific module load interface file for import jobSummary: We need to limit the LOV for the import process to a specific module when running the load interface file for import job in Oracle Fusion. For example, users wi… -
Calculate flux amount for p&l account by entity in fccs reportsSummary: Hi All, We have a requirement to calculate the flux (current year vs prior year) for P&L account. However it is working for BS account but not for P&L. We also … -
Smart view connection issue while loginHi Everyone, Since Afternoon i am getting below mentioned error in SmartView and not able to connect the same. Even after clicking "yes " nothing is showing on screen ju… -
SmartView formula 'HsDescription' is not yielding result on the Fusion GL SideSummary: We are using Build Function > HsDescription to show Natural Account Description. However it is not working for us. Does it work on the Fusion Side. Reference : … -
Simple Tutorial: Import System Exchange Rates from a File Using Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based exchange rates to FCCS Rates cube using Data Integration. Tutorial demonstrates how to … -
Data Load at Parent EntitySummary: There is a requirement to enter data at the parent-level entity. The parent entity is associated with only one shared member. We introduced the shared member be… -
Lock/Unlock entities in different phasesSummary: Actually our requirement is to lock/unlock entities in two phases for example client wants to lock TB data first and data forms after few days Content (please e… -
Data Input at Parent EntitySummary There is requirement where we have to enter data at parent level Entity.Content Hello All, There is requirement in FCC where we have to enter data through custom…
-
calc script code doesn't write back data per rule. please helpSummary: The calc script returns no errors but no data is written. Please help! Content (please ensure you mask any confidential information): SET HYBRIDBSOINCALCSCRIPT … -
After cloning FCCS app from test to prod we see difference in total no. of Rules from overviewSummary: After cloning FCCS app from test to prod we see variance in total no. of Rules from overview, in test we could see 47 and after cloning we see 46 rules. This is… -
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… -
Clarification on Cashflow Configuration and TestingSummary: Hi Team, Since the inception of the application in 2021, we have been using a single default movement. However, starting from 2026, the business has decided to … -
What do these settings and conditions mean in the context of Consolidation Job analytics?For consolidation Job analytics, Yearly consolidation label needed to meet the following conditions : You have two or more impacted periods and two or more hierarchy lev… -
HCM business evenSummary: HCM Business Events and Documentation Content (please ensure you mask any confidential information): We've developed an OIC integration that pulls HCM business … -
How To: Lock and Unlock Approval Units via Data Form and Action MenusSummary: Attached video explains an approach of how to Lock and Unlock Approval Unit and Approval Unit Hierarchy via Data Forms and Action Menus. Content (please ensure … -
Block consolidation for a specific scenarioSummary: Block consolidation for a specific scenario Content (please ensure you mask any confidential information): We would like to not allow user to run consolidation … -
Display the rows based on run time selection in data form (HFM to FCCS)Summary: Hi, Need some thoughts to replicate the below HFM functionality in FCCS-Data form Scenario: - We have more than 500 icp entities which is generating 500+ ICP me… -
Entity with less than 50% ownership but overall control not consolidating/eliminating as expectedSummary: We have a subsidiary that we want to fully consolidate and have a non controlling interest of > 50% but we're seeing issues with intercompany eliminations Conte… -
Approval Unit Sub Status Failed: Entity Calc Status ImpactedSummary: User cannot promote and sub status appears as Failed: Entity Calc Status Impacted. Content (please ensure you mask any confidential information): The Calc statu… -
FCCS Rest API for Automating Actions on Approval ProcessDo we have a Rest API to automate actions for the approval process like Promoting or Locking an entity in the Approval Unit Hierarchy ? -
Is there a way to clear out all users from security groups in access control?Summary: We have made many modifications to the security groups that were initially set up in FCCS access control. We would like to clear all users out of the groups and… -
Turning off OwnershipSummary: We're not using Ownership so we would like to turn it off. In our Test environment, we have created a new application with this option turned off. Upon re-loadi… -
Entity RestructuringWe need to make some major Organizational restructuring change in the Entity hierarchy at top as well as bottom level entities. what would be most effective and feseable… -
Can we generate notification when there is any change made in ownership module in FCCS?Can there be any setup/configuration done in FCCS that sends out notifications/alerts/announcements to some users whenever there is any change made in the ownership modu… -
I am trying to write a rule in Calculation manger to loop through all base member accountsSummary: I am trying to write a rule in Calculation manger to loop through all base member accounts under FCCS_Total Balance Sheet under entity CO1147 and assign it to a… -
January 2026 patchSummary: Instance Patching Process Content (please ensure you mask any confidential information): It appears that the January patch hasn't been installed on our FCCS tes…