On Demand Rules
Discussion List
-
New Recording Available - Best Practices and Tips PresentationsWe have recently added new best practice content focused on typical issues we have seen in customer applications and implementations in the events area (you can always s…Rich Wilkie-Oracle 3.2K views 16 comments 14 points Most recent by Ashutosh Bhatikar-Oracle Enterprise Performance Management Resource Center -
FCCS Rule is not working as expectedSummary: Hi Team, I would like to copy the "FCCS_openingbalance adjustment" values from one account to another and written rules for the same but still it is not working…JAGADISWAR-Oracle 51 views 5 comments 0 points Most recent by Sai Ch-Oracle Financial Consolidation and Close -
Can you allocation balances across entities in FCCSummary: Have a new client that would like to do allocations across entities in FCC (vs in ERP). Content (please ensure you mask any confidential information): Client wo…Nancy Ackerman 32 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
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 22 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 311 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 41 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 21 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 375 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 81 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 31 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 96 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 41 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 31 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 136 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 48 views 3 comments 0 points Most recent by DISHIL SHAH 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 91 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