On Demand Rules
Discussion List
-
How To:Debug Essbase Solve Order InaccuraciesSummary: Article describes how On Demand Rule can be used to investigate Solve Order Conflicts which lead to incorrect values in Member Formulas. Content (please ensure …Ashutosh Bhatikar-Oracle 26 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Block creation issue in custom ruleHi, We have one custom rule in FCCS where we are facing Block creation issue. We have to do the calculation at "FCCS_Amount Override" consolidation dimension member and …JyotiSharma 305 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
default movement issue on retained earnings priorSummary: default movement now calculating on no intercompany intersection for retained earnings prior account for FY24 when it has never done this in prior years - anyon…Lynda G 61 views 8 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
FCCS does not take up journals with currency other than its entity currency and parent currencySummary: Cross entities journals with different parent currency required. How to handle? Note: Standard behavior for Translated Currency Input cannot help. Content (plea…Vani-Oracle 43 views 2 comments 0 points Most recent by Vani-Oracle Financial Consolidation and Close -
Why it is required to run translation after force consolidation?In case of one of our client, data till Dec-23 was translated and consolidated. Then to resolve a issue, we ran force consolidation for Dec-21, Dec-22, Dec-23. However, …Vidhi Nenwani 28 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Does UDA for Account dim predefined per account types? it is not explicitly listed on propsSummary: @UDA("Account","Expense") and @UDA("Account","Revenue"), I do not see UDA assignment in the properties but this function is working Content (required): Does FCC… -
Essbase BSO Block Limits Calculator Utility.Summary: This utility helps check if Essbase block limit is hit, even before refreshing database. Content (please ensure you mask any confidential information): Inspirat…Ashutosh Bhatikar-Oracle 360 views 0 comments 9 points Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
User versus power user access in fcc data formI have a client who has a data form with a business rule attached to only run for a particular sub variable. The rule works fine for Admin users, power user but not for …
-
We are not able to create one ICP P&L Knockoff rule on the YTD basis in FCCSIn HFM, there is one rule for ICP P&L Knockoff which happens on YTD basis as per HFM Functionality. We tried to do the same in FCCS, but not able to, due to the Periodic…Aditya Mehta 44 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
How To: Get Current EPM Cloud VersionSummary: This article helps to retrieve current EPM Cloud version without using Help -> About UI. Content (please ensure you mask any confidential information): There is…Ashutosh Bhatikar-Oracle 81 views 3 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Ashutosh Bhatikar-Oracle 49 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Consolidate Job -Receiving Error-see belowHello - Anyone know what this error indicates and how it can be fixed during the consolidate job? We are using BegBalance as first period. Please assist. A method called…
-
FCCS Rule-Net Income (Equity) cannot limit the loss to the amount of investment cost- Joint VentureSummary: Accounting for Joint Venture (JV) using Equity method. The share of loss cannot exceed the investment cost as the Joint Venture is a limited company. The standa…Vani-Oracle 36 views 1 comment 0 points Most recent by Pavan-Oracle Financial Consolidation and Close
-
FCCS Copy All Data from One Scenario to Another ScenarioSummary: My Client would like to copy all data from One Scenario to Another Scenario as a snapshot. Copy base member then run consolidation is not an option. After revie…Joseph Ip - Oracle-Oracle 97 views 1 comment 0 points Most recent by Joseph Ip - Oracle-Oracle Financial Consolidation and Close -
Imported Rule not appearing in calc managerSummary: I imported the rule through migration in FCCS and it was successfully imported but when I go to Calc manager to check the rule, the rule does not appear on that…Pooja Jain 37 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we push data from one scenario to another scenario in FCCS using on demand rule?Summary: Client needs to modify the actual scenario data for few accounts and then push it to different scenario in FCCS. Whether that can be achieved by using on demand…Harshith J Rao 37 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 141 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 16 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 35 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 46 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 119 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 78 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 77 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 38 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 93 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 90 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 24 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 222 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 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close