Posts

Posts

  • Francesco Venuto
    Action Menus - Help1
    Topic posted December 10, 2019 by Francesco VenutoGreen Ribbon: 100+ Points, tagged Balance Sheet, Consolidation, Dimensions, Forms, Income Statement, Intercompany in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Action Menus - Help
    Summary:
    Using Action Menus - Form
    Content:

    Hi All,

    please, could you explain me how can I use Action Menus (Form) in a web data entry form?

    I need to link a detailed form starting from a syntex form (like Linked Form in HFM)?

    Regards,

    Francesco

  • Mandeep Singh
    Some accounts are shown in Journal Details but not roll to...19
    Topic posted December 6, 2019 by Mandeep SinghGreen Ribbon: 100+ Points, tagged Balance Sheet, Consolidation, Forms, Income Statement, Journals in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Some accounts are shown in Journal Details but not roll to Financial Statements
    Summary:
    Values for accounts set up under FCCS_Other Income Expense and FCCS_Provision for Income Tax are not showing on Data Forms. Values are getting shown for these accounts on Posted Journal
    Content:

    Values for accounts set up under FCCS_Other Income Expense and FCCS_Provision for Income Tax are not showing on Data Forms. Values are getting shown for these accounts on Posted Journal.

    Version:
    77.0.3865.120
  • Ed Graham
    Gartner releases Magic Quadrant for Cloud Financial Close...
    Topic posted November 21, 2019 by Ed GrahamRed Ribbon: 250+ Points, tagged Balance Sheet, Cash Flow, Consolidation, Eliminations, Income Statement, Intercompany, Journals, Supplemental Data in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Gartner releases Magic Quadrant for Cloud Financial Close Solutions (Hint: Oracle is a leader)
    Summary:
    I took the liberty of extracting the best bits for you out of the just published Gartner Magic Quadrant for Cloud Financial Close Solutions. It is nice to see Gartner positioning Oracle’s offering at
    Content:

    What is a Financial Close (FC) Solution?

     

    Financial Close (FC) solutions as defined by Gartner include the following components: Financial consolidation, Financial reporting, Reconciliation management, Close management, Intercompany transactions and Disclosure management.

     

    What does Gartner recommend for customers?

    1. Cloud FC solutions should be considered for almost all use cases and for new FC functionality a cloud solution should be the first choice
    2. Customers should transition from “point” FC solutions to suites to benefit from a common interface, common master data and common process management

     

    What does Gartner say about Oracle’s FC offering?

    Cloud FC offerings include Oracle Financial Consolidation and Close Service (Oracle FCCS), Oracle Account Reconciliation Cloud Service (Oracle ARCS) and Oracle Enterprise Performance Reporting Cloud Service (Oracle EPRCS) – a subset of Oracle EPM.

    • Oracle remains a leader due to its market traction with Oracle FCCS, supporting both midsize and large organizations
    • Scores well for both medium and complex FC process support
    • Oracle reference customers were pleased with the range of standard features in Oracle FCCS and highlighted the ease of use and navigability of Oracle ARCS
    • Oracle reference customers reported their top product selection criteria was the solution’s functional capabilities

     

    What other insights does Gartner have about the FC market?

    • Users tend to value functionality and more are requesting cloud deployments
    • Marketing of most cloud solutions are almost exclusively to the end user
    • There is increased willingness to put critical financial data in the public cloud
    • Cloud FC solutions have an increasing ability to integrate with cloud and on-premises solutions
    • A typical organization has deep penetration by Microsoft Excel for executing, monitoring and tracking financial processes and hence has much room for improvement
    • Sees a trend to improve financial management by automating manual processes and replacing customized solutions.
    • Predict popular add-on FC projects – Implementation of Disclosure management, Implementation of Reconciliation and Close Management, Extension of Process Management, Use of Workflow, Implementation of a systems for Intercompany transactions

    I hope this analysis is useful, you can download the full Gartner report from Oracle here -> https://go.oracle.com/LP=86556?elqCampaignId=220388

    Image:
  • Osama gamal
    FCCS Periodic ViewAnswered4
    Topic posted November 11, 2019 by Osama gamal, tagged Consolidation, Data Integration, Dimensions, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    FCCS Periodic View
    Content:

    I have issue in FCCS Application, i have two integration rules in Data Management
    1) Data integration from PBCS to FCCS
    2) Data integration between EBS file to FCCS,

    When i run any rule there are no issues in import and export data also i reviewed the monthly values and all values is correct in workbench screen.

    In data management i tried to map with Global period mapping and application and source period mapping (same values in all cases), so i think there is no problem with Data management.
    But after FCCS receive this data and Runing Consolidation rule, i found incorrect amounts for income statement accounts in all views except first period Jan (same values before run consolidation) . I loaded this data in FCCS_Periodic and FCCS_ Change in net income.
    So for short we can say the data loaded to FCCS is YTD not Periodic even though i mapped in periodic view member not YTD input and the Source data file has Periodic data amounts.
    So any one face this issue before or any one can advice.
    Is there any missing configuration or any thing i did it wrong?

    Also What are the steps that data needs to be translated to PTD in Data management in FCCS?

    There are two attached files with screenshots.

    Thanks in advance

    Version:
    19.11.59
    Document:
    Document:
    Document:
  • Carolina Rodríguez
    Reversal of Minority Interests
    Topic posted October 28, 2019 by Carolina RodríguezGreen Ribbon: 100+ Points, tagged Automation, Balance Sheet, Consolidation, Eliminations, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Reversal of Minority Interests
    Content:

    Hi,

    Somebody could help me how do you solve the case of the reversal of minority interests?

    When a consolidate owns the minority generated in another consolidated below its structure.

    Thanks!

    Image:
  • Carolina Rodríguez
    PPA - Purchase Price Allocation
    Topic posted October 28, 2019 by Carolina RodríguezGreen Ribbon: 100+ Points, tagged Automation, Balance Sheet, Consolidation, Eliminations, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    PPA - Purchase Price Allocation
    Summary:
    Calculations on a particular consolidation group
    Content:

    Hi,

    Somebody could help me how to generate consolidation calculations on a particular consolidation group?.

    Example: PPA - Purchase Price Allocation in a particular consolidation group.

    Thank you!

  • Harnesh Wadhwana
    Retained earnings for First year in FCCS1
    Topic posted October 23, 2019 by Harnesh Wadhwana, tagged Consolidation, Income Statement, Translations in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Retained earnings for First year in FCCS
    Summary:
    Retained earnings for First year in FCCS
    Content:

    Hi Guys,

    How to handle retained earnings for the very First year for each entities in FCCS ?

    what POV and what Exchange rate type should be selected to post those entries?

  • Steven Getze, CMA
    Valid Intersection Configuration4
    Topic posted October 18, 2019 by Steven Getze, CMARed Ribbon: 250+ Points, tagged Automation, Data Integration, Dimensions, Income Statement, Insertion Points, Reports, Smart View in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Valid Intersection Configuration
    Summary:
    Has anyone successfully developed?
    Content:

    In my Test application I have configured our full set of specific GL Account & Department Valid Intersections (each "rule" is composed of the account, its associated "valid" department combinations, plus the years of 2018 thru 2021).  This is necessary, because we occasionally see invalid combinations in entity loads but have no way to identify them; the presence of them causes FCCS's Net Income to be incorrect.  Now I am testing and viewing available reporting.   As a test, I loaded an entity load file to August 2019 via Data Management that includes an invalid account/department combination, and expect to see this invalid combination when I run an Invalid Intersection report.  But, I do not, even when I create the report that include the specific "invalid" intersection.   Additionally, when I run an "open" report with no optional dimensions, I only get data for FY2015.   This makes no sense, since I identify only FY18 thru FY21 within the rules .   

    I suspect my configuration is flawed - it seems straightforward so I have no idea what is flawed.   I can find nothing in Oracle publications to assist me. 

    Has anyone successfully developed Valid Intersections in FCCS who can tell me what I'm doing wrong?   I have attached an excel file that shows the invalid combo in an adhoc plus screenshots of my configuration.   I appreciate any guidance.

  • Pamela Stone
    Basic Balance Sheet hierarchy and alternate2
    Topic posted October 16, 2019 by Pamela Stone, tagged Balance Sheet, Dimensions, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Basic Balance Sheet hierarchy and alternate
    Summary:
    Placement of alternate income statement accounts using Basic Balance Sheet hierarchy
    Content:

    Hello,

    Using the new Basic Balance sheet hierarchy, works for client because they have more flexible on how to build out their hierarchy.  No issues with ownership management, overrides or data movement within the movement dimension.  Only unknown with the basic balance sheet hierarchy is where to place the alternate income statement hierarchy.  Unlike the traditional balance sheet approach,  FCCS_Income Statement is not present when the Basic Balance sheet hierarchy is selected so unsure of where the alternate income statement accounts should be placed.    I am leaning towards placing the alternate income statement hierarchy directly under the top parent of the account dimension,  Account.    Has anyone else had a similar situation at their client?  If yes,  where did you place the alternate income statement accounts.

    Thanks

    Pamela

    Version:
    19.09.72
    Image:
  • Antonio Barbaro
    Hierarchy Order in FCCS Account DimensionAnswered3
    Topic posted September 18, 2019 by Antonio BarbaroGold Medal: 3,500+ Points, tagged Balance Sheet, Consolidation, Dimensions, Income Statement in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Hierarchy Order in FCCS Account Dimension
    Summary:
    Hierarchy Order in FCCS Account Dimension
    Content:

    Hi All,
    I have a question related to Hierarchy Order in FCCS Account Dimension.
    A month ago I modified the order of "Income Statement Hierarchy" than the predefined order ("Income Statement Hierarchy" is above "Balance Sheet Hierarchy").
    After last automatic update, I see the native order of the Account Dimension ("Income Statement Hierarchy" is below the "Balance Sheet Hierarchy").
    In this way, I have a surplus because the Income Statement Hierarchy was created as shared Member in "Balance Sheet Hierarchy". If I have to respect the native order I need to create the "Income Statement Hierarchy" as a shared member.
    Thanks in advance,
    Antonio