On Demand Rules
Discussion List
-
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 54 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 64 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 73 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
-
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 63 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 153 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…Ben Moster 161 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Nested FIXPARALLELs in FCCSHi All, I'm trying to use a FIXPARALLEL within an ODR in FCCS. It passes validation in calc manager but when I run it I get:- "Cannot calculate. Essbase Error(0): FIXPAR…Brian Somers 44 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCC DSO Converted Rule Not Creating BlocksSummary: FCC DSO Converted Rule Not Creating Blocks Content (required): FCC DSO Rule Not Creating Blocks. The original rule non-DSO was updated for DSO by adding @CALCMO…Ija Vidaurri 111 views 4 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close -
FCC DSO Dynamic Calc Formula does not workSummary: FCC DSO Dynamic Calc Formula does not work Content (required): We have dynamic calc formula in non-DSO environment: Corp_Expense="Direct_Expenses"->"Corp_Exp"; …Ija Vidaurri 61 views 3 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
FCCS: Dataset for configurable rules does not display VIew DimensionSummary: Hi all We have a customer for which we do not see the View dimension displayed under DataSet Configurable rules. Can someone let me know what are the conditions… -
Fantom rules/jobs running in background in FCCSSummary: Content (required): Very strange ocurance: For the last week since we cloned our FCCS environment to the new Gen2 instance on, I've noticed that certain jobs ar…
-
"An unknown error occurred when executing the script."Hi All, I'm trying to run an ODR groovy script which creates a calculation script and returns the string to essbase to execute. When we run this it returns the error "An…Brian Somers 236 views 2 comments 1 point Most recent by Brian Somers Financial Consolidation and Close