Load data to ERP user-mapping table for Oracle EBS

  • 릴리스 버전: Australia
  • 업데이트 날짜 2026년 03월 12일
  • 소요 시간: 2분

    • Set up Oracle EBS and ERP User ID mapping for the integration to work. The mapping is maintained for all active users who have the procurement buyer role in ERP. These users should be used in the requisition assignment rule.

    시작하기 전에

    Role required: sn_shop.procurement_administrator

    프로시저

    1. Navigate to All > System Import Sets > Load Data.
    2. Select Create table and enter a label for the new table in the Label field.
    3. In the Source of the import field, select the File option.
    4. Select Choose File to import the source Excel spreadsheet.
      그림 1. Load data to ERP user-mapping table for Oracle EBS
      Load data to ERP user mapping table for Oracle EBS
    5. 옵션: If appropriate, specify the Work sheet and Header row number.
    6. Select Submit.
      The imported data is now available in the new Import Set table.
    7. Create a transform map to define the field mapping between columns of the import set and columns of the target ERP User Mapping [sn_fcms_intg_erp_user_map] table.
      The ERP User Mapping table maintains mapping between ERP user IDs and ServiceNow user IDs.
    8. Transform the data from the import set table to the target table.
      For more information, see Run an import.
      The data is imported into the Oracle EBS ERP User Mapping (sn_fcms_intg_erp_user_map) table.

    다음에 수행할 작업

    Verify that the data records are imported into the target table. You can view the Oracle EBS ERP user mappings by navigating to Finance - ERP Integration > ERP Users.
    주:
    If an ERP user mapping isn’t required, you can deactivate it. To deactivate a mapping, in the ERP User Mapping form, select the Inactive check box.