On Demand Rules
Discussion List
-
Elimination rule based on a specific condition in FCCSSummary: We have a requirement to eliminate some amount on the basis of a specific condition: The sum of Entity's data with ICP and ICP's data with Entity -> if it is le…Aditya Mehta 31 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Loading data using YTD_Input and Clearing opening Balance of next year with Rules.Summary Loading data using YTD_Input and Clearing opening Balance of next year with Rules.Content Hi, Im doing some testing by loading data using YTD_Input. Im getting Y…s k-140383 88 views 7 comments 0 points Most recent by Tjeerd Huisman 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…Hari Jetti 65 views 2 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
@CALCMODE(BOTTOMUP) increases Translate timeWe have used FCCS_10 and FCCS_20 rules to calculate / reclass some of the movement members for cashflow reporting and the Translate is taking around 30 minutes per perio…Hem Palariya 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How To: Check if Member Already exists in a DimensionSummary: Today, in FCCS or for that matter any EPM Cloud service that uses Essbase, when we try to create a member in a dimension, and if it already exists, then dimensi…Ashutosh Bhatikar-Oracle 169 views 0 comments 1 point Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS block creation issue in custom ruleSummary we are having block creation issue in a custom rule within FCCS application. Please review the below code and suggest. Content (please ensure you mask any confid…Rohit_Malani 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 43 views 2 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy Helper Functions to Execute an EPM Cloud Job and Poll For its StatusSummary: This discussion provides a couple of Groovy based helper methods that could be added to a Groovy based business rule to execute an EPM Cloud job. Content (requi…Ashutosh Bhatikar-Oracle 300 views 3 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
USD Translated currency input journal not rolling up for Non USD Parent entitySummary: We posted a Translated Input currency journal in USD at a Non-USD entity. While running Translation and consolidation, it is not rolling up to its Non-USD paren…ShubhamV 143 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How do I calc a default movement based on a #missing value of "Closing Balance - Input"?Content From the info tab of the calculate movements section of the local currency consolidation step: If a data-point for which a closing balance was previously entered…JoachimB 94 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
ODR Block creation issue using Member FunctionsSummary: ODR Block creation issue using Member Functions: Hybrid application with DSO Block gets created with below code when ran for individual entities but when runnin…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 31 views 0 comments 0 points Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - On Demand Rule Best Practice: Avoid IF condition check on Entity dimension.Summary: This article explains best practice related to avoid IF condition checks on Entity dimension Content (please ensure you mask any confidential information): In F…Ashutosh Bhatikar-Oracle 31 views 0 comments 1 point Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Rule warning errorSummary: Any insight on the following warnings will help to understand the FCC behavirour. Also, any reference for standard rule writing practice. Content (please ensure…AlokPriyadarshi-Oracle 71 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 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?…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 51 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 61 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 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 31 views 2 comments 0 points Most recent by Timestamp EPM Team Financial Consolidation and Close