Category 143
Discussion List
-
Entity Hierarchy changes and Consolidation for historical periodSummary: Hi All, We're planning to create sub-parent entities and move existing entities from a flat hierarchy to these new sub-parents. Do we need to consolidate histor…SenthilSSN 37 views 2 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
rank function in a formSummary: The function Rank() is available in a data form, but returns #Error. Content : The Rank() formula allows to rank values and then sorts them ascending or descend…Erik De Rouck 91 views 3 comments 0 points Most recent by Erik De Rouck Financial Consolidation and Close -
Data / Dimension in Tabular FormatSummary: How can I create a report in tabular format? or is it possible in FCCS? Content (please ensure you mask any confidential information): Sample Version (include t… -
When data is loaded from multiple files using Data Management in FCCS, how to know the sourceSummary: Customer is loading the data for same entity through multiple files (First file is loaded in Replace mode, while the second and third in Accumulate mode). The P…rahul shinde-Oracle 51 views 9 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close -
Metadata has been changed. Please recompute the ownership data.Summary: If Entity has been updated where Child Entity was moved from one Parent to another as well as Parent moved from one Parent to another during P1-FY24, how would …Greg Hull 79 views 2 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
In Data Management->Data Load Mapping->Export to Excel does not show dimension detailsSummary: In Data Management->Data Load Mapping->Export to Excel it downloads an Excel. In this Excel in the Map tab there is a drop down for all the dimensions. SO when …rahul shinde-Oracle 35 views 1 comment 0 points Most recent by SureshM-Oracle Financial Consolidation and Close -
FCCS Seeded Account Alias Extraction IssueSummary: Hi everyone, I'm encountering an issue while extracting the FCCS account dimension. When using the Application -> Dimension -> Export option, the "Default:Alias… -
Investments made by holding company in entities with "NotConsolidated" Method not getting eliminatedSummary: Investments made by holding company in entities (In ICPs) with "NotConsolidated" Method not getting eliminated by Investment elimination configurable consolidat…Harshith J Rao 25 views 1 comment 0 points Most recent by Pavan-Oracle Financial Consolidation and Close -
what is the correct use to perform calculations with the YTD member within an OnDemand ruleSummary: Calculations with the YTD member within an On Demand rule Content (please ensure you mask any confidential information): Hello, We would like to clarify or know…Anderson Florez 16 views 1 comment 0 points Most recent by Pavan-Oracle Financial Consolidation and Close -
Create drill regionSummary: Hello, now that we've migrated our EPM environment to Gen 2, I am unable to find the option to enable "Create Drill Region", as this is no longer available from… -
Parent Top Side AdjustmentSummary: P13-FY23 looks good, but for some reason in the new year, we have the same amount coming through for P1-FY24. As you can see, there are no journals in YTD_Input…Greg Hull 37 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Journals Submitter and Approver roles Prior to 23.07 Version for Audit questionSummary: Hi All, Prior to 23.07 version (pre-Oracle Journal Security Roles implementation), how did the segregation of roles between journal submitters and approvers wor…SenthilSSN 37 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Approval Unit Sub Status Failed: Entity Calc Status ImpactedSummary: User cannot promote and sub status appears as Failed: Entity Calc Status Impacted. Content (please ensure you mask any confidential information): The Calc statu…DianeDgh 323 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Data Load not working as expectedSummary: Data replace is working as Data Merge. From FCCS, we had pulled the data from GL for 10619$ in one account/Entity Combination and the data reconciled fine with … -
Is there documentation around shared entities within the manage ownership screen?Summary: We currently have an entity that is shared 7 times within our main hierarchy. I am looking for documentation around the manage ownership screen and if there is …Casey Kempel 14 views 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close -
Need a solution to change the Qtr rollups in the Period dimension for a 12 month calendarSummary: Need solutions to change Qtr rollups in the period dimension. Content (please ensure you mask any confidential information): Client requires Q1=Jan,Feb; Q2=Mar,…Dale Joosten 26 views 2 comments 0 points Most recent by Dale Joosten Financial Consolidation and Close -
Groovy script:restricting the usage of data load for common dataruleSummary: Looking for solution via groovy in FCCS : if user one has trigger the remote dataload pipline from FCCS for PCMCS then the process should be locked for rest of …Sreekumar Hariharan 35 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can you export the configurable consolidation rules?Summary: I see in the manage consolidation rules screen - there is an export icon. Does this allow users to export all the configurable consolidation rules? I can't seem…Casey Kempel 38 views 2 comments 0 points Most recent by Casey Kempel Financial Consolidation and Close -
Kyriba Integration with FCCS Close managerSummary: We are using FCCS only for close manger functionalities. And we have a Source Kyriba and Zuora tools to be monitored/monitered. and i do not find any connection…TechWUB_ 38 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
How can we translate the data at actual rate and budget rate?Summary: We have created a member in one of custom dimensions and mapped all data to this member and the data translated at actual rate, and we created another member in…Eman_Elbayadi 36 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data Exchange - Data Export Planning ErrorSummary: Client wants a data export from a custom RevCOGS cube. They want account and period in the rows, and the DATAEXPORT business rule command requires a dense dimen…Nicholas Ho 102 views 15 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close -
Equity Pick Up Rule Sets/Account GroupingsSummary: In 23.07 the limit for the number of Equity Pick Up Account Groupings was raised from 25 to 50. Content (required): When we added additional Account Groupings/R…Maggie Reed-Oracle 108 views 2 comments 3 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close -
Disable check step in Data managementSummary: We are looking for a way to disable the check step in Data Management. Content (please ensure you mask any confidential information): In the Data Management Wor…Alyssa Longo 29 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close -
Goodwill is not being calculated and consolidation is not happening in Oracle FCCSHi all, I am very new to Oracle FCCS and learning it with some test case scenarios. I have configured the application and input the following data. Below screenshot prov…Ram Kashyap 95 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Distorted View in FCC Data FormSummary: Distorted View in FCC Data Form Content (please ensure you mask any confidential information):We are seeing a distorted view in FCC Data Form wherein colomns ar…Vidhi Nenwani 26 views 6 comments 0 points Most recent by Vidhi Nenwani Financial Consolidation and Close -
Extract account usageSummary: Is there a way to extract the list of forms that an account is used on? We can view the usage account by account but need to be able to provide a comprehensive … -
How to refer prior year last period in Calc manager for writing ruleSummary: How to refer prior year last period in Calc manager for writing rule in FCCS application Content (please ensure you mask any confidential information): Hi Exper…DISHIL SHAH 46 views 3 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close -
Is there a way to extract manual consolidation journal entries using a data load rule?Hi, Our business clients currently post some consolidation journal entries at a parent entity member level and I was wondering if there was a way to extract those entrie…Sarah Paroya 48 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FX Rate QuerySummary: We have built a data form in the Consol Cube and the same data form we need FX rates from Rates Cube, not very sure whether this is feasible or not in the FCCS … -
Viewer Role able to enter in data on Forms when they shouldn'tSummary: I have assigned a Viewer Role in FCCS and that User is able to enter data into Forms. Based on Oracle documentation, I don't believe they should be able to ente…Bruce Truong-235790 14 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close