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
-
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, …
-
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, …
-
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! -
Consolidation Journal report at FCCS_Intercompany eliminationSummary: Can we generate a report at FCCS_Intercompany eliminations as data source under consolidation journals report section Content (please ensure you mask any confid… -
Customize the CICTA redirection in FCCSSummary: Hi Is there any option to customize the CICTA redirection in FCCS? Can we do the redirection based on specific criteria? Thanks in advance. AK Content (please e…
-
Narrative Reporting- How to override a row dimension based on a selectable pov dimension?Summary: I have a custom dimension in the rows of a report. I need to set the row custom dimension based on the year in the pov. For example, If the year selected in the…
-
Unable to copy entries in Oracle FCC to post JV month end entriesSummary: Encountering an error when attempting to copy entries from October to November. The error message states, "You do not have access to the member: Special Operati…