Enrich Your Product Information From an External Healthcare Catalog

You can easily enrich your supply chain item master with trading partner information, standardized codes, GUDID information, product classifications, and product operational information using a predefined integration with an external healthcare catalog provider.

Prerequisite

  1. A license agreement with an external healthcare catalog provider.
  1. Deploy existing healthcare library. The standard integration with external healthcare catalog provider works with the predefined healthcare library. For additional details about healthcare library, see Use Predefined Extensible Flexfield Attributes for Maintaining Healthcare Product Data. Two new attributes called Surgical Instrument and Reprocessed have been added to the existing attribute group Healthcare Additional Attributes.

Item Enrichment Process

Following is the process for enriching items:

  1. Product Data Steward performs the following:
    1. Creates a filter using a predefined spoke system called External Healthcare Catalog and predefined attribute called Register with External Healthcare Catalog. Create filters for items that need enrichment with the external healthcare catalog provider.
    2. Schedules the Product Hub Publication Job scheduled process for every four hours to publish the list of items that need enrichment to Oracle WebCenter Content.
  1. External healthcare catalog provider performs the following:
    1. Downloads the zip files using the REST services.
    2. Fetches all manufacturers setup in Oracle Product Hub using the REST service.
    3. Finds the relevant enrichment record based on a match with item description, supplier name, and supplier part number.
    4. Loads a manifest file and a data enrichment file to WebCenter Content. A new predefined read-only import map called Item Enrichment with External Healthcare Catalog will be used in the manifest file.
    5. Invokes the Schedule Product Upload Job scheduled process using the REST service once a day to execute the update on Product Hub and monitor the status of the job. The Product Data Steward can discuss the schedule with external healthcare catalog provider.
    6. Communicates with Product Data Steward for resolution if the record enrichment fails.

The following screenshot shows the item enrichment process with the external healthcare catalog provider.

Item Enrichment With External Healthcare Catalog Provider

Item Enrichment With External Healthcare Catalog Provider

This feature benefits your business by the following:

  • Publishes the SCM item master items to the External Healthcare Catalog seamlessly.
  • Eliminates duplicate items with autocleansing and deduplication capabilities from the External Healthcare Catalog.
  • Enriches item attributes and classifies items quickly and accurately.
  • Quickly find and identify items with well-structured descriptions.
  • Speeds up the ability to transact with the item for your supply chain and clinical processes.
  • Reduces errors due to manual maintenance thereby accelerating the item add and introduction processes.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Product Management

Here are the steps required to enable this feature:

  1. Associate the Healthcare External Enrichment attribute group to the relevant item classes and pages.
  1. Perform flexfield deployment.
  1. Create a validation rule set to check items that has the Register With External Healthcare Catalog attribute value set as Yes or Suspend.
  1. Create a filter using the External Healthcare Catalog spoke system to publish the item from the master organization.
  1. Assign the item validation rule set created in the preceding step to the spoke system.
  1. Schedule the Product Hub Publication Job scheduled process with the External Healthcare Catalog spoke system for every four hours with the parameters as shown in the following screenshot and share the schedule with external healthcare catalog provider.

Product Hub Publication Job Scheduled Process Parameters

Product Hub Publication Job Scheduled Process Parameters

Tips And Considerations

  • The predefined import map Item Enrichment With External Healthcare is read only. Additional attributes and mapping will be available in a future update.
  • Symmetric Health Solutions has built the enrichment service as external healthcare catalog provider. You can find more details on Symmetric Health Solutions on their website.

Key Resources

  • Refer to the Oracle Fusion Cloud SCM Using Product Master Data Management guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • View Healthcare Extensible Flexfields (ORA_HC_EFF_VIEW_PRIV)
  • Manage Healthcare Extensible Flexfields (ORA_HC_EFF_EDIT_PRIV)
  • Manage Item Class (EGP_MANAGE_ITEM_CLASS)
  • Manage Item Rule Set (EGO_MANAGE_ITEM_RULE_SET)
  • Manage Item Source System (EGI_MANAGE_ITEM_SOURCE_SYSTEM)
  • Publish Item (EGI_PUBLISH_ITEM)

User created for external healthcare catalog provider must have the following privileges to process the enrichment:

  • Create Trading Partner (EGP_CREATE_TRADING_PARTNER)
  • Manage Item Manufacturer (EGP_MANAGE_ITEM_MANUFACTURER)
  • Modify Trading Partners (EGP_MODIFY_TRADING_PARTNER)
  • Import Item (EGP_IMPORT_ITEM)
  • Manage Item (EGP_MANAGE_ITEM)
  • Manage Item Attachment (EGP_MANAGE_ITEM_ATTACHMENT)
  • Manage Item Batch (EGI_MANAGE_ITEM_BATCH)
  • Manage Product Upload (EGS_MANAGE_PRODUCT_UPLOAD)