To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Financial Consolidation and Close
Discussion List
-
NetSuite Integration with FCCS1.Our goal is to load trial balance data directly from NetSuite ERP into FCCS. 2.We understand that there is no specific documentation available for integrating NetSuite… -
FCCS_CTA/FCCS_CICTA and FCCS_Mvmts_FX_MovementHello, I am getting an unbalanced balance sheet at parent currency due to data in FCCS_CICTA, FCCS_Mvmts_FX_Movement that does not sum to zero. I can understand the foll…
-
CTA Opening BalanceSummary Need to add CTA opening BalanceContent Hello, I have a case as the following i am uploading data for the first time to the application and everything going well … -
What is the best practice to migrate FCCS from one instance to another(test to prod) ?Summary: What is the best practice to migrate FCCS from one instance to another(test to prod) ? Is it clone option using snapshot backup or LCM export all artifacts from…
-
Is it possible to export data management > process details using EPMAutomate?Summary: Im using oracle epbcs, is it possible to export data management > process details using EPMAutomate? (Im referring to the table) My goal is to check the data lo…
-
Substitution Variable - Not Working in Custom Application FDMEESummary: Issue with using Substitution Variable in FDMEE Content (please ensure you mask any confidential information): Hi All, we noticed an issue with a Custom Applica… -
Is it possible to apply cell level formula in data forms 2.0?Summary: We want to apply 2 different formulas in a single column in data forms in FCCS. Generally, we apply a formula for entire column but in case we want to apply dif…
-
How are people handling the movement member for plug accountsSummary: As far as I can tell, when intercompany accounts eliminate to the plug account the data stays in the original movement member. This means that when 2 accounts e…
-
How to Parse Date From EPMAutomate downloaded Activity reports' Json FileContent I downloaded FCCS activity reports, I like to know how to scraping data from this Json file for analytics. I basically want to convert it like the original table… -
Facing issue having error message starting with "You are trying to change the data" after patchSummary: While deploying rules or try opening forms, we are facing below issue in the EPM application after the patch has been updated on Friday. Appreciate your help an… -
Enabling Oauth authentication for EPMAgent using IDCS1.) Which configuration file of EPM agent has the details of IDCS tenant(to which EPM agent will be connecting to perform the Oauth auth). 2.) Each time EPM agent does O…
-
Investment in Subsidiary Elimination having no intercompany PartnerIn my Project, There are so many cases, where investment is made having no Intercompany partner or in some cases same ICP( same Affiliated Code). I checked out the OOB r…
-
FCCS: Is it possible to NOT display Forms under the library in Reports or limit accessSummary: Content (please ensure you mask any confidential information): Hi all As per attached, we are seeing Forms displaying under the library part of the new REPORTS.… -
Reversal of YTD Closing Balance and FCCS CTA from the prior periodSummary: We need to identify how reversal of YTD Closing Balance and FCCS_Retained Earnings Prior, FCCS_CTA, FCCS_REC OBFXCTA from the prior period for “FCCS_OpeningBala…
-
Supplemental data and FCCS Consol dataHi What is the suitable tool to build a report that includes supplemental data and FCCS Consol data ? Example: I need to have the Balance Sheet (BS) and the related note… -
Process for Entity MovementSummary: Any time we make Parent Entity movement, we need to un-lock all periods and re-consolidate historical periods. If we have 5 years worth of data, and it's taking… -
Rolling 12 Consol Formulas DSO HelpIn the process of converting our FCCS apps to DSO. Have noticed some of our Rolling 12 member calculations (Consol formulas tied to Account dimensions) are causing grids…
-
While running consolidation at Parent Entity level data is not aggregating?We are getting the below error when we run the Consolidation/Force Consolidation. Could you please advice us on how to resolve this issue? Log messages : List of entitie…Prem Siva Kumar Reddy Rami Reddy 141 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle
-
Essbase could not get a lock in the specified time.Summary: Content (please ensure you mask any confidential information): When consolidating we are getting this error: Essbase could not get a lock in the specified time.…
-
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…
-
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…
-
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… -
Consolidation Journal ReportIs it possible to run the journal report in EPM FCCS with a criteria to show which Consolidation journals have an attachment?
-
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?
-
Value in variables is not reflecting when launching the Business RulesSummary: Created new business rules for FCCS, however, when trying to launch it the value set in Years and Period is not showing in the prompt. Content (please ensure yo…
-
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… -
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…
-
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… -
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…
-
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…