Use Predefined Extensible Flexfield Attributes for Maintaining Healthcare Product Data
You can easily store healthcare and medical devices product data using predefined extensible flexfield attributes for an item in Oracle Product Hub. With this feature, the healthcare item master will also increase the speed and accuracy of integrations and publications with upstream and downstream systems. For example, these attributes can be exposed to self service procurement users when they are searching for items to add to a requisition.
The following healthcare and medical devices attributes have been predefined as extensible flexfields:
- UNSPSC
- UNSPSC Segment
- UNSPSC Family
- UNSPSC Class
- UNSPSC Commodity
- HCPCS
- HCPCS Description
- HCPCS Status
- Chargeable
- Charge Code
- Unit Price
- Base Price
- Markup
- Revenue Code
- Implantable
- Color
- Latex
- Sterility
- Breakable Pack
- Clinical
- UDI Enabled
- Issuing Agency
- Primary DI Number
- Device Count
- Unit of Use DI Number
- Labeler D-U-N-S Number
- Company Name
- Company Physical Address
- Brand Name
- Version or Model
- Catalog Number
- Device Description
- DI Record Publish Date
- Commercial Distribution End Date
- Commercial Distribution Status
- Device Subject to Direct Marking But Excepted
- DM-DI Different From Primary DI
- DM-DI Number
- Secondary DI Issuing Agency
- Secondary DI Number
- Previous DI Issuing Agency
- Previous DI Number
- Package DI Number
- Quantity Per Package
- Package Type
- Package Discontinue Date
- Package Status
- HCT/P Product
- Kit
- Combination Product
- Device Exempt From Premarket Submission
- FDA Premarket Submission Number
- Supplement Number
- Product Code
- Product Code Name
- FDA Listing Number
- GMDN Code
- GMDN Name
- GMDN Definition
- For Single-Use
- Manufacturing Date
- Expiration Date
- Donation Identification Number
- Device Containing Natural Rubber Latex
- Device Without Natural Rubber Latex
- Prescription Use
- Over-the-Counter
- MRI Safety Information
- Size Type
- Size Value
- Size Unit of Measure
- Size Type Text
- Storage and Handling Type
- Low Value
- High Value
- Unit of Measure
- Special Storage Conditions
- Device Packaged as Sterile
- Requires Sterilization Prior to Use
- Sterilization Method
- Public Device Record Key
- Public Version Number
- Public Version Date
- Public Version Status
The following screenshot shows the healthcare and medical devices extensible flexfield contexts.
Healthcare Extensible Flexfield Contexts
You can add the preceding attribute groups to a page in an item class and then navigate to the corresponding page in an item to store the healthcare and medical devices related data.
Healthcare and Medical Devices Attributes on Item UI
This feature benefits your business by the following:
- Provides the ability to innately track the medical device and medical surgical device manufacturing in Global Unique Device Identification Database (GUDID) compliance standards.
- Expedites any necessary configuration for the medical device, medical surgical device manufacturing, and healthcare provider industries.
- Provides the ability to innately store healthcare related attributes used in downstream SCM processes.
- Eases any integrations or communication with the U.S. Food and Drug Administration (FDA) GUDID database and Electronic Health Records (EHR)/Electronic Health Records (EMR) systems by having an allotted OOTB attribute.
Steps to Enable
The following steps are required to enable this feature:
- Run the Upgrade Product Management Data scheduled process with the following options:
- Upgrade Process: Execution
- Functional Area: Item Attribute
- Feature: Healthcare Product Data
- Parameter 1: No
The following screenshot shows the preceding values.
Upgrade Product Management Data Scheduled Process - - Parameter 1 Set to No
This step sets the Protected check box for the predefined attribute groups to No allowing you to associate these groups with pages.
- Associate contexts with pages, add pages to categories (item class), and perform flexfield deployment.
- Run the Upgrade Product Management Data scheduled process again with the following options:
- Upgrade Process: Execution
- Functional Area: Item Attribute
- Feature: Healthcare Product Data
- Parameter 1: Yes
Upgrade Product Management Data Scheduled Process - Parameter 1 Set to Yes
This step sets the Protected check box for the predefined contexts back to Yes.
You can now create an item with the item class associated in step 2 and navigate to the corresponding pages to access the healthcare attributes.
Tips And Considerations
- The extensible flexfield attributes are predefined as Protected.
- Any changes you make on the extensible flexfield's metadata will be overwritten in subsequent release updates.
Key Resources
- Refer to the Extensible Flexfields section in the Oracle Fusion Cloud SCM: Implementing Common Features for SCM 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)
These privileges are new in this update.