On Demand Rules
Discussion List
-
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 12 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
-
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 1K views 8 comments 8 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…RanchWag63 16 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 51 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 31 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…User591806 1 view 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 51 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 24 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…User_RFYLN 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
-
Trying to copy data from Account and Movement dimensionSummary: We are trying to copy data from :FCCS_Retained Earnings ->FCCS_TotalOpeningBalance to Account SOCIERE->STATMVMT_OpBal using the below script but the script is i…
-
Copy prior year Exchange ratesSummary:I want to copy average rate from Prior year Dec month and Ending rate from prior year current month into different scenario. Standard copy data function will fet…User_IW47W 11 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 11 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 45 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 …User_RFYLN 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 59 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