On Demand Rules
Discussion List
-
Performance Issues with ODRSummary: Need assistance with optimizing ODR. Content (please ensure you mask any confidential information): We have created an On Demand Business Rule in FCCS and it ta… -
ODR not working if entity status is OKSummary: We have written ODR for validation, which is running after completed the consolidation and translation. This ODR is running fine when we triggered it manually. …Narinder Arora-162322 28 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Override value posted at base level entity (Non-U.S.D) does not rollup to Parent entity (Non U.S.D)We are posting Override value at base level entity (Non-U.S. D), the override values are not rolling up to the Non-U.S. D Parent. We need to create an ODR to allow rollu…
-
constant currencySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Kotak Pramit 16 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
Business rule is not working as expectedHi, We have written a business rule but it seems not working as expected, It is running till infinity. Below is the snippet of the rule: SET HYBRIDBSOINCALCSCRIPT FULL; …JyotiSharma 46 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can a script be run to move the ending balance of a prior year between movements account?I am looking to see if a script could be used to move the ending prior year balance (or current year beginning balance) for accounts that gets cleared out in January eac…Edwin Ocasio 25 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
@CALCMODE (BOTTOMUP) and @CALCMODE(BLOCK) issue in FCCS insertion rules leads to performance issueSummary: Hi Team, I ran the "Recommendations" feature in FCCS and saw the following: Showing 1 warning out of 1. Line 9: Use @CALCMODE(BLOCK) for member block "Entity Cu…JAGA - Oracle-Oracle 45 views 4 comments 0 points Most recent by JAGA - Oracle-Oracle Financial Consolidation and Close -
Reconsolidate of historical data for hierarchy changesSummary: We have frequent update for primary hierarchy. When updating hierarchy's we always have to reconsolidate historical data from inception. There was an enhancemen…Divya_Masoodi 22 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
FCCS_Total Equity at parent valueWe have three entities that roll up to the same parent. Total Equity for that parent should only equal the equity of one of the base level entities. However - it should …Casey Kempel 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Performance issues with Essbase Calc Script using @CALCMODE(BOTTOMUP);Summary: We hare facing performance issues while executing the following ODR, basically for a single entity takes 22 minutes to complete. There are scenarios in which bu…Ernesto Hassán L. 24 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Performance issues with ODR ScriptSummary: We are trying to execute the below script but not able to understand how much time it is actually taking to execute. We tried in one period after data load and …JyotiSharma 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Net entities balances because of a splitSummary: Content (please ensure you mask any confidential information): Hi All, We are splitting some entities in our FCC application and to achieve this, we have create…
-
Execute FCCS pre-seeded Business Rules Using GroovySummary This article describes approaches to execute FCCS pre-seeded Business Rules Using Groovy Content Approach – Using Other Web Service Provider Named Connection Nam…Ashutosh Bhatikar-Oracle 189 views 3 comments 4 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Facing issue having error message starting with "You are trying to change the data" after patchSummary: While deploying rules or try opening forms, we are facing below issue in the EPM application after the patch has been updated on Friday. Appreciate your help an…Subramanian Karunamoorthi 84 views 11 comments 0 points Most recent by NarayananS Financial Consolidation and Close -
Value in variables is not reflecting when launching the Business RulesSummary: Created new business rules for FCCS, however, when trying to launch it the value set in Years and Period is not showing in the prompt. Content (please ensure yo…User_ZCB13 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How To: User Variables in Calculation Manager Rules associated with Data FormsSummary: This article helps explain how EPM Cloud User Variables can be associated with Calculation Manager business rules to avoid Runtime Prompt by associating User Va…Ashutosh Bhatikar-Oracle 16 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
@ISATTRIBUTE Shared Entity MemberSummary: I have a custom attribute set up on my Entity dimension and had put code into FCCS_110 to check if the attribute is a certain member before performing a calcula…KimJenkins 1 view 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Discovery Calculation TraceSummary: Hi, Can someone help me to analyse this calculation result of data discovery? Why with the source value missing and rate 16320, the value calculated is -2966928…J Mahero L 54 views 18 comments 0 points Most recent by Jing Xue-Oracle Financial Consolidation and Close
-
Form consolidation is not using members on formSummary: We would like for users to be able to submit data via a FCCS form and for the form to run a consolidation on the specific form members automatically (on submit)…AaronJozef 101 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
On-Demand Rules - Copying Entity Input, Parent Input, and Contribution InputHello everyone, I’m currently working on an On-Demand Rule in Oracle EPM Cloud FCCS and was wondering if anyone can confirm whether this type of rule can only read and w…Bjoern Schumacher 11 views 2 comments 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Calc Script rule is overriding the previous calculationHi, We are trying to write a calculation the calculation manager but it seems when we add the second section (Customer) in the rule first section (Distribution) values a…JyotiSharma 54 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS On-Demand rule not workingSummary: We have written FCCS On-Demand rule its running quite a long time but not resulting. Content (required): This rule as expected to run less than 1 minute. Howeve…Sydaiah Mudumala - Invesco 71 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS On-Demand rule calculation logic not working.Summary: In FCCS On-Demand rule calculation logic not working. Content (please ensure you mask any confidential information): For suppose 3 cells should calculate based …Sydaiah Mudumala - Invesco 31 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
how to get parent member in groovy fccsSummary: We are trying to run groovy rules to run consolidation on the OTPS entity variable and also would like to run consolidation on the parent entity member however …
-
On Demand rule at Parent currency is overridden by ConsolidationHi, We have developed on demand rule to calculate data for few accounts at Parent Currency Level. This rule is working fine and giving expected results. But when we run …Dharanidharan M 31 views 5 comments 0 points Most recent by Dharanidharan M Financial Consolidation and Close
-
i have written rule as TOPDOWN and CELL mode, due to that i am facing performance issueSummary: i have written rule as TOPDOWN and CELL mode, due to that i am facing performance issue Content (please ensure you mask any confidential information): Version (…Narinder Arora-162322 97 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Writing calculation at parent entityHi, We are trying to write a calculation at parent entity, is there any property or attribute we could enable to write the calculation at parent entity? Regards Jyoti Sh…JyotiSharma 11 views 2 comments 0 points Most recent by JyotiSharma Financial Consolidation and Close
-
Sum for 12 months in member formulasSummary: Assistance Required: Dynamic 12-Month Summation Across Current and Prior Years in Member Formula Content (please ensure you mask any confidential information): …Anand Thota 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
User Selection of Multiple Elements from a Dimension for Data FormsFor the presentation of capital consolidation, we always require the paired display of Investor & Investee. These are reflected in the data model as follows: Investment …Bjoern Schumacher 11 views 1 comment 0 points Most recent by Bjoern Schumacher Financial Consolidation and Close
-
Reclass rule not working when Source POV have Parent AccountSummary: I have written a rule to pick the source pov value and past it in target pov, it's working fine when i am using child account but not working with parent accoun…Narinder Arora-162322 11 views 4 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close