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
-
Substitution Variable in FCCS Forms Showing Alias Instead of Member Name in Smart ViewHello, We are using a substitution variable for the Entity dimension in FCCS forms. In the POV within the application, we can choose the entity from the member name. How… -
Need Groovy script to execute Validate Metadata, and Recompute Ownership Data in FCCSSummary: Hi I need two separate groovy scripts as follow: Groovy script to execute Validate Metadata (Application→Overview→Action→Validate Metadata→Run). Groovy script t…
-
FCCS cannot consolidate dollar overrides over multiple levelsSummary: We are currently implementing FCCS at a company with 1000+ entities and many levels in the entity hierarchy. Based on other ideas and our vendor feedback there …
-
Creating replica of a cube with same members with unique description and aliases.Summary: There is a client requirement in which as per regulatory existing cube needs to be restructured as new compliance in which the metadata members structure should…
-
Loading the data into FCCS_NoMovementSummary: We are Loading the data in "FCCS_No Movement" which is translation the average rate instead of Ending Rate. those accounts are Balance Sheet accounts. ERP data …
-
FCCS Forms YTD Input Accumulation Issue When Months Entered Out of SequenceIn FCCS, YTD input forms are designed to accumulate values across months. This works correctly when data is entered in chronological order (January → February → March, e… -
Is there any way to extract the DLR list from FCCS?How can I extract the DLR list / Data Integration Names from FCCS?
-
Run Data Exchange (Pipeline) ConcurrentlyWe built some data management rules and pipeline to enable multiple users to run the pipeline (or data exchange) to load different ledgers' TB from Fusion to FCCS. Howev…
-
Create a validation in Data ExchangeWe have a requirement to create validations on source files in Data Exchange. FCCS will receive two files in Data Exchange from each country unit (one individual locatio…
-
Viewing Historical Process IDs in Oracle Data ManagementSummary: Hello, We are currently experiencing an issue with one of the Oracle Data Integration process IDs. Example: Process ID 1627 was used during yesterday's integrat…
-
Not able to copy ownership data from FY 26 to FY 27 for forecast scenarioSummary: Not able to copy ownership data from FY 26 to FY 27 for forecast scenario Content (please ensure you mask any confidential information): requirement is to enabl…
-
Use epmautomate to generate user group report?Hello, Is there a way to use epmautomate to download user group report? Or is this only accessible via web UI?
-
Why is our Balance Sheet out of balance after enabling org by period?Summary: We have recently enabled the enhanced organisation by period option in FCC in order to manage some upcoming changes to our entity hierarchy but despite much tri…
-
Dynamic scaling in reportsSummary: We have customers who would like to be able to choose the scaling in reports at runtime (as there are different requirements for different purposes). Fiscally t… -
Enterprise journal Approval WorkflowSummary: We have a detailed Enterprise Journal authorization policy with multiple approval bands (e.g., Band 4, Band 5, Band 6), driven by the following logic: Different…
-
How to define consolidation method bands to include control and overlapping ownership %Summary: Is there a way to define the consolidation method bands such that the ownership percentage overlaps but the methods are driven by control? For example we would …
-
Application Role Reports-Manage is only showing Copy URL in Action menuSummary: Power users need the ability to edit reports so were assigned Reports-Manage. According to the Oracle documentation this should give them the ability to Add, ed…
-
SmartView Refreshable Report giving #value and Incorrect free form - column dimension on Row.. errorSummary: We have a SmartView refreshable report, some users are able to refresh the values properly in their system. But few users are not able to refresh the values and… -
How to exclude few ICP entities while running Inter company matching ReportSummary: How to exclude few ICP entities while running Inter company matching Report Content (please ensure you mask any confidential information): Hi team, While runnin…
-
Groovy script not calculating Minority Interest Income accurately for 2026 periods in 25.10Summary: Groovy script not calculating Minority Interest Income accurately for 2026 periods. Its working fine for prior years. We have been running Groovy script validat…
-
How to increase year range in calendar populated in data formSummary: How to increase year range in calendar populated in data form Content (please ensure you mask any confidential information): We have created a custom member to …
-
FCCS opening balance adjustments translationSummary: Hi Team, We are adjusting the march opening balances in fccs. Although the entry was posted to the opening balance adjustments movement, FCCS is applying the Fe…
-
FCCS_Entity Proportion Adj Results in Out of Balance at Parent EntitySummary: FCCS_Entity Proportion Adj Results in Out of Balance at Parent Entity Content (please ensure you mask any confidential information): Hi Team, In FY26 P3 period …
-
Export data file from FCCS how to get child entity onlySummary:Export data file to .txt from FCCS, how to get child entity only Target : data file .txt Datasource : FCCS Expect result : entity column show child only not incl…
-
Missing Smart View setting for Set Alias Table for Private ConnectionSummary: One user does not have the Smart View setting to "Set Alias Table" for a private connection to FCCS. Content (please ensure you mask any confidential informatio…
-
how to assign security for an entity in oracle FCCSHow to assign security groups/roles to an entity in oracle financial consolidation and close application. Production is already live. Need to add new security groups to …
-
how to load multiple periods of ownership dataSummary: Is there a method or mechanism to load multiple periods of ownership data. Currently we either update manually period by period in the UI. Or load a flat file w…
-
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… -
calculate amount column in data load mappingSummary: Requirement is to calculate the amount dimension as * to 1/Amount in FCCS data load integration. Kindly help me in sharing knowledge on the efficient way to han…
-
FCCS_Proportion get me an unbalanced Balance SheetContent Hi All, I have this scenario: in December 2019 an entity passes from 0% not consolidated to 100% Consolidated. Balance Sheet is balanced in "Entity Total"-> "Par…