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:
  • Oracle ERP Cloud connection
  • Oracle WebCenter Content connection
  • Oracle Health Connection
  • Lookup tables

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 Health Connection

  1. In the Connections section, click the Oracle Health Connection.
  2. In the Properties section, enter the following details.
    Field Information to Enter
    Service Container URL Provide service container URL.
    Environment Select PRODUCTION or STAGING.
    Tenant Domain Enter the tenant domain.
  3. In the Security section, enter the following details.
    Field Information to Enter
    Security Policy OAuth Client Credentials
    Access Token URL Enter the access token URL for the Oracle Health.
    Client Id Provide the client id for the Oracle Health.
    Client Secret Provide the client secret for the Oracle Health.
  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_Dynamic_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
OracleHealthOracleINVTransactionMapping Maps the Oracle Health adjustment reason with Oracle Inventory Cloud transaction type
OracleHealthEHR_NonStocLoc Maps the Oracle ERP Organization with Oracle Health Organization and nonstock location
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.
    • In the ERP_Requisition_BU column, enter the Business unit for the Oracle SCM Organization.
    • In the ERP_Currency_code, enter the Currency Code for Oracle ERP Organization
    • In the ERP_DeliverTo_Location, enter Oracle ERP Location Address name setup for the Oracle ERP Organization
    • In the SCMOrganization_name, enter the Oracle ERP Organization name
    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.
    • In the OracleHealthEHROrg_Loc column, enter the value of Oracle Health EHR Organization and Oracle Health Location separated with :.
    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.
    • In the OracleEHROrg_Loc column, enter the value of Oracle Health EHR Organization and Oracle Health Location separated with a colon (:).
    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
    • Inthe 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.
    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. as

    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.
    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 HealthEHR.
    • In the DataElementValue column, enter the value of constant attribute in Oracle Health EHR.

    These fields are prepopulated for Standard integration. For setting up an additional Spoke System for integration, create a copy of the integration and change the DataElementValue for the row SpokeSystemCode.

    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.
    OracleHealthOracleINVTransactionMapping
    • In the OracleINV, update the mapping for Oracle Health Adjustment type with Oracle ERP.
    OracleHealthEHR_NonStocLoc
    • In the SCM_ORG column, enter the ERP Organization Code
    • In the NonStock_Loc column, enter the non stock location for Oracle health
    • In the OracleHealthEHROrganization column, enter the Oracle health EHR Organization
  3. To return to the previous page, click Go back Go Back icon.