Insertion Points
Discussion List
-
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 21 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 171 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 115 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 41 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 71 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 52 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 43 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 31 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…
-
How to run ODR ruleson all stored Consolidation dimension members and Entity & Parent CurrencySummary: How to get Cash Flow calculated on all stored Consolidation dimension members and Entity & Parent Currency using ODR rules? Content (required): We need to run C…Ahmed Kcharem 61 views 4 comments 0 points Most recent by Ahmed Kcharem Financial Consolidation and Close
-
Data discovery not creating notes attachment in the formSummary: Hello Gurus, I am using data discovery to trace my value populated in a combination. Post to execution of Data Discovery in Data form, I am unable to see the No…
-
Is it possible to copy one scenario to another, including performing math on source data?Summary: Copying Scenario A to Scenario B, with Scenario B's data being scaled/rounded to thousands. Content (required): I have a DLR to load data to Scenario A. I would…SAW23321 71 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS_110 rule to load 0 in place of #missingSummary: Need to write a config consol rule to replace #missing values with 0 Content (required): DSO application. I'm running into a variant of the issue where an accou…SAW23321 311 views 20 comments 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Write in Reporting CurrenciesHi Experts, I have an urgent question. I need to eliminate data that FCCS create by default, there is a way to write in the Reporting Currencies with rule? I really appr…Mayela Duque 31 views 4 comments 0 points Most recent by Mayela Duque Financial Consolidation and Close
-
Copy Parent Data in on Scenario to a Base Level Member in another ScenarioSummary: I am trying to copy data at a parent level (entity, custom dimensions, etc.) to a base level entity in another scenario in FCC. This could be in an on-demand ru…Ben Moster 161 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Disable default RollforwardSummary: we want have our own Rollforward and disable default Rollforward that happens in FCCS Content (required): Account AC_100 should not roll to AC_100 in the new pe…BHARGAVA NADENDLA 34 views 2 comments 0 points Most recent by BHARGAVA NADENDLA Financial Consolidation and Close
-
Unexpected results after converted a rule for DSOSummary: Content (required): Hello, I converted my application in Period and Movement dense dimensions. I need to edit my rules for the new setting. I'm having a problem…Gianluca Natili 71 views 5 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close
-
No Input rule/optionSummary: client is moving from HFM to FCC and currently "locks" data by adding the completed year to a No Input rule - is this available in FCC? Content (required): Is t…Nancy Ackerman 131 views 10 comments 0 points Most recent by David Corredera at DTT Financial Consolidation and Close
-
FCCS SCRIPT helpSummary: Hi Team We are currently looking at the following script and are having issues making the entity member highlighted below dynamic. This is because in FCCS when …Alok Vinod Jha-232132 71 views 6 comments 0 points Most recent by JoachimB Financial Consolidation and Close
-
Creating a custom insertion point rule to replace OOB Balance the Balance Sheet ruleSummary: Custom Insertion Point Rule to Balance the Balance Sheet Content (required): Looking for the script for a custom rule to Balance the Balance sheet. This rule wo…CPynn-Oracle 41 views 2 comments 0 points Most recent by CPynn-Oracle Financial Consolidation and Close
-
Why would the "Suppress Invalid data" selection not be enforced on a data form?Summary: Invalid data is still appearing on the data form, despite having enabled "Suppress invalid data - rows". Content (required): We created a data form with valid i…Allison McAllister 21 views 6 comments 0 points Most recent by Allison McAllister Financial Consolidation and Close
-
YTD Closing Balance - Replace Mode IssueHi, We are loading LTD balances to Closing Balance Input at YTD Input member. The fiscal calendar is Jan - Dec. When we load the TB for Jan FY22 at YTD Input at Closing …Shantanu Singha 101 views 6 comments 0 points Most recent by ericerikson Financial Consolidation and Close