On Demand Rules
Discussion List
-
Representation of IFRS 16 logic in FCCSummary: Is there a recommendation or any experience on how IFRS 16 can be depicted in FCC? In some sources, it is mentioned that SDM was used, while others describe a s…Bjoern Schumacher 12 views 1 comment 0 points Most recent by Omar Shubeilat. Financial Consolidation and Close -
How to mention a IF condition in FCCS for basing on TEXTSummary: Hi Experts, We have a requirement to write IF condition in FCCS Ondemand Rule, saying "IF the account 'XYZ' is having Text as YES". We have tried below but the …
-
Copy data from form Actual to Forecast - Performance issueHello All, in our FCC application we created a specific calculation rule to copy data (in our example Account NSALI and HEADI) from Actual to Forecast scenario. We tried…Alessandra Cappai 22 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Rule to zero out YTD dataSummary: Hello - looking to get help on why this rule is not complete. when account balance is loaded via DM, we'd like that amount to be loaded as Zero (FCCS suppresses…
-
Split Opening Balance of Other Comprehensive Income Balance Sheet AccountSummary: We have detail account of each category of FCCS_Other Comprehensive Income but in FCCS, FCCS_Other Comprehensive Income -> FCCS_ClosingBalance will comes to FCC…
-
Is there a way to copy rate overrides from base level entities to parent ones?hi all, We have rate override inputs, lots of them, that we need to replicate to upper level / parent entities, how can we do that? Is it possible to do so via ODR rule?…ioannisvossos 62 views 2 comments 0 points Most recent by User_3UODH 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 23 views 4 comments 0 points Most recent by JM123456 Financial Consolidation and Close
-
Ability to run custom rules by PowerUserSummary: We want to know if we can assign access to power users in FCCS to run the rule. As per my understanding, currently only service admins can run the rules/custom …Tejesh Mhatre 42 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Best Practices for using Dynamic Calc in Accounts for FCCSSummary: Hello Experts, We have created about 2000 dynamic calc accounts with member formulas as we needed to categorize the balances to multiple accounts based on produ… -
Groovy Data Validation run before save for certain hierarchy of memberSummary: How to validate amount before save using groovy script for certain member of hierarchy? I have account hierarchy like this: It doesn't work when i used ilvl0des…
-
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
-
EPM CLOUD - FCCS FORMS IMPLEMENTATIONEPM CLOUD - FCCS Version 23.07.62 Basically, with our current implementation for FCCS we have forms implemented and to be able to review and clear validation from all th…Mubeen_Baig4105 32 views 1 comment 0 points Most recent by Mubeen_Baig4105 Financial Consolidation and Close -
Rolling Sum in Member formulaSummary: 12 Months rolling sum to be calculated in member formula Content (required): Require a member formula that calculates the prior 12 months' value, Current month …Suman Auddy 34 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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 72 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Force Consolidation response from rest api returned error but in jobs returned successContent (required): We create a costum business rule where we are using groovy and rest api to run forceConsolidation and others rules. But when we run the forceConsolid…Timestamp EPM Team 32 views 2 comments 0 points Most recent by Timestamp EPM Team Financial Consolidation and Close
-
Allocations in FCCSummary: Content (required): Hi, Has anyone built an allocations process/rules in FCC? We're evaluating a customer request to perform some fairly basic allocations of sh…
-
Using Calculation Manager Templates in FCCSummary: Calc Manager Templates cannot be directly deployed in case of FCC. Workaround is to add the template to a On-Demand Rule (ODR) and then deploy the ODR. Content …Ashutosh Bhatikar-Oracle 22 views 0 comments 1 point Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can I create a Groovy template incl designed prompt and groovy rule to use it in data forms?I've tried to build a template incl groovy rule in FCCS. There is a step by step manual from Oracle for Planning. At the end the template incl rule hast to be deployed a…Bjoern Schumacher 52 views 3 comments 0 points Most recent by Ashutosh Bhatikar-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
-
Can you have more than one Net Income Rule-Set that utilize different basis and redirection accountsSummary: Is it possible to have more than one configurable rule for the Net Income Subsidiary Rule-Set. We would like to have each new rule set utilizes a different basi… -
Shared entity members and rules - rules only runs for primary memberWe have a couple of rules in the main consol rules which should only run for certain entities. To do this we added an if statement for the entities for example, IF (@ISM…EmmaPa 32 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Why is HSP_Submissiongroup causing an error?Summary: Trying to build a calc into FCCS_10 business rule. Whe validating I get an error saying to specify a member from the hsp_submissiongroup dimension. Where is thi…DilanSmead 42 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
i have to deploy rule for correct data, why?Summary: Content (required): to obtain a correct result, i need to deploy de rule before consolidate, if I consolidate without deploying the rule, the result is not corr…VicFlores 32 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is it possible to provide launch access to a ruleset but none of the constituent rules?Summary: Is it possible to provide launch access to a ruleset but none of the constituent rules? Content (required): We have some rulesets that users run, but sometimes …Matt Maurer 22 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Running translation within an on-demand rule?Summary: Is it possible to run translation within an ODR? Content (required): I am trying to create a rule that relies on data being translated after certain other calcu…Matt Maurer 42 views 4 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close
-
Rules with no period relatedHi Experts, I need your help. Need to create a calc that its not related to the period, normally we use BegBalance member, but in FCCS the rule is sending an error when …Mayela Duque 32 views 3 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Using @CREATEBLOCK on FCC DSOSummary: Content (required): Dear All, I noticed that @CREATEBLOCK is supported on FCC, I saw that on documentation. Is it available in FCC DSO, too? It seems the @creat…Gianluca Natili 52 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close -
Sample groovy script to export aggregated FCC dataSummary: Sample groovy script to export aggregated FCC data Content (required): I am trying to write a groovy script to export aggregated data from FCC for an interface …