Oracle® Healthcare Provider Supply Chain Analytics

Release Notes

Release 1.0.0.1

E18829-03

December 2010

This document provides a complete, up-to-date description of Oracle Healthcare Provider Supply Chain Analytics (OHPSCA) Release 1.0.0.1. You should read and understand the tasks described here before you begin your installation. Please ensure that you have the most current version before you start.

1 How to Use This Document

This document contains the following information about OHPSCA Release 1.0.0.1:

Features
Instructions for Applying Oracle Healthcare Provider Supply Chain Analytics Release 1.0.0.1
Implementation and User Documentation
Documentation Accessibility

1.1 Target Audience

Department Heads
Information Technology (IT) Heads of Hospitals
System Administrator

1.2 Additional Product Information

This document describes OHPSCA Release 1.0.0.1. You can find related information about this product by referring to the most recent version of your OHPSCA user and implementation documentation. For a list of available OHPSCA documentation, refer to Implementation and User Documentation .

2 Features

Oracle Healthcare Provider Supply Chain Analytics (OHPSCA) Release 1.0.0.1 is an analytical reporting application based on a predefined set of key performance indicators (KPIs), facts, and dimensions with support for predefined and custom reporting. OHPSCA also functions as a decision support system to monitor process bottlenecks and compliance deviations. OHPSCA provides mechanisms to gain operational insights to and evaluate performance of your supply chain, and take corrective action to address problems.

OHPSCA focuses on key performance indicators and measurements that are relevant to the management of Provider Supply Chain data. Using OHPSCA, you can:

Generate predefined analytical reports of key metrics across the Provider Supply Chain spectrum.
Create custom reports quickly by using extensive predefined measures, dimensions and facts.
View all reports through the rich dashboard and report interface of Oracle Business Intelligence Enterprise Edition Plus.
Set targets and monitor supply chain performance against these targets.

2.1 Reports

OHPSCA uses Oracle Business Intelligence Interactive Dashboards and Oracle Business Intelligence Answers to build all its reports. You can view charts and tables, and drill down to further detail as required.

OHPSCA provides 210 predefined reports that focus on the key areas of performance management for Provider Supply Chain management. Table 1 lists the various categories of OHPSCA reports, and describes the function and benefits of the reports.

Table 1 Function and Benefits of OHPSCA Reports

Report	Function	Benefit
Supply Chain Summary Reports	Reports supply chain KPI and high-level summary measures.	Provides a high level summary and snapshot of supply chain performance in the financial, operational, best practice and quality/safety areas. It also shows hospital statistics like admissions and revenue which are they key drivers of supply expense. Shows the trends in the financial, operational, best practice and quality/safety areas.
Contract and Payables Reports	Reports measures related to invoice matching, contract leakage and payable leakage.	Provides visibility into invoice accuracy, how much spend is being done outside the Purchase Order process and how much is being bought outside contract/item master.
Supply Expense Cost Center Reports	Reports measures related to supply expense by cost centers and product category.	Provides visibility into supply expense by cost center. Helps in managing budgets by setting targets on specific reports.
Supply Expense Service Line Reports	Reports measures related to supply expense by service lines like Pharmacy, Radiology, Laundry Purchased Services etc.	Provides visibility into supply expense by service lines. Helps in managing budgets by setting targets on specific reports.
Supply Expense Detail Reports	Reports measures related to supply expense by different dimensions like organization, product category, purchased service category, trends, KPIs like Supply Expense as % Net patient revenue etc.	Provides visibility into supply expense and trends and the operational drivers that affect supply expense.
Cycle Time Reports	Reports measures related to cycle time from product request to delivery.	Provides visibility into cycle time so that appropriate service levels are being met for supply chain operations.
Purchase Order Reports	Reports measures related to Purchase Order activity and value by buyers, suppliers and proportion of Pos that done electronically.	Provides visibility into efficiency and cost of transacting Purchase Orders. Backorder reports help in uncovering potential delays in receiving products. It also provides information of the value of Purchase Order spend by cost center, supplier and product category.
Item Recall Reports	Reports measures related to product recall trends and product recalls by product category and recall authority.	Provides visibility into product recalls.
Requisition Reports	Reports measures related to requisition activity by status, purchasing department and requesting cost center and proportion of electronic requisitions	Provides visibility into volume and value of requisition activity and helps in identifying the source of the demand.
Inventory Reports	Reports measures related to various Inventory performance metrics like movements, physical count discrepancies, balances, consigned inventory, product expirations, product obsolescence and linen utilization	Provides visibility into the efficiency of inventory operations. It provides information whether the product requests of clinical departments are being met on time.
Supplier Performance Reports	Reports measures related to supplier diversity spend tracking, timeliness and accuracy of suplier delivery.	Provides visibility into who are the best suppliers. This information can be used in supplier management.
Contract Utilization Reports	Reports measures related to contract status, contract utilization and contract utilization trends.	Provides visibility into how well supply chain product contracts are being utilized and what is being bought outside contract. This helps in identifying savings opportunities.
Item Utilization Reports	Reports measures related to item master analysis, product delivery reports and supply expense by product and product category.	Provides visibility into how well the item master is being utilized, the relevance of the item master, supply expense by product and product category.

