On Demand Rules
Discussion List
-
Do we have any working example of FCCS CTA/CICTA calculation logic?Summary: Customer is looking for CICTA and FX movement calculation logic. Do we have any OBE (Oracle by example ) which explains system logic. Any links to for all syste…
-
Minority Interest Calculation for a specified entitySummary: Hi All, Good Day! How do we configure the minority interest calculation for a specific entity without modifying the entity structure? We have tried the calculat…Feluche 54 views 2 comments 0 points Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close
-
Can we use FCCS Seeded member in Calculation manager?Summary: We have written a rule for calculating the Retained Earning as TOP Down approach. Under this rule , we are using the FCCS_Net Income account with other accounts…Narinder Arora-162322 11 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
We have one to setup a tolerance limit for for Entity which is working for FY24 but not working FY25Summary: we have written a global rule to copy tolerance limit for all entities on the basis of UDA from one of Dummy Entity. we submitted a through webform in dummy ent…Narinder Arora-162322 2 views 1 comment 0 points Most recent by Narinder Arora-162322 Financial Consolidation and Close
-
Business rule is not working in selected scenariosSummary: Hi, I am trying to run a rule but it seems its not working properly in all the scenarios like data is not being calculated for few of the account members. There…JyotiSharma 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
User should not input data in data form if consol process is running in FCCSHi All, Can we retrieve consolidate job status in calc script? on the basis of current status we want to restrict user to input data in data form. or pls suggest if we h…Shalini_CTS 205 views 21 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS_20 rule taking time in Consol runHi, Below is the customized script written for Cash Flow purpose and it is deployed in FCCS_20 rule. Because of which the Consol time has significantly increased by 18 m…T Hussain Kumar 2 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
hiding RTPs in FCCS custom business ruleI am seeing strange behaviour in FCCS custom rule. Whenever we create business rule Default RTPs(Consolidation/Currency/Entity/Period/Scenario/Years) are created automat…SrikanthReddy-Oracle 26 views 4 comments 0 points Most recent by SrikanthReddy-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 67 views 17 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS ODR Block Creation IssueSummary: Issue with FCCS ODR Rule for Custom Calculation Content (please ensure you mask any confidential information): We have created the below rule to calculate the C…Karan Varshney 14 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 22 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 12 views 1 comment 0 points Most recent by Chansouda-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 35 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…JAGADISWAR-Oracle 55 views 4 comments 0 points Most recent by JAGADISWAR-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 51 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 12 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. 23 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 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 247 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 82 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 55 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 2 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 126 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 15 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 52 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close