On Demand Rules
Discussion List
-
Populating Target account using successive addition methodSummary: Populating target account SCII and movement member STATMVMT_DTHR from source account 72300,Sum of Two movement members (STATMVMT_PLDTAX and STATMVMT_SORIE) and …Rao_FCC 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Constant currency business ruleSummary: Need help with constant currency business rule Content (required):I am new to fccs and have business requirement of constant currency. I have tried translation …User_IW47W 22 views 7 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close
-
Need to avoid an impact status after launched an ODRSummary: Content (required): Hello All, I need to write an ODR that runs after save on a data form, below a sample script. I would like this rule to only run on FORE_STA…Gianluca Natili 13 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCC Block Creation IssueSummary: Hi All, I'm trying the below rule to move data from Custom1 Top member (right side) to a specific Custom1 base member on the left side for all the level 0 membe…
-
Copy Full Data From one scenario to another scenarioSummary how to copy all data from one scenario to another scenario included translated values, ownership etcContent we load the data to a temporary scenario, and we do a…Hussein_H 53 views 9 comments 0 points Most recent by Nagarajan Mouttouvelou Financial Consolidation and Close
-
Performance issue with ODR scriptSummary Performance issue with ODR scriptContent Below ODR takes too long to execute, though it generate results as expected. Can someone guide on what might be causing …YogeshKJain 17 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Need clarification on customer Business Rule (allocation rent expenses ) is not executedContent customer has created a business rule to allocate rent expenses across departments based on the square feet. An example is attached for your reference and the rul…
-
Joint Venture Net Income calculationSummary Minority interest not getting calculated for Net Income ruleContent Hi, I am moving an application from HFM to FCCS(version 21.07). HFM current functionality In … -
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 89 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 17 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 16 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 5 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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…Ashutosh Bhatikar-Oracle 58 views 0 comments 4 points Started 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…Ryan Li 27 views 5 comments 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 15 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 30 views 4 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close
-
How do I calc a default movement based on a #missing value of "Closing Balance - Input"?Content From the info tab of the calculate movements section of the local currency consolidation step: If a data-point for which a closing balance was previously entered…JoachimB 34 views 6 comments 0 points Most recent by Preston Oakes 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 9 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…
-
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, yannisYannisV 24 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 25 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 18 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 30 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…User_9OTH0 17 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 19 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 29 views 3 comments 0 points Most recent by Lynda Gastaldello-183189 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 21 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close