Define ERP source configuration for Oracle EBS

  • Release version: Xanadu
  • Updated March 12, 2025
  • 1 minute to read

    • ERP source configuration determines the ERP source to which your ERP system connects. Map the integration payload with the Oracle EBS tables.

    Before you begin

    Role required: sn_shop.procurement_administrator

    About this task

    By default, the base system includes one ERP source named Oracle EBS, which refers to the parent connection for Oracle EBS. If there are multiple Oracle EBS instances, multiple ERP sources must be configured, and the child connections for these Oracle EBS instances should be referenced.

    Each ERP instance requires a unique ERP source configuration. Therefore, 10 ERP instances need 10 configurations.

    Procedure

    1. Navigate to All > Finance – ERP Integration > ERP Source Configuration.
    2. In the ERP Configurations view, select Oracle EBS.

      This configuration is available as a part of the base system.

    3. To edit the ERP source, select here.
    4. Select the required ERP source for the Oracle EBS using the search option.
    5. To create a new ERP source, perform the following steps:
      1. Select New.
      2. On the form, fill the fields.
        Table 1. Define a new ERP source configuration
        Field Description
        ERP Source ERP source for which the integration is required. For example, Oracle EBS.
        Short Description Summary of the ERP source.
        Active Option to activate the ERP source.
        Amount Precisions Amount precision of the ERP source. For example, 2.
        Figure 1. Define a new ERP source configuration for Oracle EBS
        Define a new ERP source configuration for Oracle EBS
      3. Select Submit.
        A new ERP source is created. Verify that the connection alias is also unique for each ERP source.
        Note:
        Oracle EBS integration can have multiple ERP sources. The Staging table displays the ERP source column, which you can use to distinguish which ERP the data belongs to.

    What to do next

    By default, the Oracle EBS base system provides 13 services mapping. For other Oracle EBS instances, you need to perform the following:
    • Define service mappings manually for each integration service by accessing the Service Mappings related list. You can define element level mapping between Oracle EBS table fields and payload elements.
    • Map the users and corresponding ERP User IDs by accessing the ERP User Mappings related list.