Dimensions
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 11 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 14 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Days per Month in FCCS Calculation Manager - Leap YearsSummary: We would like a dynamically calculated member in our ACCOUNT dimension that will compute the number of days in a given PERIOD and aggregate appropriately in con…James Holland II 23 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - Impact Status IssueSummary FCCS - Impact Status IssueContent Hi All, I tried to implement the "Impact Status" in a FCCS Application. I have a source scenario ("GL"). In this scenario I loa…Antonio Barbaro 27 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Adding Historic YearsHi, we've been asked to update our application so that data can be loaded for more historic years. At the moment the starting year is 2018 but now we want to investigate…Brian Somers 15 views 4 comments 0 points Most recent by Brian Somers Financial Consolidation and Close -
Simple member formula on account not working after DSOSummary: DSO conversion appears to break member formulas Content (required): After converting to DSO, multiple member formulas are not calculating correctly. For example…
-
PVA Translation MethodSummary: PVA Translation Method behavior Content (required): Does anyone know the impacts on Balance Sheet movements using the PVA translation method? I give an example:…User_NJ6WE 1 view 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close
-
Is there any way to input data at the parent currency in FCCSSummary: Is there any way to input data at the parent currency in FCCS Content (required): Is there any way to input data at the parent currency in FCCS Version (include…Sanjay Malviya 33 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
FCCS_CICTA calculation in FCCSSummary: How FCCS_CICTA is calculated in FCCS and from which accounts it is calculated, In case we are using Historical Amount override. In FCCS Admin guide is not menti…Sanjay Malviya 23 views 3 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Best approach for moving Entities to new parents in hierarchy?Hi everyone, If we move Entities in the hierarchy (from one parent to another), is it a requirement to reconsolidate history to ensure balances going forward consolidate…Matt Maurer 13 views 6 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close -
Solve orders after 22.03/22.04 patchingSummary: Errors on metadata validation after patch applied Content (required): After 22.03/22.04 has been applied to our system we get the following errors on metadata v…Jeremy Stubbs 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How FCCS Calculates Potential Number of Blocks?Summary: Does anyone knows How FCCS Calculates Potential Number of Blocks? We are getting the below error and i'm trying to understand how to optimize metadata in the ap…Emanuele Panichi 1 view 2 comments 0 points Most recent by Emanuele Panichi Financial Consolidation and Close
-
FCCS: renaming an entitySummary: Content (required): Version (include the version you are using, if applicable): Hi all We want to rename a dimension and we want to know if any of you out there… -
Making Period and Movement Dense: Report Performance Issues with QTD/YTD ViewsHi everyone, I am looking into making Period and Movement dense in our FCC application and am finding that the QTD/YTD View performance is unacceptable. 1-second Smart V…Matt Maurer 101 views 22 comments 1 point Most recent by Emanuele Panichi Financial Consolidation and Close
-
FCCS - Dynamic Calc members on level 0Hi, we are having one issue with FCCS. Some accounts were developed as dynamic calc members with formulas on level 0. Some time ago Oracle started returning this as warn…User_VSN11 17 views 1 comment 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
"Fix the Dimension Properties" functionalitySummary: Can "Fix the Dimension Properties" functionality eliminate data/journals or members from dimensions? Will it have any impact on the historical data? Content (re…Carolina Silva 11 views 1 comment 0 points Most recent by G Drummond Financial Consolidation and Close
-
Reporting hierarchy Account Type in FCCSSummary: What should be the account type of reporting hierarchy accounts? Content (required): We added a reporting hierarchy accounts in Account dimension. They all are … -
Should we use member formulas in the Movement dimension post-DSO?Summary: Content (required): I know a best practice for the Movement dimension was to avoid using member formulas because it could have a major negative affect on consol…SAW23321 22 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
System booking data to Opening Balance Adjustment during consolidationSummary: Content (required): In our FCC environment, we have a department dimension containing level 0 members that match department parent accounts in the source EBS di…
-
Handling YTD Trial balance load for Offline entities.Summary: We currently load YTD files into FCCS. We have an offline entity for which we load a separate Trial balance. Now we have actually merged the offline entity and …
-
Movements dimension errorSummary: When updating the movements dimension via Smart View I accidently moved one of the seeded FX members to a new parent. The database was refreshed before I realis…Paul Wilcock-161122 21 views 2 comments 0 points Most recent by Paul Wilcock-161122 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… -
Quick way to update POV when multiple forms downloaded from FCCS into SmartViewSummary: Users are frustrated that having created a suite of forms in SmartView to load data to FCCS, they have to update the variable POV members on each sheet individu…
-
Account Solve Order with DSO ModelSummary: We have converted our application to DSO Model, existing accounts dimension parents solve order got updated to 58, however not able to update solve order for ne…
-
Impact Status in FCCSSummary Issue related to copy rule from a source scenario to anotherContent Dear All, we created a specific copy rule in FCCS that copies data from a source scenario (GL…Antonio Barbaro 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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…
-
FCCS (Test Instance: 22.03.59): Dimension Members Limit needs to be increasedSummary: Do we have a way to increase the limit for creating more than 10,000 members under one Custom Dimension Content (required): Right now, I need to create 26,000 D…Srinivas Hindupur-Oracle 21 views 4 comments 0 points Most recent by Michel Schoolenaar-Oracle Financial Consolidation and Close
-
Issue with metadata validation errors in 22.03.59 patchSummary: When testing the most recent patch we are getting validation errors on the movement dimension Content (required): The errors are regarding solve orders. As this…Jeremy Stubbs 31 views 6 comments 0 points Most recent by Nancy Ackerman Financial Consolidation and Close
-
Loading YTD data into FCC application with DSO.Summary: We are looking to migrate our FCCS application to DSO. Currently we load YTD TB file into application and have calculate movement enabled. I was reading through…
-
Error loading YTD trial balance file into FCCS.Summary: We are trying to load YTD Trial balance file into FCCS. This file was used to load into HFM and now we are trying to load it into FCCS. When loading under YTD_I…User_36VKM 31 views 8 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close