1. Sync Items From Oracle Fusion Cloud SCM to Oracle Health EHR
  2. Configure the Accelerator

Configure the Accelerator

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

To configure the accelerator, on the accelerator card, click Configure Configure icon.

The Configuration Editor opens displaying all the resources of the accelerator. Configure the following resources before you activate and run the accelerator:
  • FTP connection
  • Oracle ERP Cloud connection
  • Oracle WebCenter Content connection
  • Lookup tables

Configure the FTP Connection

  1. In the Connections section, click the FTP connection name to edit. 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
    SFTP Key Exchange Algorithm diffie-hellman-group1-sha1
    SFTP Preferred PKI Algorithm ssh-dss
  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 if 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 Lookup Tables

The following lookup tables map the fields from Oracle ERP Cloud to Oracle Health EHR.
Lookup Table Name Description
OracleSCMOrganizationMapping Maps the Inventory Organizations in Oracle ERP Cloud and Organizations in Oracle Health EHR
OracleSCMSubinventoriesMapping Maps the Item Subinventories in Oracle ERP Cloud and Locators in Oracle Health EHR
OracleSCMLocatorsMapping Maps the item locators in Oracle ERP and locators at Oracle Health EHR
OracleUOMMapping Maps the unit of measures in Oracle ERP Cloud and unit of measure at Oracle Health EHR
OracleSCM_StandardFields Maps the XML tags for predefined attributes in Oracle ERP Cloud with Oracle Health EHR
OracleSCM_DynamicFields Maps the XML tags for user-defined attribute mapping in Oracle ERP Cloud with Oracle Health EHR
OracleSCMTransactionMapping Maps the transaction type for item location and locators for Oracle Health EHR
OracleLatexIndicatorMapping Maps the value of Latex indicator at Oracle ERP Cloud and Latex indicator at Oracle Health EHR
OracleSCMChargeableIndicatorMapping Maps the value of Chargeable indicator at Oracle ERP Cloud and Chargeable at Oracle Health EHR
OracleHealthEHR_FTPDetails Provides the folder locations for loading the file to Oracle Health EHR
OracleSCMOracleHealthEHR_EmailContacts Sets up email contacts that would be notified in case of failures
OracleHealthEHR_Contants Maintains the static values for attributes at Oracle Health EHR
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
    OracleSCMOrganizationMapping
    • In the SCMOrganization column, enter the value of the Inventory Organization code in Oracle ERP Cloud.
    • In the OracleHealthEHROrganization column, enter the value of Oracle Health EHR Organization.
    OracleSCMSubinventoriesMapping
    • In the SCMSubinventories column, enter the value of the Subinventory code in Oracle ERP Cloud.
    • In the OracleHealthEHRLocation column, enter the value of Oracle Health EHR Location.
    OracleSCMLocatorsMapping
    • In the SCMLocators column, enter the value of Locator code in Oracle ERP Cloud .
    • In the OracleHealthEHRLocator column, enter the value of Oracle Health EHR Locator.
    OracleUOMMapping
    • In the OracleSCMValue column, enter the value of Unit of Measure Code in Oracle ERP Cloud .
    • In the OracleHealthEHRValue column, enter the value of Unit of Measure in Oracle Health EHR Locator.
    OracleSCMTransactionMapping
    • In the OracleSCMValue column, enter the value of the Transaction Type in Oracle ERP Cloud.
    • In the OracleHealthEHRValue column, enter the value of the Transaction Type in Oracle Health EHR Locator.
    These fields are prepopulated for standard integration.
    OracleLatexIndicatorMapping
    • In the OracleSCMValue column, enter the value of Latex Indicator in Oracle ERP Cloud.
    • In the OracleHealthEHRValue column, enter the value of Latex Indicator in Oracle Health EHR Locator.
    These fields are prepopulated for standard integration.
    OracleSCMChargeableIndicatorMapping
    • In the OracleSCMValue column, enter the value of Charge Indicator in Oracle ERP Cloud .
    • In the OracleHealthEHRValue column, enter the value of Charge Indicator in Oracle health EHR Locator.
    These fields are prepopulated for standard integration.
    OracleHealthEHR_FTPDetails
    • In the DirectoryName column, enter the value of directory names for Stage and CernerLoc Indicator.
    • In the DirectoryValue column, provide the path for the directory name provided on the file server.
    OracleSCMOracleHealthEHR_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.
    OracleHealthEHR_Contants
    • In the DataElementName column, enter the attribute name that’s constant for Oracle Health EHR.
    • In the DataElementValue column, enter the value of constant attribute in Oracle Health EHR.
    These fields are prepopulated for Standard integration.
    OracleSCM_DynamicFields
    • In the OracleHealthEHRField column, enter the attribute name for Oracle Health EHR.
    • In the OracleSCM_ItemClassName column, enter the value of item class code in publish payload from Oracle ERP Cloud.
    • In the OracleSCM_AttributeGroupNode column, enter the value of attribute group name in publish payload from Oracle ERP Cloud.
    • In the OracleSCM_AttributeNode column, enter the value of attribute name in publish payload from Oracle ERP Cloud.
  3. To return to the previous page, click Go back Go Back icon.