2.2 Dashboards

OHPSCA provides the following dashboards:

01 Summary — Provides a comprehensive collection of reports focused on high-level supply chain key performance indicators.
02 Financial Performance — Provides a comprehensive collection of the reports focused on supply expense trends by product category and service lines.
03 Operational Performance — Provides a selection of reports focused on requisitions, purchase order activity and product recalls
04 Inventory — Provides a selection of reports focused on inventory performance including fill rate, consigned inventory and linen utilization.
05 Supplier — Provides a selection of reports focused on supplier performance and diversity spend tracking.
06 Contracts — Provides a selection of reports focused on contract utilization and performance.
07 Products — Provides a selection of reports focused item master utilization and spend analysis by product and product category

2.3 Data Warehouse

The OHPSCA data warehouse is prebuilt and consists of dimensions, facts, and associated measures.

2.3.1 Dimensions

OHPSCA uses dimensions to qualify measures, which are frequently associated with the use case of "Show my metric X, by dimension Y." Table 2 describes the primary, non-system dimensions included in OHPSCA.

Table 2 OHPSCA Dimensions

Dimension	Description
AP Spend Classification	The spend classification used in Accounts Payable.
BusinessUnit	BusinessUnit associated with the measure. BusinessUnit is an internal organization. For example it can be a group of departments, one or more hospitals and so on.
Buyer	The Purchase Buyer associated with the supply chain transaction.
Case Type	The case type associated with the measure. A Case is a logical sequence of interrelated interventions performed in a contiguous manner on a patient by service provider(s) to which supply consumption or equipment usage is associated.
Company	The Company associated with the measure. Company is a type of internal organization.
Contract Leverage Type	The bargaining position or advantage used in the contract negotiation. For example it could be price, quality, size of business.
Contract Status	The contract status, for example, active, expired.
Cost Center	The cost center is a type of internal organization against which supply chain transactions are tracked. For example, Cath Lab, Interventional Radiology, Operating Room 1.
Date	The date associated with the measure. It can be of two of types - calendar and fiscal.
Department	Department is a type of internal organization. For example, Pharmacy, Radiology, Laundry Services.
Enterprise	Enterprise is a type of internal organization. For example, University Health System.
Expense Classification	A type of expense classification like the Medical Supplies, Surgical Supplies.
GL Account	This stores the internal general ledger accounts. For example 1000 - Cash, 2000 - Asset.
Inventory Business Unit	This dimension stores the different Inventory Business Units. Each inventory business unit has its own inventory business management rules, warehouse, storage locations, and products. For example INVBU1, INVBU1, Main Stores.
Inventory Movement Type	Contains the different movement types. For example, Issues, Receipts, Stocking, Transfers.
Inventory Organization	A type of internal organization hierarchy. For example, East Region > Hospital1 > INVBU1.
Invoice Approval Status	The status of the invoice approval. For example, Approved, Pending Approval, Cancelled, Denied, Hold.
Invoice Match Status	The match status of the invoice. For example, Matched, Unmatched, Partially Matched, On Hold.
Invoice Requestor	Stores information about the invoice requestor.
Invoice Transaction Type	The type of Invoice Transaction. For example, Purchasing Invoice, Payroll Invoice, Manual Entry.
Last Receipt Date	Stores information about the last receipt date.
Ledger	Stores information about the ledgers. The ledger stores the final financial information about the organization after the fiscal period is closed.
Linen Status	Contains the different statuses of Linen transactions. For example, Issued, Leakage, Waste.
Manufacturer	The manufacturer dimensions stores information about the external organization that makes the product.
Match Type	Stores the different match types. For example, 2-way, 3-way,4-way.
Operating Organization	The operating organization is a type of internal organization at which operations are managed as an unit. For example, University Health System Main Hospital, Community Care Center
Patient Meal	Stores information about Patient Meals
Procedure	Stores the different procedure types
Product	Product stores information about the Products of various product types for example, Finished Goods, Raw Material and other types of Products from the CRM, ERP and other source systems.
Purchase Approval Status	Stores the different statuses of Purchase Approval. For example, Requested, Pending Approval, Approved, Denied
Purchase Cycle Status	Stores the different statuses of Purchase Cycle. For example, Initial, Approved, Purchased
Purchase Line Type	Stores the different types of a Purchase Line. For example, expense, asset, amount only.
Purchase Order Transaction Type	Stores the different Purchase Order Types. For example, Blanket PO, Regular, Rush PO, Bill Only PO, Inventory PO
Purchase Receipt Transaction Type	Stores information about the different transaction types of the Purchase Receipt transaction. For example Manual, Electronic, Blind Receipt
Purchase Requestor	Stores information about the Purchase Requestor
Purchase Requisition Transaction Type	Stores information about the Purchase Requisition Transaction. For example, it stores the name, type, description of the Purchase Requisition transaction.
Purchasing Category Code	The internal Purchasing Category code. For example, Medical Supplies, Surgical Supplies, Janitorial Services.
Purchasing Organization	An internal organization used for Purchasing.
Recall Authority	An organization that issued the recall. For example, FDA, EPA.
Recipient Location	Stores information about the recipient location of where goods and services are delivered like the address, phone information.
Requisition Approval Status	Stores the different requisition approval status'. For example, Pending Approval, Approved, Complete.
RMA Status	Stores the different status of the Return Material Authorization document. For example, Complete, In Progress.
Service Line	Stores the different service line names.
Status	Stores different status' for Purchase Requisition From and Purchase Requisition To documents.
Storage Location	Stores identifying information about an inventory storage location, like address, phone.
Supplier	Stores information about the Supplier like name, address, phone, diversity.
Supplier Account	Stores various accounts for a Supplier used in the purchasing and payment processes.
Supplier Acknowledgment Status	Stores the different statuses of a supplier acknowledgement status. For example, Backordered, Accepted, Rejected
Supplier Performance Manager	Stores identifying information about a Supplier Performance Manager like name, address, phone, job title
Supplier Product	Stores the information related to the different products provided by a Supplier like part number, price, unit of measure.
UNSPSC	Stores the information related to the code and name of the UNSPSC product classification hierarchy.

