1. Sync Items from Oracle Fusion Cloud SCM to Epic
  2. Configure the Recipe

Configure the Recipe

Before you activate and run the recipe, you must configure its resources.

To configure the recipe, on the recipe card, click Configure. The Configuration Editor opens displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe:
  • FTP connection
  • Oracle ERP Cloud connection
  • Oracle WebCenter Content connection
  • Oracle ERP Cloud REST connection
  • Lookup tables

Configure the FTP Connection

  1. In the Connections section, click Oracle FTP connection. The connection configuration page appears.
  2. In Properties, enter the FTP server host address and FTP server port. For example, ftp.servr.com and port 22.
  3. In Optional Properties, enter the following details.
    Field Information to Enter
    SFTP Connection Yes
  4. In the Security section, enter the following details.
    Field Information to Enter
    Security policy FTP Server Access Policy
    User Name Enter the user name of the account created for Oracle Integration on FTP server.
    Password Enter the password of the account created for Oracle Integration on FTP server.
  5. In Access Type, select Public gateway.
  6. Click Test to make sure that your connection is successfully configured. A message confirms whether your test is successful.
  7. Click Save. If prompted, click Save again.
  8. To return to the previous page, click Go back Go Back icon.

Configure the Oracle ERP Cloud Connection

  1. In the Connections section, click Oracle ERP Cloud Connection.
  2. In the Properties section, enter the Oracle ERP Cloud host name. For example, https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details.
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  4. In Access Type, select Public gateway.
  5. Click Test to make sure that your connection is successfully configured. In the displayed dialog box, click Test again. A message confirms if your test is successful.
  6. Click Save. If prompted, click Save again.
  7. To return to the previous section, click Go back Go Back icon.

Configure the Oracle WebCenter Content Connection

  1. In the Connections section, click the Oracle WebCenter Content connection to edit.
  2. In the Properties section, enter the WSDL URL. For example, https://your_domain_name /idcws/GenericSoapPort?wsdl
  3. In the Security section, enter the following details.
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  4. In the Access Type, select Public gateway.
  5. Click Test to make sure that your connection is successfully configured. In the displayed dialog box, click Test again. A message confirms if your test is successful.
  6. Click Save. If prompted, click Save again.
  7. To return to the previous page, click Go back Go Back icon.

Configure the Oracle ERP Cloud REST Connection

  1. In the Connections section, click Oracle ERP Cloud Rest Connection. The connection configuration page appears.
  2. In the Properties section, enter the following details.
    Field Information to Enter
    Connection Type Select REST API Base URL.
    Connection URL Enter the Oracle ERP Cloud host name. For example, https://your_domain_name.fa.DC.oraclecloud.com
  3. In the Security section, enter the following details.
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  4. In the Access Type, select Public gateway.
  5. Click Test to make sure that your connection is successfully configured. In the displayed dialog box, click Test again. A message confirms if your test is successful.
  6. Click Save. If prompted, click Save again.
  7. To return to the previous page, click Go back Go Back icon.

Configure the Lookup Tables

The following lookup tables map the fields from Oracle ERP Cloud to Epic.
Lookup Table Name Description
OracleSCM_StandardFields Maps the XML tags for predefined attributes in Oracle ERP Cloud with Epic.
EpicEHR_FTPDetails Provides the folder locations for loading the file to Epic.
OracleSCMEpicEHR_EmailContacts Sets up email contacts who would be notified in case of failures.
EpicEHR_Contants

Maintains the static values for attributes in Epic.
To configure the lookup table:
  1. In the Lookups section, click the lookup name to edit.
  2. Configure the following lookup tables:
    Lookup Table Name Information to Enter
    OracleSCM_StandardFields
    • In the EpicEHRField column, enter the attribute name for Epic EHR.
    • In the OracleSCM_ParentNode column, enter the value of parent node for attribute mapped in the publish payload from Oracle ERP Cloud.
    • In the OracleSCM_ChildNode column, enter the value of attribute node in the publish payload group name in publish payload from Oracle ERP Cloud.
    EpicEHR_FTPDetails
    • In the DirectoryName column, enter the value of directory name.
    • In the DirectoryValue column, provide the path for the directory name provided on the file server.
    OracleSCMEpicEHR_EmailContacts
    • In the Contact column, enter the value From and To for the error email notifications.
    • In the EmailID column, enter the email IDs for the error email notifications.

    These fields are prepopulated for Standard integration.
    EpicEHR_Contants
    • In the DataElementName column, enter the attribute name that’s constant for Epic EHR.
    • In the DataElementValue column, enter the value of constant attribute in Epic EHR.
    • Provide the SpokeSystemCode and MasterOrganization values.

    These fields are prepopulated for Standard integration.
  3. To return to the previous page, click Go back Go Back icon.