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 FCCS_Mvmts_FX_Opening and FCCS_Mvmts_FX_Movement are calculated under the YTD translation methodIn our application, the default translation method is set to Year-To-Date (YTD). FX_SubTotal = FX_Opening + FX_Movement. I want to understand how the system calculates F… -
Task Manager Attribute Sorting – List Order Not Respected in Dashboards or Schedule TasksSummary of Issue We are trying to use a Task Manager attribute (list type) to represent Workday values (e.g., Day -7, Day -5, Day -1, Day 0, etc.) and have them display …
-
Alias for Shared Members Not Visible in ApprovalsWe have enabled the alias option under Approvals → User Preferences, but the alias is still not appearing for shared members. Are there any additional settings required … -
Do the default movements recalculate when the opening balances changeSummary: I have a situation where a customer wants to reload the statutory balances into the last period of the prior year, after multiple months have been load for the …
-
Oracle FCCS - Alternate Hierarchy QuestionHi All, I’m working in FCCS and running into an issue with shared entities in the Entity dimension. Current setup: I have a primary hierarchy (Assume XYZ) under FCCS_Tot…
-
Managing User-Defined Attributes (UDA) for Accurate Period-Specific Financial DisclosuresSummary: Hi Experts, We have a requirement to retrieve data based on the control method, such as subsidiary, joint venture, or associate. To achieve this, we introduced …
-
Offset EPA at Entity Currency coming from CTASummary: Due to extensive Organizational ReOrganization of entities with multiple ownership changes, we have ended up with OOB (Out of balance) at parent levels coming f…
-
FCCS Management Reporting- Conditional Properties - Suppression option not working properlyHi, In FCCS I'm trying to create a Management Report, where in rows, I've selected few Accounts and in column I've selected Entity dimension. I've only used one single c…
-
Error when Cloning EnvironmentWe faced the below error when cloning the environment (Test to Prod) Both Environment have the same version 26.05.66 and there is not metadata validation error and refre… -
Best practices to maintain segregation of duties in FCCS for certain use caseSummary: Question around best practices on how to maintain segregation of duties in FCCS and still be able to copy data (with posted journals) from Actual to another sce… -
FCCS Approval Unit Functionality vs. HFM Process ManagementSummary HFM, we had multiple review levels within Process Management. At each level, users were able to modify the data and then promote it to the next review level. The…
-
EPA generation at Subconso and Conso nodesSummary: EPA generation at Subconso and Conso nodes Content (please ensure you mask any confidential information): Do we have any process in FCCS wherein we can figure o… -
FCCS Groovy DataGridBuilder Failing with Security Filtering Error Despite Valid Smart View AccessSummary: We are trying to write back data to FCCS using a Groovy rule with DataGridBuilder. The requirement is to write data back to the same intersection (for testing p…
-
FCCS ODR Issue – Dynamic Block Creation for Reverse ICP Cash Flow EntriesWe are implementing an FCCS cash flow movement logic using ODR where data entered in one Entity/ICP combination needs to automatically create a reversing entry in the co…
-
Variance in Equity Accounts when New Top Entity is addedWe have Ownership Management and Enhanced Organization by Period (EOBP) both enabled in our FCCS application. There is a requirement to have a new holding entity (NewHLD…
-
Remove zero FCCS_OpeningBalanceSummary: Would like to remove zero from FCCS_OpeningBalance Content (please ensure you mask any confidential information): Oracle recently provided guidance on writing r… -
Alignment of header and main grid of reportHi In current scenario the requirement is that when report is downloaded to excel , grid should start from column B. To achieve this I have indented main grid and header…
-
Do not promote feature in ReportsWe have an option called Do no promote in Forms Formatting / Validation rules , which allows user to restrict promoting an entity in Approval workflow. Do we have any su…
-
Import entity crashing applicationSummary: we have EDMCS to FCCS entity push which is set as "Clear members."but whenever we are pushing from edmcs or importing the extract file of EDMCS into fccs after …
-
Trying to clear zeroes but ODR does not workSummary: As there are a lot of stray zeroes in our environment (manually loaded by users), we want to delete them to improve performance. We tried it using two Essbase m… -
can we use REST-API to trigger consolidation in FCCS?Can we use the REST API to trigger consolidation in FCCS?
-
Reports text grid into ExcelSummary: Hi Team, When we try to download reports into Excel, the Text Grid is being exported as an image. However, we need it to be exported as text. Does anyone have a…
-
Intercompany Eliminations ReversalHello Experts, We need guidance regarding a business/design change requirement in FCCS related to Intercompany Eliminations. Current Scenario: FCCS application has been …
-
Opening balances load approachWhat is the best practice approach for loading opening balances to a new FCCS application. I am planning to load local subsidiary currency balances to "Opening Balance A…
-
Not able to fetch FCCS Ownership details in SmartviewHi All, I'm trying to fetch the Ownership Data in smartview to validate it across different periods and years. I am using the same POV for all the Applications. But for …
-
FCCS Reports in Books does not show POV.Summary: Some of the reports are missing in EPM books. debugging more I realize some reports does not show POV in books. Not sure why it is happening to some of them. I …
-
sql query for Alternative Balance for PHPSummary: Need to calculate GL reporting Balance and GL Alternate Balance USD and in PHP. mentioned ACCOUNT_BALANCE query below. Content (please ensure you mask any confi…
-
How to extract FCC data into ARCS?Summary: Hi, I'm trying to get data from FCC to ARCS, Created the VisCnsl Application in ARCS, but I'm having issues with essbase errors in the integration: Is it requir…
-
Dynamic member formula based on POV in reportHow to automate calculation of Day sales outstanding ratio using member formula in each period based on POV selected in report.
-
copy all data including journals from one scenario to another using integration or pipeline approachhow to copy all data from one scenario to another scenario. At present we are using integrrations to copy normal data and journal data with in same FCCS application. Whe…