Posts

Posts

  • 1-6 of 6
  • Eric Erikson
    Insertion rules not executing without reloading data12
    Topic posted November 7, 2019 by Eric EriksonBlue Ribbon: 750+ Points, tagged Consolidation, Insertion Points in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Insertion rules not executing without reloading data
    Content:

    We have insertion rules (in 10) to populate the movement member from closing balance input. Made a change to those rules (changed the destination movement members). Validated and deployed the rule and reconsolidated. Didn't see the change taking effect, so tried a force consolidate and still didn't see a change. Only when we reloaded the data - the exact same data - did we see the change take effect. 

    Seeing no errors in the Jobs log. The EnableOptimalBlockCreation variable is set to True.

    Anyone having this issue, or better yet solved it? Not liking the thought of reloading every scenario/year/period after every rule change.

    Thanks,
    Eric

     

    Version:
    19.10.63
  • 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.

  • Elena Medrano
    Data can be inserted on "Not started" periodsAnswered1
    Topic posted October 16, 2019 by Elena MedranoBronze Medal: 1,250+ Points, tagged Insertion Points in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Data can be inserted on "Not started" periods
    Summary:
    Data can be inserted on "Not started" periods
    Content:

    Hi,

    Despite having the october period not started on my application, I can insert data. The same is happening with all future periods from september (the last started month). I would expect data cannot be introduced on future periods since they have not been started. Is something I am missing?

    Thanks.

    Version:
    FCCS 19.09.72
    Document:
    Status.jpg (11KB)
  • Mihajlo Belosevic
    FCCS - Code snippet for YTD_InputAnswered4
    Topic posted September 19, 2019 by Mihajlo BelosevicRed Ribbon: 250+ Points, tagged Consolidation, Dimensions, Insertion Points, On Demand Rules in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    FCCS - Code snippet for YTD_Input
    Summary:
    Script for calculating periodic movement based on YTD_Input
    Content:

    Hello guys,

    I'm aware that this topic has already been mentioned before, but I would be really grateful if someone could send me a part of script for calculating Periodic Movement based on YTD_Input. Our client would like to input only year to date values for both Balance Sheet and P&L accounts (current configuration is opposite, they have to enter period movement values and run consolidation in order to get Closing Balance), and for this we need to make a rule. I'm not sure do I need to trigger each base level account, do I have to use UDA for these purposes,...Some help would be appreciated :)

    Thanks all !

    BR, Mihajlo

    Version:
    19.08.70
  • Mihajlo Belosevic
    Designer mode not possible
    Topic posted September 17, 2019 by Mihajlo BelosevicRed Ribbon: 250+ Points, tagged Consolidation, Insertion Points in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Designer mode not possible
    Summary:
    Cannot run Designer mode in Calculation Manager
    Content:

    Hi everybody,

    Does anyone have any idea why I cannot switch to designer mode within the Calc Manager ? Within the FCCS_10_After Opening Balance Carry Forward_LocalCurrency we have added some code lines, which I can see in Edit Script mode, but when I want to see it in Designer mode I only see the loading preset, which seems to last endlessly. Am I doing something wrong ? I tried in both FCCS and PBCS applications just to check, but the situation is same...

    Thanks !

    BR, Mihajlo

    Version:
    19.09.70
  • Elena Medrano
    Copy Override DataAnswered10
    Topic posted September 17, 2019 by Elena MedranoBronze Medal: 1,250+ Points, tagged Data Integration, Insertion Points in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Copy Override Data
    Summary:
    Copy override data with "Data Copy" action
    Content:

    Hi everyone,

    I am trying to copy override data from one scenario "A" to another scenario "B". I have introduced the data on scenario "A" through the predefined override forms, and I am executing the "Application"-> "Overview" -> "Actions" -> "Copy Data". Despite the job says the process is OK I am not able to see the override values on the scenario "B". Am I doing something wrong?

     

     

    Version:
    19.09.70
    Document: