Posts

Posts

  • Gianluca Natili
    Loading data on FCCS using Data Management8
    Topic posted November 28, 2019 by Gianluca NatiliRed Ribbon: 250+ Points, tagged Data Integration, Security in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Loading data on FCCS using Data Management
    Content:

    Hi All,

    I need to enable users to load data in FCCS using Data Management. Each user must upload data for his own entity. My idea is to create n location and n data load rule for each entity and assign it to the users. I would like to use an open batch to avoid error from users. I need that user can only see and run his own open batch but I can't get it, maybe I'm in a wrong way. Any idea to be compliant with this scenario?

    Thank you

    Gianluca

  • Al Marciante
    EPM – Tax Reporting Product Update, 18 December 2019, 9 a...
    Topic posted November 25, 2019 by Al MarcianteBronze Trophy: 5,000+ Points, tagged Consolidation, Data Integration, Reports, Tax Provision, Tip in Enterprise Performance Mgmt > Tax Reporting public
    Title:
    EPM – Tax Reporting Product Update, 18 December 2019, 9 a.m. PT - Submit Questions
    Content:

    Submit your questions for the EPM – Tax Reporting Product Update session to have them answered during the live event.

    Post your questions by posting a new comment to this topic. Please submit your questions by Tuesday, 17 December 2019.

  • Bernardo Andres Neira
    Loading Data using Data Management - Accumulate like...8
    Topic posted November 13, 2019 by Bernardo Andres NeiraGold Medal: 3,500+ Points, tagged Data Integration in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Loading Data using Data Management - Accumulate like behavior
    Summary:
    Loading Data using Data Management - Accumulate like behavior
    Content:

    Hi guys,

    I'm trying to load data to FCCS using DM, and appartently my understanding of the Merge - Export Mode is wrong.

    I thought merging data would not replace my old data for a given POV but rather add to the values previously loaded.

    Looking to a FDMEE manual I'm seeing there is another export option called "Accumulate" which seems to do the trick is there anyway to accomplish this by loading with Data Management ??

    Thanks

     

  • Antonio Barbaro
    Error in Loading data by Data ManagementAnswered17
    Topic posted November 12, 2019 by Antonio BarbaroSilver Medal: 2,000+ Points, tagged Data Integration in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Error in Loading data by Data Management
    Summary:
    Error in Loading data by Data Management
    Content:

    Hi All,

    I'm trying to load a file csv vs FCCS by using Data Management.

    Until FY39 - October, the system works correctly but from FY39 - November I have the following error:

    Error: Data rows with unmapped dimensions exist for Period 'Nov-2039'

    I have deleted the periods and re - created the periods in Data Management but the problem persists.

    Do you have an idea?

    Regards,

    Antonio

     

  • Antonio Barbaro
    FDMEE - Update Metadata of a New ApplicationAnswered1
    Topic posted November 11, 2019 by Antonio BarbaroSilver Medal: 2,000+ Points, tagged Data Integration in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    FDMEE - Update Metadata of a New Application
    Summary:
    FDMEE - Update Metadata of a New Application
    Content:

    Hi,

    I have a problem in Data Management when I try to Refresh Metadata of a consolidation Application.

    I go to "Target Application" --> "Select the Application" --> Click on "Refresh Member".

    If I go to "Process Details" I have an error but I don't have a log (log file is empty).

    Antonio

    Image:
  • Jai Prakash Ojha
    EPM Integration AgentAnswered2
    Topic posted November 11, 2019 by Jai Prakash Ojha, tagged Data Integration in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    EPM Integration Agent
    Summary:
    EPM Integration Agent not connecting
    Content:

    Dear All

    I have followed the steps as per admin guide for startup parameters for configuring EPM Agent.

    However, when i run the agent, it gives error as below. (in the image attached)

    Below is the log file - 

     oracle.epm.aif.agent.server.ServerExecutor main
    INFO: Parameter GROOVY_HOME is blank in startup parameter file
    Parameter CUSTOM_INTERFACE_CLASS_NAME is blank in startup parameter file
    Nov 11, 2019 10:30:35 PM oracle.epm.aif.agent.server.ServerExecutor main
    SEVERE: java.lang.IllegalArgumentException: Illegal character(s) in message header value: Basic Z3JlZW5jdWJlZ2xvYmFsLmphaXByYWthc2hvQGdyZWVuY3ViZWdsb2JhbC5jb206R3JlZW5jdWJl
    QDEyMzQ=
    Nov 11, 2019 10:30:35 PM oracle.epm.aif.agent.server.ServerExecutor main
    SEVERE: com.sun.jersey.api.client.ClientHandlerException: java.lang.IllegalArgumentException: Illegal character(s) in message header value: Basic Z3JlZW5jdWJlZ2xvYmFsLmphaXByYWthc2hvQGdyZWVuY3ViZWdsb2JhbC5jb206R3JlZW5jdWJl
    QDEyMzQ=
    at com.sun.jersey.client.urlconnection.URLConnectionClientHandler.handle(URLConnectionClientHandler.java:149)
    at com.sun.jersey.api.client.Client.handle(Client.java:648)
    at com.sun.jersey.api.client.WebResource.handle(WebResource.java:670)
    at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
    at com.sun.jersey.api.client.WebResource$Builder.get(WebResource.java:503)
    at oracle.epm.aif.agent.service.RestService.executeSSLGetCall(RestService.java:109)
    at oracle.epm.aif.agent.server.ServerExecutor.checkAgentFeature(ServerExecutor.java:288)
    at oracle.epm.aif.agent.server.ServerExecutor.registerAgent(ServerExecutor.java:326)
    at oracle.epm.aif.agent.server.ServerExecutor.main(ServerExecutor.java:447)

     

     

     

     

    Version:
    19.11.59
    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:
  • Antonio Barbaro
    Change Order of Column in Data Management25.0
    Topic posted November 11, 2019 by Antonio BarbaroSilver Medal: 2,000+ Points, tagged Data Integration in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Change Order of Column in Data Management
    Summary:
    Change Order of Column in Data Management
    Content:

    Hi All,

    is it possible to change the order of the columns in File txt generated by Custom Application in FDMEE?

    In this moment I have this order:

    ACCOUNT,ENTITY,ICP,UD3,UD4,UD6,UD7,UD8,UD9,UD10,UD11,UD12,UD13,UD14,UD15,UD16,UD17,UD18,AMOUNT

    My need is to have this order:

    ENTITY,ACCOUNT,UD3,UD4,UD6,UD7,UD8,UD9,UD10,UD11,UD12,UD13,UD14,UD15,UD16,UD17,UD18,ICP,AMOUNT

    Regards,

    Antonio

     

  • Ellie Sait
    Two Data Sources1
    Topic posted November 8, 2019 by Ellie Sait, tagged Data Integration in Enterprise Performance Mgmt > Tax Reporting public
    Title:
    Two Data Sources
    Summary:
    What is the best method of bringing in and consolidating two data sources into TRCS?
    Content:

    We have two data sets which need importing to TRCS, these data sets will have the same accounts, entities, jurisdictions etc but one data set is completed at local level and one contains supplementary adjustments by group. We would like to flag these data sets as being from separate sources but do need them to consolidate together. Can we use any dimension fields to solve this problem?

    Version:
    19.10.63
  • Yan CAI
    Data management Export data (Security control)Answered3
    Topic posted November 7, 2019 by Yan CAIRed Ribbon: 250+ Points, tagged Data Integration, Security in Enterprise Performance Mgmt > Financial Consolidation and Close public
    Title:
    Data management Export data (Security control)
    Content:

    Hi Experts,

     

    I have a case about FCCS access control needs your suggestions, Thanks in advance.

    Power users in the application cannot export data from data management to FCCS.

    >> User setting in MyService Platform: Power User

    >> User access control in FCCS: All

    >> Entity access control: IDescendents of E4002 Consol

    Looking forward for yours reply.

     

    Thanks and Regards,

    Yan

     

     

    Version:
    19.11.57
    Image: