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 trace the data input mechanismSummary: Hi All, Are there any ways in which we can trace whether the data for a particular member has been uploaded directly through forms / Smart View / Data Integrati… -
Subsidiary owned 100% gets proportion effect up to its parent equal to ownership % of its subsidiaryHi, We have a situation where a new entity gets activated in April FY23 as a 100% owned subsidiary (E122), which consolidates to a parent that is 45% owned (using propor…
-
Elimination is not working in shared account structureWe have created alternate account structure for segment reporting and shared Balance sheet members from primary hierarchy to shared hierarchy. It seems elimination is no…
-
using a custom "investment in subsidiaries" account for equity pickup?Hi all, In Oracle's Financial Consolidation and Close (FCC) tool, when posting the original investment to a subsidiary, you are typically required to use the seeded acco… -
Report book synchronization issueSummary: Hello, It seems there is a synchronization issue with the report book. When we change the POV in the report included in the book, the report book stops function… -
Clear data on Parent Input/Parent CurrencyHello all! How to clear data on FCCS_Parent Input/Parent Currency members since they are Restricted Members and cannot be set in the 'Clear Data' job? Thank You! -
What is the size of FCC Outbox?Summary: What is the size of FCC Outbox? Content (please ensure you mask any confidential information): What is the size of FCC Outbox? What happens to the files in outb…
-
Add Consolidated Entity in HierarchySummary: We are adding a new consolidated entity in the entity hierarchy structure example (110C). What steps we need to take in FCC when adding a consolidated entity. U… -
Backup consolidation dataSummary: I wanna backup consolidation data for certain period only to be imported to testing environment. Because there's shared entity member before primary entity memb…
-
Custom CTA Calculation in FCCSSummary: The client has requested a customized CTA translation rule. We have drafted the rule below, but it’s not producing the expected results. Could you assist in pro…
-
Equity Pickup rules exceed 50 member setsI created SR #3-37306277791: Equity Pickup rules exceed 50 member sets with Oracle support, but they are redirecting me to this forum to get a solution for this, so here… -
Dynamic calc member not rolling up to dynamic calc parentWe have a dynamic calc member with a member formula which is not rolling up to its parent which is again a dynamic calc. Example: Average_Views is dynamic calc member wi…
-
Rounding Off Data in FCCSummary: Hi, I need information on how to round off data in FCC and the approach to achieve this. Content (please ensure you mask any confidential information): I heard …
-
Member formula not calculating for Store memberWe have created an additional scenario (Actual_Var) in FCCS application for calculating the periodic variance between two months. E.g. between May and Apr. To achieve th…
-
FCCS not creating block on entitySummary: I have a requirement where the block for entity has to be created based upon exiting entity. The rule has been added to FCCS_10. If entity [US_DIRECT].[E.10008]…
-
Locking/Unlocking Entities - Any automated way?For locking all historical periods, is there any automated way for all periods in a year? Currently we are locking period-by-period and year-by-year in Approvals card. -
Supporting Details in Data FormA specific cell in a Data Form is just utilized for Supporting Details. The user cannot fill in straight data; they may only provide Supporting Details. is this somethin…
-
Can we export the reports in Powerpoint directly using smartviewHi, We are trying to export the FCCS reports using SmartView directly in the Microsoft word and file. Is this functionality available in the MR reports? Regards Jyoti Sh…
-
FCCS: Change Signage of Account Types according to Source SystemSummary: We would like to know about the Impacts/Challenges of applying the customize signage for Asset/Liabilities/Equity/Revenue/Expense which aligned with ERP signage…
-
When we insert a sheet for fCCS in smartview it does not allow to edit promptSummary: Using smartview for reporting package, we create reporting package every month by inserting the files, is it possible to refresh the files by using the month pr…
-
FCCS Dashboard export in SmartViewHello, Our client wants to combine both data forms (Cost & Dep) for "PPE & ROU & IA" in ONE Dashboard each and needs to represent it in ONE excel sheet. Currently the da…
-
Groovy script to filter entities by ICP_Entity_YesWe are using a groovy script within a form. We have it currently building the rows with ILvl0Descendants of the entity in the user's POV. This works with no problem. Now…
-
FCC Recompute OwnershipSummary: Sometime in June, FCC started requiring the Recompute Ownership Data job to be run anytime after the database was refreshed. The database refresh could be run f…
-
Substitution Variable is not working every timeSummary: we are using substitution variable to pick a previous month to run the calc script. it does work fine, when all Entities are impacted but when we run consolidat…
-
Defining Entity HierarchySummary: Hello Experts We have following entity hierarchy. There, we have defined the Company X as a subsidiary. However we have following doubts to be cleared. 01. We h…
-
Smart view Data Retrieval LimitationsSummary: Need to Know Limitation of Smart view to retrieve the data in rows: What is the maximum limit? Would there be any risk of data getting truncated towards the end…
-
What is best practice for handling add backs like depreciation expense in FCCS cashflow movements?Summary: In the cashflow movements, depreciation expense comes in as a Net Income movement, how do we we add this back in the FCCS movement account "FCCS_Mvmnts_Deprecia…
-
API to update FCCS Task StatusSummary API to update FCCS Task Status??Content HI , I am working on an use case to trigger an external application when FCCS is triggered. We are able to achieve that u…
-
Functional Currency under Location DetailsSummary: Exchange Rates via BIP Report from GL to FCCS Content (please ensure you mask any confidential information): We wanted to check if and confirm if the Functional… -
Planning to FCC load for 12 periodWe have an integration that pulls data from Planning custom to FCC. The process works when we run integration for one month at a time and gives correct numbers in FCC. (…