Category 143
Discussion List
-
Issue with Custom Dimension Validation in Enterprise Journals within SmartView (FCCS)We're currently working on posting a journal to a template in FCCS using Enterprise Journals. One of the custom dimension fields is a concatenation of Entity.Account.Cos…Kyle S. 13 views 1 comment 4 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
Improve Essbase Hybrid BSO Calculation Script PerformanceSummary: This article provides pointers to improve FCCS insertion points written for Hybrid Essbase. Especially useful for applications using Period and Movement Dense, …Ashutosh Bhatikar-Oracle 369 views 14 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Translation at reporting currency not happening as per ending rate for balance sheet accoutnsSummary: When running translation in a reporting currency (which is not the entity currency or the parent currency of the entity), the balance sheet accounts are not bei…Harshita K 31 views 2 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
FCCS Copy Data (YTD values)Hi all, Is it really possible that in FCCS we cannot copy YTD values using Copy Data profiles, as View dim is fixed to Periodic ? Sounds a bit unbeliavable to me, anybod…Mihajlo Belosevic 43 views 8 comments 0 points Most recent by Mihajlo Belosevic Financial Consolidation and Close -
Is there a recomputeOwnsershipData API?Summary: We have business requirement to automate recomputeOwnsershipData in an OIC Integration, I am seeing there is an EPMAutomate command for this, what is the API en…RSkibitzki 24 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
audit log changes property of accountSummary: We want to track the changes on the property for the account members in the audit logs. Content (please ensure you mask any confidential information): When upda…Silvia Vilchis 71 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Smart view related issue in FCC TEST after 25.06 updatesAfter monthly updates 25.06 to FCC TEST, we are observing an issue when we try to open a data form from web to Excel Smart view? We see login page and after entering cre…MKhade 41 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EPM AutomateHi All, We are currently using EPM Automate to load the Trial Balance (TB) into our FCCS instance as part of our automated integration process. However, we are facing a …User_NI5BW 21 views 2 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
AI capabilities in FCCSSummary: Need to know if Oracle is planning to implement any AI capabilities in FCCS. Please share if you any documentation around the same and its benefits. Do we alrea… -
Trapped data in alternate rollupSummary: Trapped data in alternate rollup Content (required): When we move entities between International and Domestic, Opening Balance numbers don't move, only movement…getgaurav 102 views 20 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Intercompany elimination difference due to exchange rates used for translationSummary: Intercompany elimination is generating an out-of-balance because of exchange rate differences, used for translation, between the legal entity and the intercompa…Sowmya Sundar 2.1K views 9 comments 0 points Most recent by Amarnath_Kothapalli Financial Consolidation and Close -
How do you obtain last modified date for a data integration within data exchange within Freeform?We only see the last executed date within the data exchange screen and we our audit report does not pickup any modifications we made to the data integration. Looking to …C Vincent 21 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
Opening Balance Adjustment causing a difference in Cash FlowSummary: There has been a journal entry posted to reclass data from one custom movement to "FCCS_OpeningBalanceAdjustment" movement. This is causing issue in Cash Flow R…Siddhi_Shah 34 views 1 comment 0 points Most recent by Maggie Reed-Oracle Financial Consolidation and Close -
No journal posted but seeing journal data at member 'Translated Input currency' for Parent entitySummary:Hi, No journal posted for te parent entity and base entity, but seeing data at the member 'Translated Input Currency'. I have drill down to all base members and …Ahmedullah Malik 59 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data not aggregating to parent entitySummary:Hi, I have created new Accounts outside FCCS_BalanceSheet hierarchy and new Movement members outside FCCS_Movements hierachy. The base account member attributes …Ahmedullah Malik 32 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Rate push to consol cube is failedSummary: In trying to move an entity to a different parent in the primary hierarchy under total geography, I am getting data base refresh errors below: A method called b… -
Intercompany eliminations and Cash Flow MovementsSummary: Intercompany eliminations and Cash Flow Movements Content (required): We are working to stand up an FCC application and running into a challenge related to inte… -
How do we limit the date of Invoices shown in the Vendor Portal?Summary: During data migration, we have migrated previous year's Accounts Payable. However, we want the Invoices shown in the Vendor Portal to be starting only from the …Giselle Paglinawan 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Forms and Dashboard Migratoin from 1.0 to 2.0Summary: We have a few queries regarding the migration of Data Forms and Dashboards from version 1.0 to 2.0 in Oracle FCCS: 1. Will Oracle be completely removing Data Fo…SubramaniKalimuthu 213 views 11 comments 0 points Most recent by Raj.k Financial Consolidation and Close -
How to reduce complexity of a custom dimensionSummary: One of our customers has an issue with consolidation times, that we think is caused by the growth of a custom dimension (as we've already looked at and optimize…Tjeerd Huisman 53 views 12 comments 1 point Most recent by Tjeerd Huisman Financial Consolidation and Close -
Approvals Top Group behaviorSummary: Hi all, I’d like to confirm the below behavior regarding Approvals. Currently, in our Entity dimension, we have the following hierarchy (only a small example as… -
Where FCCS_Percent Min Input cause effects?I am having an impasse with the FCCS Percent Min Input member. I have an entity called Consol - Entity 4, where it is contained in two structures: Consol - Entity 3 and …IgorRaffa 22 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Dummy dataSummary: Request for FCCS Dummy data for testing purposes. Content (please ensure you mask any confidential information): I do require sample multi-periods trial balance…Sarwar 55 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EPM agent is getting StuckSummary: EPM agent is getting stuck/Freeze Content (please ensure you mask any confidential information): Dear all, One year ago, we configured an EPM Agent and it was w…Ethien Eid 50 views 8 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close -
ICP Elimination Calc when translating from USD to other reporting CurrenciesHi folks, Currently in our FCC application, we have USD as the main currency In our setup, example: ENTITYCONSOL is a USD parent with EUR children. When translating to E…Guixdx 82 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How can I get my Secondary Data Source to include Eliminations?Summary: We have our Primary Data Source stored as a child of the system generated FCCS_TotalInputAndAdjusted, which rolls to FCCS_Total Data Source. Since FCCS_Total El…B-MacMurdo 53 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
Split Adjustment Periods for BS and PL in Data Integration?Summary: Need to load different adjustment periods for BS and PL accounts from Oracle ERP Cloud GL to FCC using Data Integration, but limited by the single-source-applic…ShanqiDaFu-Oracle 21 views 1 comment 0 points Most recent by ShanqiDaFu-Oracle Financial Consolidation and Close -
Job scheduling in FCCS for first 10 days in a close cycleSummary: We want to trigger the data load pipeline daily from the 1st to the 10th of each month. How can we achieve this using job scheduling in FCCS? We do not want to …AishShirke 22 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Delete file from ARCS inbox/outbox with version 11.1.2.3.600Summary: Hi Team, We have requirement to upload files into ARCS inbox/outbox folder, we need to first delete the existing file and load the new file. loading new file is…VasanthaFusion90 59 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Disposal Entity Contributing Goodwill Offset to Parent EntitySummary: We have enabled our application with OrgByPeriod functionality. We have historical data from FY23 P13 to FY24 P13. We have loaded for FY25 P1 and P2. We have lo…Pradeep Kumar01 24 views 2 comments 0 points Most recent by Pradeep Kumar01 Financial Consolidation and Close