Financial Consolidation and Close

Get Involved. Join the Conversation.

Topic

    Reshma Kara
    FCCS - Data Management - Rounding
    Topic posted October 25, 2019 by Reshma KaraRed Ribbon: 250+ Points, tagged Data Integration 
    75 Views, 7 Comments
    Title:
    FCCS - Data Management - Rounding
    Summary:
    Data loads vary on user profiles
    Content:

    Good Day,

    Can you please advise of the following:

    We are currently loading flat file TB's using data management to FCCS, when a user logged on as an administrator loads the data, the data is divided by a 1000 which is correct.

    A user logged in as a FCCS user with Run Intergration permission in FCCS loads the data using Data Management, the data is not divided by a 1000.

    Please advise how we can resolve this.

    Regards

     

     

     

     

    Comment

     

    • Brian Butler

      As an update to this issue, we believe we have found the reason behind this but cannot fix it and Oracle will need to resolve this.

      For administrators, when Data Management loads data it uses a load method called OLU, shown in the attached file Screen Shot 1.
      Non administrators use a different load method called REST, shown in the attached file Screen Shot 2.

      The OLU method scales and the REST method does not shown in the attached file Screen Shot 3 and 4.

      As a result of this when non admin users load the data there is a 1’000 difference.
      We need both methods to scale but have no control over those methods, if Oracle can please assist.

       

    • Antonio Barbaro

      Hi,

      please follow my advice:

      - verify user preferencies for two users (thousands and decimals separators);

      - verify language of browser for two users,

      Antonio

    • Brian Butler

      Hi Antonio

      It has nothing to do with browsers, the issue is how DM loads the data based on the user role.
      Please see the detailed screen shots in the word doucment previously attached, and you will see what DM is doing on the two loads.
      The two different methods used by DM is what is causing the issue.

      - verify language of browser for two users,
      We tried the two users on the same machine and the same browser, the issue still exists.

      - verify user preferences for two users (thousands and decimals separators);
      N/A
      We even tried the same user (so it’s their preferences)
      When that user was a service administrator role
                 DM divides by 1000 when it loads to FCC.

      When the user was any other role.
                  DM does not divide by 1000 when it loads to FCC.

    • Antonio Barbaro

      It's very strange.

      I had the same problem in Data Management for HFM and the problem was related to different preferencies set for the users.

      If the preferencies are the same I don't know what is the problem.

      I image that the file is the same? Two users are loading the same file, with the same numbers (decimal and thousands separator?)?

      Regards

       

    • Brian Butler

      Hi Antonio

      Yes the file is the same identical file while we loaded to test.

      Please look at the docx file I upload, you can see exactly what DM is doing and that DM uses a profile to load data to FCC.
      The profile it users for an demonstrator is different to everyone else.

      I have even highlighted the two profiles being used.

    • Antonio Barbaro

      Hi,

      I saw but it is very strange.

      You can try to open a SR.

      Regards,

      Antonio

       

    • Antonio Barbaro

      Please,

      can you verify in Data Management --> Setup --> user Setting?

      Please verify if the users have different settings.

      Antonio