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
-
FCCS Data Source Alternate HierarchiesSummary: Creating Alternate hierarchies/views in Data Source Hierarchies in FCCS Content (please ensure you mask any confidential information): For Reporting purpose, we… -
Is there a way to suppress the label from repeating in consolidation journal reports?Summary: In the consolidation journal report, the label repeats for each row. Is there a way to suppress this like you can do in forms or Smart View? Content (please ens… -
Can we load delta data from Cloud GL ERP to FCCS using OOB integration and groovy scriptingCan the incremental data from ERP be extracted and loaded to FCCS using out of the box integration and groovy scripting. Could you please share any link or steps detaili…
-
How to show Ancestor on top rather than at bottom in a Data form?Summary: Do we have control on how to show ancestor in Data form? By Default, Data form shows ancestor at the bottom when I expand a parent, is there any way I can show …
-
ORA‑00001 Error When Synchronizing AUH “Total Geography”Hi all, I’m getting this error when saving/synchronizing the AUH “Total Geography” in FCCS: "Error while saving/synchronizing the AUH 'Total Geography' : ORA-00001: uniq…
-
How to handle a entity ownership change between different parents within same hierarchy?Summary: There is a change of entity ownership within the same hierarchy such that entity roll up 100 % to Parent A in one period and is required to roll up 100% to diff…
-
SUMRANGE not working in Essbase 516 but work with 21CSummary: Content (please ensure you mask any confidential information): Hi All I have an issue where this script using SUMRAGE does not sum data from JAN to DEC but only… -
Local rates not working to parent currency but working for reporting currency in FCCSummary: We have created a local currency account for translations of share capital issue. It is working correctly for translation of reporting currencies but won't work… -
FCCS Data Discovery does not provide calculation trace if a member has a shared instanceHi, Our team is trying to do FCCS Data discovery against a certain combination of data and we noticed that if one of the members has a shared instance, data discovery do…
-
Receiving error FCCS_YTD is not a store type member of the View dim when running Journal ReportSummary: Receiving error when running Consolidation Journal report 'FCCS_YTD is not a store type member of the View dimension. Only members which are store type and leve…
-
Default movement calculation doensn't work for P&L accounts ?Summary: FCCS_YTD_Input + FCCS_ClosingBalance_Input works fine with BS accounts, but problem exists with P&L accounts ? Content (required): Hi everybody, We are utilizin…
-
In Configurable consolidation rules not able to use shared members of account dimensionSummary: In Configurable consolidation rules not able to use shared members of account dimension Content (please ensure you mask any confidential information): Hi All, W…
-
SET HYBRIDBSOINCALCSCRIPT FULL poor performanceGreetings, I searched for the use of HYBRIDBSOINCALCSCRIPT FULL performance issues, but could not find any examples of the following usage. In 30 config rules, we need t…
-
How To: Avoiding HTTP 502 Bad Gateway Errors During ConsolidateSummary: Attached article provides tips on how to avoid HTTP 502 Bad Gateway Error which eventually causes Essbase Network Error during Consolidate/ Translate Content (p… -
Calculation of YTD values for Balance Sheet account after change in Ownership %Summary: YTD calculation of FCCS_Contribution while changing the Ownership % Content (please ensure you mask any confidential information): Calculation of YTD values for…
-
Constant currency solution within FCC - recommendations and best practices from OracleHi Team, My client is seeking a constant currency solution within FCC. Currently, we are proposing the use of a separate constant currency scenario to achieve the desire… -
Need Approval status report in FCCS like Data Process Control of HFMSummary: Need Approval status report in FCCS like Data Process Control of HFM Content (please ensure you mask any confidential information): Hi All, In HFM application, …
-
chieving in FCCS a functionality manage journal entries through Excel.Summary: We would like to understand the roadmap for implementing in FCCS a functionality similar to the one previously available in HFM that allowed journal entries to …
-
REST APIs for ODA Integration with FCCS Task Manager (Tasks, Schedules, Actions)Hello, I am working on a Proof of Concept to integrate Oracle Digital Assistant (ODA) with FCCS Task Manager, and I would like to enable the following capabilities throu…
-
Can reviewer in the approval workflow edit the data if they are given the write access to that entitIn the approval workflow in FCCS, when the owner edits the data and promote the entity to reviewer, the reviewer (who is now the current owner) is not able to enter the …
-
Cost Center dimension custom allocationSummary: We have implemented an alternate cost center allocation process in our application. In this setup, data is allocated from a source cost center to multiple targe…
-
How To: Setup Default MovementsSummary: This article provides recommendation to setup Default Movement attribute correctly on Movement members. Content (please ensure you mask any confidential informa…
-
Entities are not started report/list in ApprovalSummary: We have long hierarchy and notice that few entities are not started for a particular period and consolidation is failed. Is there any way to pull out the entiti…
-
Audit Reports usage in FCCSIs there an easy way to audit FCCS (or Planning) reports usage to identify when and which users executed the reports in a specified interval of time (say last 3 - 6 mont…
-
Note: Essbase 21c and @QUERYBOTTOMUPSummary: Article describes FCCS calculation script and member formula guidance related to usage of new @QUERYBOTTOMUP Essbase 21c function. Content (please ensure you ma…
-
Java error when creating Authentication Token for EPMAgentSummary: Content (please ensure you mask any confidential information): Hi all We have an integration error with EPMAgent 24.12.05 and FCCS. The error is: when we execut…
-
Filter not available on options tab in Data exchange integrationSummary: I have a situation where an integration in data exchange has a greyed out filter option so I cannot set a defined list of data I wish to export. When viewed in …
-
How to back up files in data management in batchSummary: How to back up files in data management in batch Content (please ensure you mask any confidential information): How to back up the file in the workbench in batc…
-
SmartView for MacOSSummary: I was able to successfully create the xml file to connect to a Planning EPBCS app in my Mac OS Laptop. Question - do i have to create 1 xml file, for each conne…
-
Where are the User Preferences Alias Settings used in FCCS?Summary: User has both Member Name:Alias selected in User Preferences General tab for Alias Settings. Where is this setting used? We assumed both forms and reports would…