Insertion Points
Discussion List
-
Can configurable consolidation rules be used to copy opening balanceSummary: We have introduced a new parent in between to our existing structure. On consolidating at new parent only movements are rolling over to new parent from old pare…KamalRawat9918 10 views 0 comments 0 points Started by KamalRawat9918 Financial Consolidation and Close -
FCCS - ESSBASE 21 Version UpdateSummary: Hi, I’d like to know if this is in Oracle’s plans (safe harbor), or if any new or updated functions are now available in the November Patch release. Also, what …Guixdx 29 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Recommendations - Hybrid calculation scripts FCCS_10Summary: Hi, I'd like to confirm if there are planned enhancements (safe harbor) for Oracle on the Recommendations regarding executing Hybrid calculation scripts in FCCS…
-
Skip Translation is not available in my FCC application Consolidation SettingsSummary: I was expecting to see the Skip Translation config setting for my FCCS application, however this is not available to enable for us. Has anyone else see this? Th…JameyBoozer 112 views 30 comments 0 points Most recent by JameyBoozer Financial Consolidation and Close -
Data for alternate entity hierarchy in equity section is flippedSummary: We created an alternate entity hierarchy. Ownership management and enhanced org by period are turned on. Everything is 100% owned. Some accounts in the equity s…
-
Agg Override ODR to Insertion Point CalcHi, I`d like some guidance from converting this ODR into Insertion point (currently trying FCC_25) Test App Specs: Application DSO (Period - Movement) Main Currency USD …Guixdx 61 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS_10 Closing Balance Input Calc -- QuestionSummary: Hi, I created a test application with the following: I have a question regarding the script below on FCCS_10 for ClosingBalance_input: Closing Balance Input is …Guixdx 51 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Usage of HYBRIDBSOINCALCSCRIPT directive in DSO-based Insertion Point Rules -- QuestionSummary: Hi @Ashutosh Bhatikar-Oracle, Based on the recording below, the Closing Balance on the right-hand side of the calculation triggers a hybrid calculation. Is it c…Guixdx 38 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
USD Translated Currency Calc FCCS_25Summary: Hi, after reading this thread: https://community.oracle.com/customerconnect/discussion/726879/usd-translated-currency-input-journal-not-rolling-up-for-non-usd-p…Guixdx 37 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Add Backs Calculation in FCCS1_0Hi, What's the best pratice for automating Net income Addbacks using FCCS_10 and a specific cashflow adjustment data souce as target ? example: FIX ("Entity Currency") /…Guixdx 41 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Access Exchange Rates & Cross-Rates from Rates cube for calculations of Transaction EffectsSummary: Goal: Calculate transaction effects while pulling exchange rates & cross-rates - independent of entity/parent currency. Seeking best practice in FCCS for access…Bjoern Schumacher 62 views 11 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
How to calculate in future years&periods using on-demand rulesSummary: Hi, we are trying to calculate depreciation and write it into future periods using on-demand calculation. I understood, that by default, a runtimeprompt for Yea…R Abel 14 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
how to Copy FCCS_Retained Earnings Prior into Opening Adjusment from one source to otherSummary: We have a requirement where Retained Earnings Prior from a specific Data Source must be reversed. Data Source "Allocation" everytime a new year starts I need th…Guixdx 82 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS_10 script to write data at parent entity journal inputHi, I am trying to write a FCCS_10 Insertion rule, where I want to allocate 0 as data point where the existing value is "#Missing". This script is running only at FCCS_J…Harshita K 87 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
function @MEMBER(@PREVSIBLING(@CURRMBR("Years")) goes into a loopSummary: Content (please ensure you mask any confidential information): Hi all While using this function: @MEMBER(@PREVSIBLING(@CURRMBR("Years")) EXAMPLE FIX (@RELATIVE(… -
Prerequisites for CONFCALC_Enable_Rate_Amount_OverrideSummary: Hi All, We have requirement to write/copy to data to amount override through configurable calculations. In Order to achieve this, we had to create a substitutio…Ashok1234 261 views 27 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Member formula performance after DSO MigrationHi everyone! I am looking for some advice. We have several member formulas on the Account dimension that we used prior to the DSO migration that used to run less than a …
-
Improve Essbase Hybrid BSO Calculation Script PerformanceSummary: This article provides pointers to improve FCCS insertion points written for Hybrid Essbase. Especially useful for applications using Period and Movement Dense, …Ashutosh Bhatikar-Oracle 353 views 14 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Where FCCS_Percent Min Input cause effects?I am having an impasse with the FCCS Percent Min Input member. I have an entity called Consol - Entity 4, where it is contained in two structures: Consol - Entity 3 and …IgorRaffa 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - how to reverse the opening balance for the closed entityHi, We are having a customized EPU calculation, there was a opening balance for the EPU AC for one specific entity, this entity has been closed. we wanted to reverse tha…
-
validation error: Cannot use restricted dimensions: Currency consolidationSummary: Content (please ensure you mask any confidential information): Hi all I have an urgent query. We had a calc script which was working until now, but we are getti…NK2025 42 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS_50 and FCCS_60 rules are not validatingSummary: We noticed rules that were validated and deployed earlier and now falling on validation. We have created a small code snippet to highlight the error Content (pl…Shawn Paperwala 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Text data on a formula row in Data FormsSummary: There is a Text appearing in a cell on a Formula Row in a Data Form, that I don't know where it is coming from. Content (please ensure you mask any confidential…Ilse De Vries 169 views 41 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Consolidation taking longer time due to script calling in insertion rule FCCS_20Hi All, We are using FCCS DSO application, where business requested to copy data for few accounts from Custom4 top parent member to Custom4 base member. To achieve the b…Sydaiah Mudumala - Invesco 59 views 6 comments 0 points Most recent by Sydaiah Mudumala - Invesco Financial Consolidation and Close
-
Enable the BegBalance as Time Period in Actual ScenarioSummary: Enable the Begbalance member in the Actual scenario Content (please ensure you mask any confidential information): Hello team, We need to enable the Begbalance …CarolinaRodriguez 74 views 4 comments 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
Set Opening Balance in Scenario Budget to Closing Balance of Actual Scenario in P12Summary: By default, FCCS pulls the Opening Balance from the last period of the previous year (P13). However, I need to set the Closing Balance from P12 of the Actual Sc…Bjoern Schumacher 44 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
CreateBlock not working in FCCSSummary: Content (please ensure you mask any confidential information): Hi all we have an issue where the function @CREATEBLOCK is not working and we are not sure why th…NK2025 111 views 19 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS ODR Block Creation IssueSummary: Issue with FCCS ODR Rule for Custom Calculation Content (please ensure you mask any confidential information): We have created the below rule to calculate the C…Karan Varshney 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
@CALCMODE (BOTTOMUP) and @CALCMODE(BLOCK) issue in FCCS insertion rules leads to performance issueSummary: Hi Team, I ran the "Recommendations" feature in FCCS and saw the following: Showing 1 warning out of 1. Line 9: Use @CALCMODE(BLOCK) for member block "Entity Cu…JAGADISWAR-Oracle 94 views 4 comments 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close -
Performance issues with Essbase Calc Script using @CALCMODE(BOTTOMUP);Summary: We hare facing performance issues while executing the following ODR, basically for a single entity takes 22 minutes to complete. There are scenarios in which bu…Ernesto Hassán L. 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close