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
-
Smartview new version release?Hi, The current version of the smartview is 23.200. any idea when will be new version releases as we are planning to roll out the new version installation to huge list o… -
Can you customize the service admin role in FCCS?Summary: I am looking into customizing the Service Admin role for a technology group that should only be able to assign security access in FCCS and view data. This group…
-
FCCS custom business rule is not working with No error but debug errors out with null exceptionSummary: e are calculating allocation in FCCS using custom business rule. Until yesterday it was running fine but suddenly it is getting executed in very short time with…
-
FCCS custom business rule is not working with No error but debug errors out with null exceptionSummary: We are calculating allocation in FCCS using custom business rule. Until yesterday it was running fine but suddenly it is getting executed in very short time wit…
-
Oracle EPM Updates - Jan 2024Hello, I have a question regarding the EPM Release Updates for January 2024. After checking the Oracle website, I noticed that there are no new features released this mo…
-
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…
-
Transfer ledger balance ends with errorwhen Run Transfer ledger balance the request ends with error and the massage error Target account code combination information to use for the balances transfer is missin…
-
Frequency of quarterly data loads from Oracle Fusion Cloud ERP GL to FCCSSummary: Hi all, We have a request from the business to load financial data for the quarter into FCCS from ERP GL every hour instead of the current frequency of every 3 …
-
Trying to Copy Ownership Data to Next YearSummary: Receiving the following error: The following destination Scenario(s) are Locked. These must be unlocked in order to copy ownership data: '[Actual]'. Actual scen… -
Unmapped records failing load despite account being mapped to IGNORESummary: Has the solve order changed such that ALL members must be mapped, even if one of them maps to IGNORE? Content (please ensure you mask any confidential informati… -
Process for Entity MovementSummary: Any time we make Parent Entity movement, we need to un-lock all periods and re-consolidate historical periods. If we have 5 years worth of data, and it's taking…
-
Transaltion override FCCSHello, in our application we have the need to translate one account using a specific exchange rate. Here below the case: The goal is to have in the Plan scenario the dat…
-
Exchange Rates - predefined formHello, the currency of our application is EURO. We inserted the exchange rates using the web form Enter Exchange Rates - Single Period. In the image below, you can see t…
-
how to disable consolidation journal workflowSummary: This is a New implementation and we have enabled workflow for journals during application creation process. However, we would like to disable the Consolidation …
-
Manage OwnershipSummary: We currently had our ownership data (%, control, and method) stored in EDM. On a monthly basis we pull an extract out of EDM and import it manually into FCCS. D…
-
Restrict system administrator from posting and approving journalSummary: Restrict system administrator from posting and approving journal Content (please ensure you mask any confidential information): Hi There, Is there a way we can …
-
Can we setup Rate Overrides as Periodic even if the Default Translation is YTD?Summary: Actual Requirement: The requirement is to load YTD TBs to the FCCS application and the same to be translated on the YTD Exchange Rates. Doing the same in FCCS a…
-
units * price in FCCSI'm familiar with Essbase and Planning but now I'm struggling with the setup up a units * price mechanism in FCCS. Both units and price are inputs, the revenue total sho… -
Foreign currency sensitivity calculationSummary: I want to calculate the impact when currency rates increase or decrease by 5% on income before tax. How to do that? Content (please ensure you mask any confiden…
-
How To - Writing Efficient Essbase IF StatementsSummary: This article describes how to write efficient Essbase IF statements, involving Essbase metadata and data conditions. Content (please ensure you mask any confide…
-
How to load parent member (store data type) with dynamic cal children account?Summary: I did integration from FCCS to PBCS but always failed to load parent member (store data type) with dynamic cal children account. FYI In FCCS the parent account …
-
How To: Design Consolidation Calculation Status Reports using Reports ModuleSummary: This tip depicts steps to design a Consolidation Calculation Status Report using FCCS Reports module Content (please ensure you mask any confidential informatio…
-
VBA trigger FCCS business rule, cannot pass entity and period parameter in to the business ruleSummary: VBA trigger FCCS business rule, cannot pass entity and period parameter in to the business rule Content (please ensure you mask any confidential information): W…
-
VBA trigger FCCS business rule, cannot pass entity and period parameter in to the business ruleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Report with Tbs and journal description detailsSummary: I have been asked to develop a report, where in the rows there is the information at accounting account level, in the first column the Tbs entries and in the fo…
-
FCCS report grid layout change to "Right to Left"Summary: Hello All - we have a requirement to publish a report in hebrew which reads "Right to left " . Can we do it in FCCS->Report->Grid? Content (please ensure you ma…
-
How to handle opening balance in new sub consolidationI try to create a new sub consolidation. Original structure A |------A1 |------B1 |------B2 New structure A |------A1 |------B |----B1 |----B2 After consolidation, the "…
-
FCCS Web Form - P#@Cur(-1) like in HFMHello, in HFM we can use the function P#@Cur(-1) in the web form. Using P#@Cur(-1), if we select the first period of the year (January) we are able to see the Previous P…
-
Can we create a data source element to be used for contribution adjustments in Parent CurrencySummary: Content (please ensure you mask any confidential information): Hi all We would like to know if it is possible to create a data source element to be used for con… -
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …