Enterprise Performance Mgmtpublic

Financial Consolidation and Close

Get Involved. Join the Conversation.

This is a public Forum  public

Topic

    Antonio Barbaro
    Error in Loading data by Data ManagementAnswered
    Topic posted November 12, 2019 by Antonio BarbaroSilver Medal: 2,000+ Points, last edited November 12, 2019, tagged Data Integration 
    31 Views, 13 Comments
    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

     

    Best Comment

    Antonio Barbaro

    Hi,

    i found this document;

    https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=315701262187780&_afrWindowMode=0&id=2548568.1&_adf.ctrl-state=19p1njnafo_4

    For the moment there are no solution.

    Regards

    Comment

     

    • Wayne Paffhausen

      Hello Antonio,

      This error has nothing to do with the period/time/pov.  The message is a bit confusing.  The key part is the first part:  Error: Data rows with unmapped dimensions exist
      The period/time/pov for which the error occurs is:  for Period 'Nov-2039'

      I hope this helps break down the string you provided.

      Thank you,
      Wayne

    • Antonio Barbaro

      Hi Wayne,

      I understood because the problem occours from November 2039 and befor 2039 I have no problem.

      Can you help me? I don't Know what I have to check...

      Antonio

       

      • Ankit kumar Shrivastava

        Hey Antonio,

        This means you have unmapped dimensions in data rows. Navigate to the POV in workbench and look under the Validation Errors tab for the unmapped members.

        Thank you,

        Ankit 

    • Antonio Barbaro

      Hi Ankit,

      I have no problem in validation phase because i'm not able to complete import phase (see attached immage).

      The problem occours from November 2039, until October 2039 I have no problem.

      Thanks in advance,

      Antonio B. 

       

    • Antonio Barbaro
    • Antonio Barbaro

      Hi, 

      I found another error….I deleted all periods from FY39 to FY44 in FDMEE..Then I created each periods..

      Now I'm able to import data until October FY39.

      When I launch Import Phase of November FY39 I have a warning (see attached image).

      I verified the period and I see correctly 11-30-2039 but it seems that in the system there is 11-30-1939.

      Is it a problem related to calendar?

       

    • Antonio Barbaro

      Hi,

      i found this document;

      https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=315701262187780&_afrWindowMode=0&id=2548568.1&_adf.ctrl-state=19p1njnafo_4

      For the moment there are no solution.

      Regards

    • Thejas Shetty

      Antonio,

      Can you try executing the rule(integration) from the SUI? (Data Exchange) & confirm if you are getting similar results?

      Let me know if you are not familiar with the SUI interface.

      Regards,

      Thejas

    • Thejas Shetty

      Now that we are in December, you should have no issues with Nov-2039 :)

      The mystery is explained here: ;)

      https://stackoverflow.com/questions/36363972/java-mm-dd-yy-simple-date-datetimeformatter-not-working-for-greater-than-2037/36364135

     

    community forum