On Demand Rules
Discussion List
-
Is there a way to copy rate overrides from base level entities to parent ones?hi all, We have rate override inputs, lots of them, that we need to replicate to upper level / parent entities, how can we do that? Is it possible to do so via ODR rule?…YannisV 12 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Rules with no period relatedHi Experts, I need your help. Need to create a calc that its not related to the period, normally we use BegBalance member, but in FCCS the rule is sending an error when … -
Can you have more than one Net Income Rule-Set that utilize different basis and redirection accountsSummary: Is it possible to have more than one configurable rule for the Net Income Subsidiary Rule-Set. We would like to have each new rule set utilizes a different basi… -
How to rewrite On-demand FCCS rule after converting to DSOSummary: After converting to DSO in Test, an On-demand runs indefinitely in Test (DSO). In Prod, the same On-demand rule runs in 3 minutes in Production (no DSO). Conten…
-
New Recording Available - Best Practices and Tips PresentationsWe have recently added new best practice content focused on typical issues we have seen in customer applications and implementations in the events area (you can always s…Rich Wilkie-Oracle 1.6K views 11 comments 10 points Most recent by Farooq H Syed Financial Consolidation and Close
-
Calc Script Causing values to doubleSummary: I am trying to move data via a calc script and it is causing values to double up. Content (required): I have a script that is taking values for all of our LOB's…LeoSchillinger 42 views 10 comments 0 points Most recent by LeoSchillinger Financial Consolidation and Close
-
Copy Parent Currency in One Scenario to Entity Currency in Another ScenarioSummary: I am trying to copy base level data at parent currency to the same dimension members in entity currency in another scenario in FCC. This could be in an on-deman…Benjamin Moster 5 views 0 comments 0 points Started by Benjamin Moster Financial Consolidation and Close
-
Issue running ODR for entities with a member functionHi All. I am creating an On Demand Rule in FCCS. When created the ODR rule has created automatically prompts for the members of the Entity Dimension (as well as others).…Brian Somers 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Using Approval Units and Validation Rules in Data Forms to prevent promoting of entitiesSummary: Validation Rules are used in Data Forms to set a Balance Sheet tolerance of $123. When the Approvals is started, users can still 'Promote', 'Approve' and 'Sign …
-
RuleSet with ODR and Consolidation / TranslationSummary: Has anyone tried setting up Ruleset in FCCS that includes Consolidation or Translation Rule along with ODR? Content (required): Looking to set up Ruleset that e…Amit Kulkarni 21 views 2 comments 0 points Most recent by Amit Kulkarni Financial Consolidation and Close
-
Has Anyone Calculated Average Daily Balance in FCCSSummary: Caclulate Average Daily Balance Post Consolidaitons Content (required): We have a requirement to calculate average daily balances post consolidations. Has anyon…Corey Cain 42 views 9 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Copy Parent Data in on Scenario to a Base Level Member in another ScenarioSummary: I am trying to copy data at a parent level (entity, custom dimensions, etc.) to a base level entity in another scenario in FCC. This could be in an on-demand ru…
-
We have a rule to copy data from Income Statement Intercompany account to Balance Sheet IntercompanySummary: We have a rule in F10 to copy data from Income Statement Intercompany account to Balance Sheet Intercompany account and specific movement, the rule is working f…Maruthi_FCC 22 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
Member formula question post-DSOSummary: After migration to DSO, account member formula not working Content (required): After DSO, a member formula to average values over a dynamic range of periods is …SAW23321 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Member formula question post-DSOSummary: After migration to DSO, account member formula not working Content (required): After DSO, a member formula to average values over a dynamic range of periods is …SAW23321 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Default Movement Member Selection - Cash FlowSummary: Client has a requirement for a systemized cash flow in FCC. They will continue to load ending balances where we load to ClosingBalance_Input and rely on the def…Andrew Zaccardi 22 views 2 comments 0 points Most recent by YannisV Financial Consolidation and Close
-
Code behavior with FCCSImpactStatus troubleshootSummary:Not understanding results received with block of code using FCCSImpactStatus Content (required): Overall goal is consolidate Actual, impact status of target scen…Scott Rodney 15 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Balance for alternate data source hierarchySummary: Content (required): We have a requirement for an alternate data source hierarchy. The problem lies with the balancing account, FCCS_Balance, which is populated …
-
FCCS_REC OBFXCTA is displaying incorrect signageSummary: We have come across an issue in FCCS_REC OBFXCTA account , Oracle has confirmed it as a bug. Issue : - Seeded account FCCS_REC OBFXCTA is displaying incorrect s…Rao_FCC 52 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
On Demand Rules - RATES CUBESummary: Create on Demand Rules for Rates Cube Content (required): Hi All, for a client we need to create a specific "on Demand Rules" in order to copy Exchange Rates In…Antonio Barbaro 33 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can you source data from FCCS_YTD in on demand rules?Summary: When I try to pull the YTD data from 1 account to the Periodic member of another account, it appears to ignore that I have specified FCCS_YTD in the rule and pu…EmmaPa 3 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Does UDA for Account dim predefined per account types? it is not explicitly listed on propsSummary: @UDA("Account","Expense") and @UDA("Account","Revenue"), I do not see UDA assignment in the properties but this function is working Content (required): Does FCC… -
Member formula changes after DSO ( dense sparse Optimization)Summary: We have couple member formulas that calculates DSO ( Days sales outstanding) and DPO (Days Payable Outstanding). They were working prior to changing to DSO appl… -
FCC 22.03 Update Cause Custom Calculation FailedSummary: FCC 22.03 Update - Cause Custom Calculation Failed Content (required): FCC 22.03 Update - Cause Custom Calculation Failed. In FCC Test instance, it has already …Ryan Li 53 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data is not calculating on FCCS_20 / having performance problemsSummary: Sample rule pulling top members from RHS into bottom members on LHS is having performance problems even when we have follwed the guidance in the admin guide [ht…Steve Slack 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Consolidate Rule takes too much timeSummary: I have FCCs application which is DSO (Movement and Period are Dense), the application has 3 override translation rules and 26 configurable consolidation rules w…Mohamed Awad-278765 31 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Groovy Helper Functions to Execute an EPM Cloud Job and Poll For its StatusSummary: This discussion provides a couple of Groovy based helper methods that could be added to a Groovy based business rule to execute an EPM Cloud job. Content (requi…Ashutosh Bhatikar-Oracle 51 views 0 comments 1 point Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Help on configurable calculationsContent (required): Hi all, I'm not an expert on configurable calculations and need your help. I'm trying to copy the Opening Balance of 'Cash' on parent-level to a new …Christian Oefner 21 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to update setting for Business rules to understand member name or aliasSummary: How to update setting for Business rules to understand defined member name in 'If' or 'Fix' instead of Alias default setting. Content (required): Version (inclu…YogeshKJain 11 views 6 comments 0 points Most recent by Kapil_Bankeraika Financial Consolidation and Close -
HOW TO: Execute FCCS Journals REST API Using Groovy On Demand Business RuleSummary: This example depicts how Groovy can be leveraged to execute an FCCS Consolidation Journals Period Open/Close REST API that is not available using EPM Automate. …Ashutosh Bhatikar-Oracle 21 views 0 comments 1 point Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close