Insertion Points
Discussion List
-
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 2 views 1 comment 0 points Most recent by Karan Varshney 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…JAGA - Principal Analyst-Oracle 45 views 4 comments 0 points Most recent by JAGA - Principal Analyst-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. 24 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 242 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 1 view 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…
-
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 154 views 15 comments 0 points Most recent by Shawn_Paperwala 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…Nkehli 72 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 187 views 8 comments 2 points Most recent by User_30Z7I Financial Consolidation and Close
-
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 21 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 41 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 63 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 21 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 2.9K views 16 comments 13 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 23 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
-
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(…
-
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 132 views 23 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Retrieve Entity currency in Essbase RulesSummary We need to obtain the entity currency of the current entity being processed to compare that against a list of currencies.Content In HFM you could extract the cur…Brian Butler 85 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to refer prior year last period in Calc manager for writing ruleSummary: How to refer prior year last period in Calc manager for writing rule in FCCS application Content (please ensure you mask any confidential information): Hi Exper…DISHIL SHAH 31 views 3 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
FCCS_20 rule - Not calculatingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 24.01.36 Code Snippet (add any code s…
-
Custom Calc Script not workingSummary: I am calculating Min Interest as follows in FCCS_20, it's not giving any result. I tried the debug mode, but it failed with this message: Calc Manager Calc Scri…ApOK 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Block issue running on-demand rule to copy entity data to anotherSummary: Using on-demand calculation script to copy data from one entity to another. Calculation not running because of missing block Content: "Entity_A" has data in "FC…Shawn_Paperwala 51 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…Ashutosh Bhatikar-Oracle 33 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Translating Opening Balance Adjustments with Local Rate - FCC 30 Insertion RuleSummary: Local rates not getting picked-up in rule while translating opening balance adjustments Content (please ensure you mask any confidential information): FIX ("Par…YogeshKJain 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Correct Usage of Essbase Member Set FunctionsSummary: This article explains correct usage of Essbase Member set functions @LEVMBRS, @GENMBRS, @ISLEV and @ISGEN Content (please ensure you mask any confidential infor…Ashutosh Bhatikar-Oracle 25 views 0 comments 0 points Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to replicate a Custom Calculation from HFM in FCCS?Summary: We are reviewing a migration for a customer who is currently using HFM and would like to use FCCS. It was identified that in this client there is a customized a…Rafael A. Bianchi 61 views 5 comments 1 point Most recent by Unknown Financial Consolidation and Close
-
Insertion Point Calculation Will Not Run on Certain EntitiesSummary: We have been working with an Oracle Partner to develop and run a custom insertion point calculation to complete some of our standard GAAP entries, but we have h…Lance Howell 111 views 11 comments 0 points Most recent by Lance Howell Financial Consolidation and Close
-
Degradation performance for consolidate holding entitySummary: In my understanding, if i run consolidation rule for parent entity it should run all idescendants of that parent member. But in my case if insert some insertion…