2.3.2 Facts

There are 24 base facts, pre-built in the OHPSCA 1.0.0.1 data mart. Facts are used to store metrics and related information about products, purchasing, contracts, and expense and spend. In addition there are aggregate facts that enable dashboard and report performance. Table 3 lists the OHPSCA base facts.

Table 3 OHPSCA Base Facts

Base Fact	Description
Accounts Payable	Stores the AP invoice data such as invoice amount by line item, cost center, supplier, location, and purchase order.
ADT Information	Stores information about admissions, discharges at the level of the operating organization.
Contract	Stores the current status of a contract. This table can be used to find contracts that are about to expire, by cost center, contract manager, line item, product, supplier and various internal organizations.
Contract Status	Stores all the states of the contract such as new, renew, expired, etc. This table can be used to find contracts that are about to expire, by cost center, contract manager, line item, product, supplier and various internal organizations.
Dietary Supply Expense	Stores supply expense is stored for each product that is a part of any patient meal transaction. Supply expense is stored for each product per patient meal transaction.
Inventory Transaction	Stores daily information about transactions that occur during a product's lifecycle at an inventory location of a business organization. The key information includes the different inventory movement types, the date of occurrence, cost center, and the quantity and value of the inventory transaction.
Inventory Balance	Stores daily information of all inventory balances and inventory values. This information includes quantities and values of different types of inventory such as available, consigned and obsolete inventory including that of consigned inventory.
Inventory Balance Monthly	Stores monthly information of all inventory balances and inventory values related to products whose inventory is maintained by the business organization. This information includes quantities and values of different types of inventory like available, consigned and obsolete inventory, including that of consigned inventory.
Laboratory Supply Expense	Stores laboratory supply expense for each product. The expense classifications are laboratory supplies, radiology supplies, and medical gases.
Laundry Supply Expense	Stores laundry related product supply expense. The expense classifications are laundry supplies, laundry replacement supplies, purchased services.
Linen and Laundry Inventory	Stores the linen product related transactions that occur during a linen lifecycle at an inventory location of a business organization.
Physical Count Inventory	Stores information about the physical count process in an inventory organization. The data are stored at the level of a count date, count event, inventory organization and contains data about discrepancies (variance) between system count and physical count.
Procedure Supply Expense	Stores the procedure supply expense for each product per procedure transaction in a case. Product supply expense type is identified by expense classification.
Product Expirations, Lots, Recalls	Stores the batch number by product by various internal organizations.
Purchase Cost	Stores the purchase cost-related information that is distributed on the basis of the amount or the value by the purchasing unit of a business organization. There can be many types of purchase orders and may include one-time, regular, blanket, release, etc. The data in this table are stored at the purchase order distribution level. Purchase orders, or the shipments, are distributed among different receivers, accounts, or cost centers.
Purchase Delivery	Stores the delivery schedules on purchase orders that are raised on suppliers by the purchasing unit of a business organization. The types of purchase orders include but are not limited to one-time, regular, blanket, release etc. The data in this table is stored at the purchase order, product line item and delivery schedule level.
Purchase Order	Stores the purchase orders that are raised on suppliers by the purchasing unit of a business organization. The types of purchase orders include but are not limited to one-time, regular, blanket, release etc. The data in this table are stored at the purchase order product line item level.
Purchase Process	Stores the time duration of all events pertaining to the purchase process commencing with a requisition. Information in this table enables analysis of the direct spend process within an organization beginning with a purchase requisition, its approval, the creation of an approved purchase order, its submission to a supplier, the creation of a purchase schedule and ending with its receipt of the products.
Requisition	Stores the purchase requisitions that are raised by the various departments of a business organization. The types of purchase requisitions include but are not limited to one-time, regular, online etc. The data in this table is stored at the purchase requisition product line item level.
Requisition Cost	Stores the purchase requisition costs that are distributed to the various departments of a business organization The types of purchase requisitions include but are not limited to one-time, regular, online etc. The data in this table is stored at the purchase requisition product line item level.
Requisition Status	Stores data regarding requisition status with various actions performed as it passes through the stages in its life cycle. The data in this table are expected to be dynamic in nature during the related cycles of the requisition.
Revenue and Expense	Stores information about revenue, expenses and margin at operating organization level.
Supplier Spend	Stores the tier-two supplier spend by supplier diversity. Data in this fact are stored per month.
Supply Expense	Stores daily product supply expense for the enterprise. Expense classifications under which supply expense can happen, are stored in this fact table.

