On Demand Rules
Discussion List
-
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… -
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. 9 views 0 comments 0 points Started by Ernesto Hassán L. 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 4 views 0 comments 0 points Started by Divya_Masoodi 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 …
-
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 12 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 81 views 11 comments 0 points Most recent by NarayananS Financial Consolidation and Close -
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… -
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 19 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 12 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 3 views 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 53 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 105 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 14 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 53 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 75 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 32 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 35 views 5 comments 0 points Most recent by Dharanidharan M 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…
-
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 96 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 22 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 12 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 12 views 4 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close
-
Overrides not working in alternate hierarchySummary: When override is entered at base entity using the FCCS_Amount Override consolidation member, where there are alternate entity hierarchies, the shared hierarchy …Larry Amato 28 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Best process for overrides when there are multiple hierarchies?Summary: We have multiple hierarchies for entity where the parents in the shared hierarchy may have a different currency. Was wondering if there was a solution other tha…Larry Amato 44 views 3 comments 1 point Most recent by Larry Amato Financial Consolidation and Close
-
How to migrate the custom rules in deployed state?Summary: How to migrate the custom rules in deployed state? and if that is not possible, how to select multiple rules and deploy them at once? Content (please ensure you…Harshith J Rao 42 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
We've successfully run a consolidation; however, the data does not roll up and impacted calculation.Summary: Hi All, We've successfully run a consolidation; however, the data does not roll up, and the calculation status is impacted. What am I missing? Thank you. Regard…