On Demand Rules
Discussion List
-
Groovy Example - ReclassificationSummary How to ReClass data using groovy rulesContent Hello FCC Community, For long, FCC has supported essbase calc script based Configurable Calculations (insertion poi…Dheeraj Anand-Oracle 104 views 1 comment 0 points Most recent by Rich Wilkie-Oracle Financial Consolidation and Close -
Historical Amount Override but elimination is not run for translated currencyContent I am trying to run elimination on historical amount override account. The override account is an intercompany account. However, the elimination is only run on "E…Ryan Li 37 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
On demand rule data blocksSummary Attempting to replicate an allocation script from HFM in FCCS, doesn't quite workContent Cheers all, In my new FCCS app trying to replicate a rule from HFM that …Scott Rodney 46 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Using Substitution Variables in Data Exchange FilesSummary Using Substitution Variables in Data Exchange FilesContent Hi- Is there a possibility to use substitution variable as a suffix in Data Exchange output files? We …Amit Agarwal-158816 45 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS: How to ommit / exclude a section of the FCCS_XX rule if the ownership changesContent Hi all We want to run a rule ONLY if the ownership method is NOT NOTCONSOLDATED. Basically to run based on Consolidation Method used. I cannot find an example of… -
On Demand Rule to Update Reporting Currency (****_Reporting) MemberContent Have anyone been able to update calculation result at reporting currency (****_Reporting) member at level 0 entity? There is a ask from Client to remove the amou…
-
Member Formula equation adding MovementContent Hi All, I am trying to get a pretty straight forward math equation to work as a member formula. I have created a stat account and would like to simply take (FCCS…Preston Oakes 25 views 2 comments 0 points Most recent by Preston Oakes Financial Consolidation and Close -
Using groovy in ODR ruleContent Hello All, I would like to know if it is possible to use Groovy script on FCCS ODR I am trying but I am not able to select the groovy script option on the rule. …Gianluca Natili 37 views 4 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close -
Invalid Syntax - Not a CALC commandSummary Invalid Syntax - Not a CALC command [@REMOVE]Content - I am working on creating a Calc that creates a block when FCCS_TotalOpeningBalance = FCCS_ClosingBalance t…Preston Oakes 249 views 3 comments 0 points Most recent by Preston Oakes Financial Consolidation and Close
-
FCCS Application (Data Management) - Source System > Configure Source Connection (WEB Service URL ChSummary FCCS Application (Data Management) - Source System > Configure Source Connection (WEB Service URL Changed)Content Hi Experts, It has been observed early this wee…
-
Round ReportSummary Rounding ProcessContent After completing the consolidation process, for reporting purposes, we need to apply a rounding at the account level. Not only applying s…Carolina Rodríguez Fleming 59 views 3 comments 0 points Most recent by Carolina Rodríguez Fleming Financial Consolidation and Close
-
Run an On Demand Business Rule before a data load in Data ManagementContent Hi all, Is there anyway in DM to schedule Run an On Demand Business Rule before a data load in Data Management? Best, yannisyanni vossos 43 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to prevent the launch of a Consolidate ruleContent Hello All, I'm looking for a solution that can prevent a rule from being launched unless another rule has been launched first. For all the necessary calculations…Gianluca Natili 45 views 6 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close
-
Execute with a click ODR rule and the Consolidate ruleSummary Find a solution to run an ODR rule together with a consolidate ruleContent In my application, to complete a consolidation process, Users need to run an ODR rule …Alberto Parisella 46 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Issues with aggregated members in the consolidation processContent Hi, in the FCCS standard, within the FCCS_10_After Opening Balance rule, I would need to insert the calculation of an indicator. This calculation contains within…Alberto Parisella 70 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Update View Calculation issue 21.02.85Summary After upgrading to 21.02.85 release patch, we are receiving below error "Fix Statement cannot include member(s), from FIXPARALLEL dimension [Entity]"Content Afte…Priyesh P. Rane 27 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
data block issue on ODRSummary I'm trying to create a rule to copy data from a period/year to another period/year and I have a block creation issueContent Hello All, I'll move from standard to…Gianluca Natili 38 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How best do I create a Proforma scenario in FCCS?Summary A client wishes to have an "adjusted" Actual scenario that adds historical data from acquisitionsContent Since we would be entering new data into the past, this …JoachimB 39 views 3 comments 0 points Most recent by User_2025-02-05-23-45-21-053 Financial Consolidation and Close -
When copy data from scenario to another scenario in custom rule, entity target is not impactedContent Dear All, I noticed that when I copy data from scenario to another one in a custom rule, the entity target is not impacted, it remains OK. How can change the sta…Gianluca Natili 31 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close
-
Sample custom script "FCCS_30" or "FCCS_40" for stopping entity to consolidate to its parentContent Hi All, We have a requirement where entity "A142" is deactivated in Jul --> FY20. normally YTD balances of Jun --> FY20 will carry forwarded till Dec --> FY20, b…amaresh salagundi-Oracle 42 views 3 comments 0 points Most recent by amaresh salagundi-Oracle Financial Consolidation and Close
-
FCCS_Entity Consolidation generates error in an On Demand Rule FIX statement and Run Time PromptContent On Demand Rule restriction query Hi all While creating an On Demand Rule, we have the following error, with the FCCS_Entity Consolidation Entity. We cannot add i…NK2025 30 views 2 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Out of the box calculationsSummary Out of the box calculations / objects in groovyContent FCC supports Configurable Calculations (Insertion Point Rules) and On Demand Rules (ODRs). Users can custo…Dheeraj Anand-Oracle 34 views 2 comments 0 points Most recent by Dheeraj Anand-Oracle Financial Consolidation and Close
-
copy data from scenarioContent Hello All, I would like to copy data from actual scenario, from jan to aug closed period, to a forecast scenario. Data to copy from actual, jan to aug, should be…Gianluca Natili 44 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close
-
On Demand Aggregation Rule for Supplementary DataContent Hi, We are entering supplementary data by intercompany in FCCS. There is a requirement as to when the user enters supplementary data by Intercompany and saves th…
-
Make sure @fccsImpactStatus function contains 4 parametersSummary Error in calculation rule in @fccsImpactStatusContent Hi, Can anybody help me on this issue, please: I tried to run a custom rule in fccs which I ran other times…Carlos Amaral 36 views 3 comments 0 points Most recent by Keith Glide Financial Consolidation and Close
-
Clear wrong DataSummary I need to clear data from Jul to DecContent Hello, I need to clear consolidated data from July to Dec, and i can't achieve this from clear data rule, as i should…Hussein Mahmoud 68 views 3 comments 0 points Most recent by LucaScarpa Financial Consolidation and Close
-
Asset disposal / Held for sale assetsContent Hello all, Does any one has experience of maintain the asset disposal or held for sales asset in FCCS, is there any function or custom calculation to achieve it …User_2025-02-06-09-24-28-207 99 views 2 comments 0 points Most recent by CA.Dipen Shah Financial Consolidation and Close -
How do I get the default movement to be calculate AFTER the 10 Rule?Summary The default movement appears to calculate before other calculations. This means that I need to run a ODR before the consolidation every time.Content Is it correc…
-
Scheduled predecessor jobs must run before successor jobsSummary Scheduled predecessor jobs must run before successor jobsContent Hi In FCC, I would like to run 2 rules in series every evening. I can: 1) schedule each as a job…Chris Badenhorst 34 views 1 comment 1 point Most recent by Unknown Financial Consolidation and Close
-
We could not use bottom up calculation when we want to copy data from one entity to another entity.Summary We could not use bottom up calculation when we want to copy data from one entity to another entity.Content Dear expert: Due to organization structure adjustment,…Nan Wang-Oracle 61 views 7 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close