Insertion Points
Discussion List
-
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 114 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 36 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 23 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 42 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 32 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 63 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 62 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 315 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 32 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 32 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 132 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 73 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 102 views 6 comments 0 points Most recent by ericerikson Financial Consolidation and Close
-
We have a rule to copy data from Income Statement Intercompany account to Balance Sheet IntercompanySummary: We have a rule in F10 to copy data from Income Statement Intercompany account to Balance Sheet Intercompany account and specific movement, the rule is working f…MRAO 51 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Help!! How to troubleshoot? Where can I find that webcast? What's New? Don't panic, it's all in hereI totally get it, the community can sometimes be overwhelming. A lot of great content is available, but where do I find it, what to look for, how do I search? Should I u…Michel Schoolenaar-Oracle 401 views 0 comments 12 points Started by Michel Schoolenaar-Oracle Financial Consolidation and Close -
Code behavior with FCCSImpactStatus troubleshootSummary:Not understanding results received with block of code using FCCSImpactStatus Content (required): Overall goal is consolidate Actual, impact status of target scen…Scott Rodney 42 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS_REC OBFXCTA is displaying incorrect signageSummary: We have come across an issue in FCCS_REC OBFXCTA account , Oracle has confirmed it as a bug. Issue : - Seeded account FCCS_REC OBFXCTA is displaying incorrect s…Rao_FCC 76 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close