On Demand Rules
Discussion List
-
Calculate Average Exchange rate in FCCSSummary: Is there any way to calculate Average Exchange rate input value through a calculation logic(average of Cumulative Ending Exchange rate) Content (please ensure y…Venkatraj Bhat 95 views 4 comments 0 points Most recent by Harpreet Singh Arora Financial Consolidation and Close -
On-Demand Rule not workingSummary: Hello, We need an on-demand rule to pull a balance from one intersection and post it to another and I can't get it to work. I am not an expert at rules, so any …K McMillan 44 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Elimination causing issue in account primary and shared hierarchy comparisonSummary: Hi, We have one primary hierarchy for trade receivable and another statistical hierarchy where we are sharing the primary hierarchy account members We are compa…JyotiSharma 22 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
MDSHIFT not working in FCCSSummary: Is MDSHIFT supported and has anyone got it working in FCCS? Content (please ensure you mask any confidential information): Is MDSHIFT supported and has anyone g…Narayan 71 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Block Creation Issue in ODRSummary: When we are trying to copy from consolidated top entity(CONSOL_ENTITY) to one base entity STAT_Total for few Stat account and stat profit centers from source we…Hem Palariya 22 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Adjustment for unrealized profit or lossSummary: Post of the Investment and result of the holding company Content (please ensure you mask any confidential information): Hello, We are analyzing the adjustment o…CarolinaRodriguez 42 views 1 comment 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
Set Opening Balance in Scenario Budget to Closing Balance of Actual Scenario in P12Summary: By default, FCCS pulls the Opening Balance from the last period of the previous year (P13). However, I need to set the Closing Balance from P12 of the Actual Sc…Bjoern Schumacher 42 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Use Groovy to run business rule for Consolidation and TranslationContent I'm trying to use groovy to automate the data load and translation process. However, I can't find effective way to run the FCCS Translate business rule. I try to…
-
Prolonged Execution Time of a Ruleummary: Prolonged Execution Time “FccsFormStatusProcessor” Rule Content (please ensure you mask any confidential information): Hello, We have the following concern: When…CarolinaRodriguez 41 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
ODR failed with an errorSummary: Our ODR is failing with an error when run manually. We have been live since two years and we never had this issue. The rule runs fine sometimes and sometimes it…Amarnath_Kothapalli 11 views 2 comments 0 points Most recent by Amarnath_Kothapalli Financial Consolidation and Close
-
Groovy error - Cannot run business rules which contain run-time prompts during form load.Summary: Groovy not working for power user Content (please ensure you mask any confidential information): I have added a simple groovy for "read only" in data form. As a…Jai Prakash 18 views 2 comments 0 points Most recent by Jai Prakash 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 6 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Journal Action REST API - Error when Journal Label contains spacesSummary: Error performing journal actions via REST API to journals with labels containing spaces Content (please ensure you mask any confidential information): I've crea…Shane Rooney 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 58 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 1 view 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 12 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 201 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 1 view 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 24 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 62 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 12 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 21 views 3 comments 0 points Most recent by Lakshmi V-Oracle 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…Kotak Pramit 11 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 32 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 78 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 53 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