Insertion Points
Discussion List
-
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 59 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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…
-
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 239 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 313 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 22 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 38 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 37 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 158 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 54 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 77 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 42 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 112 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 12 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 78 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. 22 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is it possbile to check ICP ownership percentage and then generate Related party transactions.Summary: Customer wants to check the ICP ownership method and then apply 1- ICP ownership percentage to generate the related party transactions Content (please ensure yo…Vishal Pinakin Vora 251 views 15 comments 0 points Most recent by Vishal Pinakin Vora Financial Consolidation and Close
-
Missing blocks for customized CTA calculationSummary: We created a customized calculation in insertion rule 30 to calculate the CTA accounts per client request. These CTA accounts use UDA "CTA" to mark them, and th…
-
@ISATTRIBUTE Shared Entity MemberSummary: I have a custom attribute set up on my Entity dimension and had put code into FCCS_110 to check if the attribute is a certain member before performing a calcula…KimJenkins 3 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy script differences between FCCS and EPBCSSummary: Content (please ensure you mask any confidential information): Hi All I would like to know if Groovy scripting has more Custom Groovy Scripting with Planning th…
-
How to trace the data input mechanismSummary: Hi All, Are there any ways in which we can trace whether the data for a particular member has been uploaded directly through forms / Smart View / Data Integrati…Vipusha Chandrakumaran 23 views 5 comments 0 points Most recent by Rahul G.-Oracle Financial Consolidation and Close
-
Issue with FCCS Create Block for Opening Balance AdjustmentSummary: Hello All - I need to copy the Opening Balance into Opening Balance Adjustment from one entity to the other. I see my script is not creating the block and check…Hari Jetti 45 views 20 comments 0 points Most recent by Pranab Kumar-279997 Financial Consolidation and Close -
Data copy via script on data source members type journalSummary:Desire to move actuals into constant currency and forecast scenarios. I could perform this by using a copy data profile, but it would nice to not actually have t…Scott Rodney 61 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Reverse the OpeningBalance entriesSummary: Reverse the OpeningBalance entries Content (please ensure you mask any confidential information): We're using the Insert rule (FCCS_10) to reverse the OpeningBa…ApOK 22 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
New Recording Available - Best Practices and Tips PresentationsWe have recently added new best practice content focused on typical issues we have seen in customer applications and implementations in the events area (you can always s…Rich Wilkie-Oracle 3.1K views 16 comments 14 points Most recent by Ashutosh Bhatikar-Oracle Enterprise Performance Management Resource Center
-
Can you allocation balances across entities in FCCSummary: Have a new client that would like to do allocations across entities in FCC (vs in ERP). Content (please ensure you mask any confidential information): Client wo…Nancy Ackerman 22 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Is it possbile to write IF condition based on intercompany ownership method in FCCS insertion rulesWe have requirement to calculate data only if Intercompany has specific ownership method. We are able to write condition based on entity ownership by using below script.…Hareesh Ganji 71 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Historic amount override not calculating after loading value through ruleSummary: Historic amount override is loaded in 'Jun'. With FCCS_20 rule we are populating '0' in 'Jul'. After consolidating 'Jul' is not translating correctly. Content: …Shawn Paperwala 173 views 23 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close