Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Antonio Barbaro
    Error in Loading data by Data ManagementAnswered
    Topic posted November 12, 2019 by Antonio BarbaroGold Medal: 3,500+ Points, last edited November 12, 2019, tagged Data Integration 
    40 Views, 17 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

      • Antonio Barbaro

        Hi Thejas,

        I don't know what is SUI interface.

        Please, could you explain me?

        Regards,

        Antonio

        • Thejas Shetty

          SUI stands from Simplified User Interface.

          You can access a subset of features of Data Management from Data Exchange card within the Planning application. This SUI will eventually replace the classic ADF UI for DM you are currently using after all the features have been built using SUI.

          For your purpose:

          • Navigate to Data Exchange from the Navigator menu,
          • The data load rules will be listed as "Integrations"
          • Locate your Integration(data load rule) & click on it to select the integration. (Do not click on the hyperlink on the "Name" field)
          • Click the I> (run) button to run the integration.
          • Choose the start/end period & note the processID.
          • Actions->Process Details to view Process Details.
          • Click the ... button on the integration row(rightmost corner) & click on Workbench to view data.
      • Antonio Barbaro

        Hi,

        I don't Know If I understood but I have to launch the import data file by Load Data Rule?

    • 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

      • Antonio Barbaro

        Hi,

        Can I do in order to solve the problem?

        Regards,

         

        • Thejas Shetty

          Its an unhandled Y2K issue in the ADF page. Nothing to do with your period mappings.

          Using SUI page should solve it. (already explained in a different comment)

      • Antonio Barbaro

        Hi,

        I tried to set the period dec-39 as 12/31/2139 but when I try loading file I have the same error.

        I Thinks that is an issue.

        Antonio