On Demand Rules
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 115 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
what is the correct use to perform calculations with the YTD member within an OnDemand ruleSummary: Calculations with the YTD member within an On Demand rule Content (please ensure you mask any confidential information): Hello, We would like to clarify or know…Anderson Florez 11 views 1 comment 0 points Most recent by Pavan-Oracle Financial Consolidation and Close
-
Groovy script:restricting the usage of data load for common dataruleSummary: Looking for solution via groovy in FCCS : if user one has trigger the remote dataload pipline from FCCS for PCMCS then the process should be locked for rest of …Sreekumar Hariharan 31 views 3 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 41 views 3 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
Issue running ODR for entities with a member functionHi All. I am creating an On Demand Rule in FCCS. When created the ODR rule has created automatically prompts for the members of the Entity Dimension (as well as others).…Brian Somers 111 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can a User run a pipelineSummary: Is there any way that a "User" can run a pipeline, removing the dependency on the Service Administrator? Content (please ensure you mask any confidential inform… -
FCCS custom business rule is not working with No error but debug errors out with null exceptionSummary: e are calculating allocation in FCCS using custom business rule. Until yesterday it was running fine but suddenly it is getting executed in very short time with…Rohit_Malani 71 views 11 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
-
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 71 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 203 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 12 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 41 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 291 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 41 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 23 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 23 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