3 Instructions for Applying Oracle Healthcare Provider Supply Chain Analytics Release 1.0.0.1

Refer to the Oracle Healthcare Provider Supply Chain Analytics Installation Guide Release 1.0.0.1 for detailed instructions on how to install and set up the OHPSCA application.

4 Implementation and User Documentation

For further information about Oracle Healthcare Provider Supply Chain Analytics, please refer to the following user documentation:

Table 4 OHPSCA User Documentation

Part Number	Title	Contents
E18656-03	Oracle® Healthcare Provider Supply Chain Analytics Installation Guide	Describes how to install and access Oracle Healthcare Provider Supply Chain Analytics.
E18655-03	Oracle® Healthcare Provider Supply Chain Analytics User and Administrator Guide	Describes how to use and administer Oracle Healthcare Provider Supply Chain Analytics.
E18829-03	Oracle® Healthcare Provider Supply Chain Analytics Release Notes	Contains important information that was not included in the documentation for this release of Oracle Healthcare Provider Supply Chain Analytics.
E18810-02	Oracle® Healthcare Provider Supply Chain Analytics Release Content Document	Describes the features of Oracle Healthcare Provider Supply Chain Analytics.
-	Oracle® Healthcare Provider Supply Chain Analytics Electronic Technical Reference Manual	Contains table, keys, indexes, and column descriptions.

You can view these documents in the Oracle® Healthcare Provider Supply Chain Analytics (OHPSCA) Online Documentation Library on Oracle Technology Network (OTN). To view the library:

Navigate to the Oracle Technology Network Web site:

http://www.oracle.com/technology/index.html
Point to the Support tab, and click the Documentation hyperlink.
Scroll down to the Applications section and click Oracle Health Sciences.

Alternatively, you can go to the Oracle Health Sciences documentation page at: http://www.oracle.com/technetwork/documentation/hsgbu-154445.html
In the Oracle Healthcare Provider Supply Chain Analytics section,

Click View Library to view the Oracle Healthcare Provider Supply Chain Analytics Online Documentation Library.

Or

Click Download to download a copy of the documentation library.

Note:

Always check the Oracle Health Sciences Documentation page to ensure you have the latest updates to the documentation.

5 Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/support/contact.html or visit http://www.oracle.com/accessibility/support.html if you are hearing impaired.

Oracle® Healthcare Provider Supply Chain Analytics Release Notes, Release 1.0.0.1

E18829-03

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.