On Demand Rules
Discussion List
-
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 354 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 41 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 70 views 3 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Ashutosh Bhatikar-Oracle 41 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 32 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 93 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 33 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 34 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 132 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 32 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 43 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 113 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 72 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 75 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 33 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 89 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 78 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 22 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 216 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 44 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 298 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 201 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 97 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