On Demand Rules
Discussion List
-
Revenue and cost eliminationSummary: The data for the first line is coming from the TB, however, I need to calculate the second line as margin %. Content (required): Dears, Has anyone faced such a … -
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 …Anand Rasa 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Run Business Rule for All PerriodsSummary: How to Run on demand business rule for all periods Content (required): I want to include business rule that clears budget data for Jan:Dec in a pipeline. Pipeli…Ija Vidaurri 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 11 views 1 comment 0 points Most recent by Omar Shubeilat. Financial Consolidation and Close
-
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 28 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?…yanni vossos 61 views 2 comments 0 points Most recent by Kotak Pramit 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 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…J Mahero L 53 views 10 comments 0 points Most recent by J Mahero L Financial Consolidation and Close
-
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 41 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 41 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 71 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 31 views 2 comments 0 points Most recent by Timestamp EPM Team 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 61 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 31 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… -
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 61 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 41 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 51 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 31 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 51 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 …
-
How To: Execute EPM Cloud Role Assignment Report REST API using FCC On Demand Groovy Business RuleSummary: This example explains steps to create a Groovy Business Rule to execute EPM Cloud Role Assignment Report REST API Content (required): We can leverage Groovy rul…Ashutosh Bhatikar-Oracle 149 views 0 comments 0 points Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Get Correct Goodwill and Minority Interest In Oracle FCCS - Chain Holding Case?Summary: We are Getting Wrong Figures in FCCS Chain Holding Case...USE Case Is Where A owns 30% of C and owns 100 % of B, Plus B Owns 40% in C... Minority and Goodwill a… -
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…Benjamin Moster 161 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close