Category 143
Discussion List
-
Load Data in YTD_InputHello, The cumulative data upload (YTD_Input) forces you to define a single "Default Movement" per accounting account ("Calculate Movement rule"). If so, how could I loa…CarolinaRodriguez 12 views 1 comment 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close -
Supplemental Data or Dimensional ModelSummary: Definition of accounting notes in FCC Content (please ensure you mask any confidential information): We are currently reviewing the presentation accounting note…CarolinaRodriguez 12 views 1 comment 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close -
Use substitution variable in data integration pipeline jobSummary: We would like to use substitution variables for the start/endperiod of a data integration as part of a pipeline job (with a few integrations and a consolidation…Tjeerd Huisman 38 views 2 comments 0 points Most recent by Tjeerd Huisman Financial Consolidation and Close -
Consolidation Journal ReportIs it possible to run the journal report in EPM FCCS with a criteria to show which Consolidation journals have an attachment?AnubhavJain1 12 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Perfomance with 3 different alias tableCreat new table alias impact in the performance? It will take more time in calculation with diferents table alias? It will increase time of searching in smart view?ALopezS 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How To: User Variables in Calculation Manager Rules associated with Data FormsSummary: This article helps explain how EPM Cloud User Variables can be associated with Calculation Manager business rules to avoid Runtime Prompt by associating User Va…Ashutosh Bhatikar-Oracle 123 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Metadata - Never share Member followed by shared memberSummary: In the Legal Entity metadata file, in the order of sequence can we have member with shared as 1st and then followed by never share Content (please ensure you ma…Vijayverma 34 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Using substitution variable for Entity in Copy Data profile does not workSummary: Using substitution variable for Entity in Copy Data profile does not work. Content (please ensure you mask any confidential information): Dear FCC Prod. Managem…Gerrit Haan 21 views 4 comments 0 points Most recent by Gerrit Haan Financial Consolidation and Close -
Audit log of adding and removing users from groupsHi, Could someone please guide me how I can export the Audit log of changes to groups (specifically adding and removing users from groups not creating/deleting groups) T…RajuNaidu 11 views 1 comment 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
Can ICP be appended as prefix in the intercompany dimension default alias instead of a suffix?Summary: Client requested the ICP to be a prefix instead of a suffix in the default alias property in intercompany dimension. Is there a place we can change the set up t… -
FCCS - Consolidate Job - Low PerformanceSummary: In our Oracle FCCS environment, our "Consolidate" job runs in average during 40 minutes. Some jobs might run for more than 100 minutes. This is quite a lot know…Julie Belurier 33 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS Rest API for Automating Actions on Approval ProcessDo we have a Rest API to automate actions for the approval process like Promoting or Locking an entity in the Approval Unit Hierarchy ?ArjunBhasin 54 views 2 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
@ISATTRIBUTE Shared Entity MemberSummary: I have a custom attribute set up on my Entity dimension and had put code into FCCS_110 to check if the attribute is a certain member before performing a calcula…KimJenkins 5 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Showing Balance Sheet Accounts with natural signage from TB and P&L Accounts with sign flip in FCCSummary: Hi All Client requires us to show Balance Sheet Accounts with natural signage from ERP and P&L Accounts with sign flip. This requirement is from reporting stand…Parmit Choudhury-Deloitte 485 views 6 comments 0 points Most recent by BrettMac24 Financial Consolidation and Close -
Will Daily maintenance runs while the application is in Admin ModeSummary: We are in the EL Migration wanted to know Daily Maintainence will be run when the application is in Admin Mode. Wanted to ensure From Oracle that no Daily Maint…SubramaniKalimuthu 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
The accuracy settings of Management ReportSummary: The accuracy settings of Management Report Content (please ensure you mask any confidential information): We tried to export the exact amount in Management Repo… -
When running a consolidation at Total Geography, the consolidation does not finishSummary: In Oracle Financial Consolidation and Close Cloud (FCCS) Application, when executing the Consolidation or Force Consolidate rules, Consolidation Process is keep…Gary Hewstone 42 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to connect Oracle DB from EPM?Hi Team, As part of integration project, we would like to connect Oracle DB from EPM; which could help us to create a view and get the desired data from Oracle DB to EPM…Sukanya 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to pull FCCS data with fully qualified name.Summary: I'm working on integration to PBCS. I need map Entity Dimension shared member to different entity Target in PBCS with its base member to separate consol elimina…Rosida Majid 59 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Enterprise journals compared to Fusion journalsSummary: We are exploring if we should deploy FCCS Enterprise journals for accountants to load all manual entries replacing existing direct Fusion journal entry. Looking…David Hiscutt 81 views 8 comments 0 points Most recent by Managing Partner Financial Consolidation and Close -
Controlling Standard Movement Calculations based on ClosingBalance_InputHello, In our FCCS system, some entities in the group load both the Closing Balance and Movement Balance, while others provide only the Closing Balance. For entities tha…Bjoern Schumacher 35 views 5 comments 0 points Most recent by Vani-Oracle Financial Consolidation and Close -
FCC Approvals Budget Data Multi YearSummary: Working with a client that intends to use FCC to consolidate the Budget data. The reason for using FCC is to leverage the elimination functionality. The Budget …Steve Hitchman 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How To: Know if Application is Hybrid Enabled using REST APISummary: This tip helps to identify if an application is Hybrid Enabled using REST API. Content (please ensure you mask any confidential information): Use REST API Get A…Ashutosh Bhatikar-Oracle 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Translation of Opening balance adjustments with no prior period ratesSummary: FCCS application has been loading only USD balances for all previous years from GL. GL was doing the translation. In January 2024 we would like to load entity c…K McMillan 14 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Locking entities in FCCS without using approvalsSummary: Locking entities in FCCS without using approvals Content (please ensure you mask any confidential information): Can we lock the entities for historical periods …AniN 73 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
"Net Income Equity rule"Summary: We have currently copied the OOTB rule of "Net Income Equity" and replicated with different source accounts in place of Retained Earnings Current. And Target re…Rashmi Subash 11 views 2 comments 0 points Most recent by Jing Xue-Oracle Financial Consolidation and Close -
EPU rules getting calculated at both immediate holding and next level holding entitySummary: EPU Rules - Prepare and Consolidate (Indirect) rules is deployed using Client COA in place of preseeded "Investment in Equity" & "Equity Income" with memo accou…Rashmi Subash 31 views 3 comments 1 point Most recent by Jing Xue-Oracle Financial Consolidation and Close -
how to modify time zone in FCCS as system administratorSummary: how to modify time zone in FCCS as system administrator which applies to all users. I am not seeing this option in Settings. Can you help me on this? Content (p…Divya_Masoodi 32 views 7 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close -
Clarification on New System Maintenance Process for Consistent Data Load Performance in 24.11Summary: Hi Oracle, Can you please provide update on disabling the below feature provided in the 24.11 release notes: To address inconsistent data load times, Data Integ…Ramsha Ansari 41 views 2 comments 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close -
Issue with Clone Environment CommandSummary: While running cloneEnvironment command using groovy script, we are receiving below error - A method called by the script failed on line: 33, with error: Invalid…Priyesh P. Rane 23 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close