Applications Security

Get Involved. Join the Conversation.

Topic

    Achala Munasinghe
    How to upload users to ERP CloudAnswered
    Topic posted February 6, 2018 by Achala MunasingheGold Medal: 3,500+ Points, last edited January 30, 2019, tagged Configuration, Financials, Help Center, Search, Setup / Administration 
    532 Views, 13 Comments
    Title:
    How to upload users to ERP Cloud
    Summary:
    Spreadsheet upload for fusion ERP Cloud
    Content:

    Hi All,

    What is the methodology to upload user accounts to Fusion ERP Cloud who has not subscribed for Fusion HCM Cloud?

    Many thanks in advance.

     

    Regards

    Achala

     

    Best Comment

    Mansur Khalil

    Here is the file you can use to create an user and sametime add roles to that user.

     

    METADATA|User|PersonNumber|Suspended
    METADATA|UserRole|PersonNumber|RoleCommonName|AddRemoveRole
    MERGE|User|12312|N
    MERGE|UserRole|12312|ORA_PER_EMPLOYEE_ABSTRACT|ADD
    MERGE|UserRole|12312|ORA_PER_LINE_MANAGER_ABSTRACT|ADD
    

    Thanks

    Mansur

    Comment

     

    • Rohan Kamat

      Not sure , if there is any spreadsheet available . You need to create users via "Manage users" only . Kindly raise an SR to confirm 

      Thanks 

      Rohan

       

    • Sachin Mistry

      Have you looked at HCM data load? There are ways to create users in bulk, assign them roles, assign them data roles.

      • Achala Munasinghe

        Hi,

        The problem here is the customer has not subscribed to fusion HCM, only ERP Cloud.

      • Achala Munasinghe

        Hi,

        Thanks for the comment. Could you please share the template you refer to load users in bulk, assign them roles, assign them data roles.

        Thanks

        Achala

        • Sachin Mistry

          https://docs.oracle.com/en/cloud/saas/applications-common/r13-update17d/faihm/preparing-to-use-hcm-data-loader.html#FAIHM2675426

    • Sachin Mistry

      HCM is shared install. You should be able to do use it.

    • Wendy Ware

      Sachin is correct.  When you open an SR for assistance classify it as HCM Service Type (or request to have your request transferred to the HCM team.)

    • Mansur Khalil

      Here is the file you can use to create an user and sametime add roles to that user.

       

      METADATA|User|PersonNumber|Suspended
      METADATA|UserRole|PersonNumber|RoleCommonName|AddRemoveRole
      MERGE|User|12312|N
      MERGE|UserRole|12312|ORA_PER_EMPLOYEE_ABSTRACT|ADD
      MERGE|UserRole|12312|ORA_PER_LINE_MANAGER_ABSTRACT|ADD
      

      Thanks

      Mansur

      • Achala Munasinghe

        Hi Mansur,

        Great! This is what I was searching for. Could you please let me know how do we add first name, last name, department and position details as well?

        Many thanks.

        Regards

        Achala

      • Sergiu D

        Hi Mansur,

         

        I know that is an old post, but still maybe you can advise.

        I took your file just for this one user to test, but it show error

        The component discriminator User is invalid. The line with instruction METADATA must include a discriminator that is supported by the object Worker. (HRC-1035269)

         

        Am I missing anything here?

         

        Thank you in advance.

        Worker.dat (225 Bytes)
    • Mansur Khalil

      You have to create them using the Worker.dat file and upload that using HCM data loader. 

      based upon your need you can create them as an employee, pending worker, contingent worker or non worker. 

      with the user file you can just create users and assign the roles to the users so that those users are active.

      Please let me know if you need any more details. 

       

      thanks

      Mansur Aulam

       

      • Zubin Shah

        Can you provide a sample file/spreadsheet for this? Also, what task or ucm account do you use to upload the file?